Skip to main content
M
mukeshr0002
February 10, 2023
Question

Entity Name in query Entiry to be passed dynamically

  • February 10, 2023
  • 4 replies
  • 0 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

4 replies

amans0009
amans0009
February 10, 2023

I am not sure but are you looking for this?


M
mukeshr0002Author
February 10, 2023

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
harshitb6843
February 10, 2023

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
abhayd3663
February 10, 2023

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.

Terms & ConditionsAccessibility statement