Accessing REDCaps rest API from azure data factory

Question

I am trying to build a pipeline where my source is a rest API, namely REDCap. I want to make a post request to the API to get some information and store it in a csv file. I have set up my linked service and dataset but when trying to preview the data, I am receiving error 403:
Rest call failed with client error, status code 403 Forbidden, please check your activity settings. You do not have permissions to use the API.
I am not sure if I have configured something incorrectly, although I have tried numerous different methods. Please could someone advice on the above - would be much appreciated.

Answer 1

@Jamie - Thanks for the question and using MS Q&A platform.

It seems like you are receiving a 403 error when trying to preview data from your REST API source in Azure Data Factory. This error indicates that you do not have the necessary permissions to use the API.

To resolve this issue, you may need to check the authentication method you are using to access the API. You may need to provide credentials or a token to authenticate your request.

Additionally, you may need to check if the API endpoint is correct and accessible from your Azure Data Factory environment. You can try testing the API endpoint using a tool like Postman or cURL to ensure that it is working correctly.

If you have already checked these things and are still receiving the error, you may need to contact the API provider to ensure that your account has the necessary permissions to access the API.

For more details, refer to Copy and transform data from and to a REST endpoint by using Azure Data Factory.

Hope this helps. Do let us know if you any further queries.

---

If this answers your query, do click Accept Answer and Yes for was this answer helpful. And, if you have any further query do let us know.