Input the API endpoint URL in the 'Enter request URL' field.Select the method (the action type) from the dropdown.Make a GET request into the postman and save the response into JSON format. Use the file to help build the first RSD of your API Query Profile.Use Postman (or cURL) to get a response back from the API endpoint you are trying to interface with, and save that data as a JSON or XML file.īefore we start creating a new profile, please make sure you download and save the response in JSON format, as example 'finance.json'. This can be accessed from a web browser by navigating to the URL. This API is simple, universally available, and requires no authentication.The API returns a finance chart with specific details and is returned as a JSON document with a nested array. We will be using an Open API Endpoint Finance API as an example to generate RSD file in this guide. Load and Save the JSON response of the API Load and Save the JSON response of the API.Integrating with a new API includes following process: Matillion's API integration is known as an 'API Query' and is managed through the Project → Manage API Profiles → Manage Query Profiles. APIs in which the returned content is encoded or encrypted.APIs which return XML embedded inside JSON, or vice versa.APIs where the data contains embedded CSVs.Binary or unstructured data, such as PDF or Word documents, or images.Matillion's API Query CANNOT load data from:

How to paginate and save header in word