Extracting data from a REST API data point
I have established a REST API connection with Shopify which is a SaaS based platform. How do I get data from the tables that Shopify has in its backend? For instance, if I wanted to retrieve information about its Orders, Customers, how do I go about that?
Considering General Diyotta rest API extraction and loading into any database. Below are the steps to be followed.
- Create Rest Datapoint to configure connectivity to Restful API services. Choose required authentication Type and accordingly authentication details like user credentials, access key etc needs to be provided. Give REST Webservices URI based on the URI you want to extract data from.Refer https://help.shopify.com/en/api/reference to find the shopify URL for the tables.
2. Based on the response from webservices URI create schema file for the response and use it in import Data object wizard to create the Data Object. File, JSON or XML formats are supported as Rest objects. The Rest API data point will be associated to File, JSON or XML data objects which would represent the format and structure of response from Restful API service.Orders, customers etc API’s can be used from shopify. Below is facebook datafile and json data object reference,
JSON schema file from above response have been created and imported in Diyotta to create JSON data object.
3.Create a dataflow with rest source( FILE/JSON/XML) and target as required database where data needs to be loaded.
4. Select source–>Click on Rest Properties and give rest extraction details as per requirement. Rest headers can also be included here.