How to import data from Shopify's API?

FAQ
1

This is a temporary FAQ post to help any customers who want to import their Shopify data into Parabola.

We’re hard at work building a native integration, you can see the latest status on this post. Don’t forget to follow that post to be notified when the integration launches!

In the meantime, you can still use our Shopify beta step that helps you import your Shopify data by connecting to Shopify’s API.

Screen Shot 2020-04-27 at 4.32.03 PM
Screen Shot 2020-04-27 at 4.32.03 PM2872×1538 362 KB

Here are the instructions for how to set it up:

  1. Login to your Shopify store
  2. Click on the Apps section of the sidebar
  3. At the bottom click “Manage private apps”
  4. Click to create new private app
  5. Give it a name and make sure the Admin API permissions are set to be able to access the things you want
  6. Copy the Example URL that shows up and paste it in the API Endpoint URL field of the beta step. The URL contains the API Key and password to access the data for your Shopify store. Make sure to select “None” in the Authentication dropdown.

Sample endpoint URL:
https://YOUR_API_KEY:YOUR_API_PASSWORD@YOUR_STORE.myshopify.com/admin/api/2019-07/products.json
7. Click the blue “Show Updated Results” button and you should see your Shopify data!

Alternatively, you can pass your API Key and Password in the Username and Password fields in the step by selecting “Username/Password” in the Authentication dropdown instead. You’ll want to paste just the API Key part of your URL in the Username field and paste the API Password part in the Password field. If you go this route, you can remove the API Key and API Password portion from the endpoint URL.

One more note - When consulting Shopify’s API docs, make sure to use Shopify’s 2019-07 api version for Parabola:

Screen Shot 2020-04-27 at 4.50.11 PM
Screen Shot 2020-04-27 at 4.50.11 PM2880×726 180 KB

3 Likes
5

Wanted to add an example here to supplement Sachi’s post!

Let’s say that we wanted to update the title and price of an existing variant. While we do have the native integration up and running, this automation would still currently require the Pull from API step (until we expand the native integration further!).

We would start by referencing Shopify’s REST API reference to find the specific endpoint that accomplishes what we hope to achieve.

Screen Shot 2021-04-19 at 4.57.16 PM
Screen Shot 2021-04-19 at 4.57.16 PM1630×1194 117 KB

In this example, your endpoint would be https://YOUR_API_KEY:YOUR_API_PASSWORD@YOUR_STORE.myshopify.com/admin/api/2021-01/variants/{Variant: ID}.json. “Variant: ID” would be the column that you reference here in the endpoint.

Your request body would be:

{
"variant": {
"id": "{Variants: Id}",
"price": "{Variants: Price}"
}
}

You can find the proper request body by referencing Shopify’s endpoint documentation, and can substitute their static values for your dynamic values by referencing columns in curly brackets, as seen above.

Finally, be careful to pay attention to what type of request Shopify is telling you to make (ie. POST, PUT, PATCH).

Feel free to reply to this thread, or send us an email at support@parabola.io, if you run into any trouble setting up this integration!