Hi, I have some trouble with my odata endpoint queries in data actions.
I have an Azure SQL DB which I want to query from GC via a Data Action.
I have created an odata endpoint which I would like to use to query my SQL DB table for calling number.
The odata query url is looking like the following:
But if I create a Data Action with this URL $filter is not a correct syntax for the request url template.
So I tried to find the correct syntax for $ sign but couldn't find a solution.
The other option I would like to use is to put the odata query filter into request body of a POST request.
Can anybody help me to do this? How is the correct syntax of the request body and which Headers do I have to set?
Thanks in advance!
Tobias
For URL (escaping special characters): space should be escaped into %20, and ' (single quote) should be escaped into %27.
You can use the escape velocity macros.
But as the characters to escape are not in your input parameter (i.e. input.ani), you could set them directly as desired in the requestUrlTemplate (Data Action Request Configuration).
Example 1:
URL you want to query: https://ODataServerEndpoint/DBTable?$filter=contains(callingNumber,'123456')
This url would be escaped as: https://ODataServerEndpoint/DBTable?$filter=contains(callingNumber,%27123456%27)
Your requestUrlTemplate can be set to: https://ODataServerEndpoint/DBTable?${esc.dollar}filter=contains(callingNumber,%27${input.ani}%27)
Example 2:
URL you want to query: https://odataserverendpoint/DBTable?$filter=callingNumber eq '123456'
This url would be escaped as: https://odataserverendpoint/DBTable?$filter=callingNumber%20eq%20%27123456%27
Your requestUrlTemplate can be set to: https://ODataServerEndpoint/DBTable?${esc.dollar}filter=callingNumber%20eq%20%27${input.ani}%27