Skip to Content

How to use dynamic odata query in SFSF lookup channel?

Dec 08, 2016 at 11:20 AM


avatar image
Former Member

To be specific i am able to use the where clause dynamically via $filter=filter in the query.But the table name and the field names to be fetched are not dynamic.We have to hard code table name and field names in the lookup channel.Hence we had to use multiple lookup channels for multiple fields if table names are different.We had use three different queries likewise:

Operation Query1:FOEventReason?$select=externalCode,event&$filter=filter

Operation Query2:FOCompany?$select=externalCode,event&$filter=filter

Operation Query3:FOLocation?$select=externalCode,event&$filter=filter

Please let me know if there is any probable solution to do this via single unique lookup channel.

10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

0 Answers