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?

Beginner Asked on August 7, 2019 in Diyotta Studio.
Add Comment
1 Answer(s)

Considering General Diyotta rest API extraction and loading into any database. Below are the steps to be followed.

    1. 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.

RE: Extracting data from a REST API data point

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,

RE: Extracting data from a REST API data point

JSON schema file from above response have been created and imported in Diyotta to create  JSON data object.

RE: Extracting data from a REST API data point

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.

RE: Extracting data from a REST API data point

RE: Extracting data from a REST API data point

Expert Answered on August 8, 2019.

Thanks! This helps me get 50 records only, which is the first page records. How do I get all the records?

on August 11, 2019.
Add Comment

Your Answer

By posting your answer, you agree to the privacy policy and terms of service.