I am planning to use a data action connect to a third party API (client's API) and fetch a response. However, the response looked complex (containing nested arrays and objects ).
Do data actions allow this?
Also, apart from whitelisting certain IPs and ensuring that the end API should be restful , is there generally any other pre-requisite for a data action?
Here is the requirements page, you are probably going to want to click on the "Web Services" tab.
Data actions can often (but not always) handle complicated results. This is done by using JSONPath to extract out the part of the response that you want, and then velocity templates to create your final output. I recommend using https://jsonpath.herokuapp.com/
to determine the JSONPath to use to extract out the part of the response you want.
Feel free to post JSON that you want help with. This is a public forum, so replace anything sensitive with example data and post what you are trying to accomplish and what you have tried.
Thanks Jason .
I will surely supply the json as I receive it .
The client does not want to expose their APIs over public internet .
I guess , this will restrict us from doing a data dip on their API. Any suggestions on how to manage this ?
So there are a couple of approaches you can take. First, we have added a number of security features to data actions that might make the customer more comfortable with exposing their API publicly: