Import API data to Exploratory

Hi Guys!

Could you please tell me how I can import data from API, Rest API, to Exploratory. Because my API requires X-key for authorization ( I have it) but Exploratory does not allow to enter it anywhere.

Could you please recommend me how to do it correctly so I can proceed to work with Exploratory?

Thank you so much and look forward to hearing from you soon.

1 Like

If you want to call REST API with GET method from Exploratory, you might want to try R Script Data Source.

Below is an example to get articles from NYTimes. (ref: https://cran.r-project.org/web/packages/jsonlite/vignettes/json-apis.html)

So in this example it passes api-key as part of the URL so you can do similar thing when you want to pass X-key (assuming it can be passed as a URL parameter)

1 Like