Entity Name in query Entiry to be passed dynamically

4 replies
15 views

Hi,

Is it possible to pass the entity name dynamically or using the table in query entity?

May be have some rule which will take the table name and return the data store entity.

Regards,

Mukesh

amans0009

Participating Frequently

I am not sure but are you looking for this?

M

mukeshr0002Author

Inspiring

Hi,

I am building api which takes the output from multiple tables and can't create multiple API for this. So approach is to have one api using query entity and from the system it is being invoked we will pass the entity name or table name to API as query parameters.

harshitb6843

Brainy

You can still use what Aman mentioned by defining a constant against the name. Please understand that on Appian, you cannot refer the entity with just the name and you need a pointer (constant in this case) so you'll have to involve it anyhow.

Now you can use an expression as shown or you can build a decision object that takes the name as input and returns the required constant

abhayd3663

Brainy

Entity name can be provided dynamically using rule input to query entity rule.

1. Create RI of type DSE.

2. Provide DSE constant while calling the queryEntity rule. You can have DSE constant with multiple values and provide appropriate index. E.g. cons!DSE_EMP[1] etc.

Sign up

Login with SSO

Login to the community

Login with SSO