Skip to Content
avatar image
Former Member

How to use dynamic odata query in SFSF lookup channel?

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.

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

0 Answers