Adding Product List to Airtable

Overview

This workflow describes how to use the Products API to get product list for a hub or a producer and add it to Airtable.

Workflow can be run on a schedule or can be triggered using webhooks.

Description

For the workflow, I will be using a table in Airtable with following fields:

  • Product

  • Variant

  • Producer

  • sku

  • Stock Level

  • Price

  • Product Id

  • Variant Id

Prerequisites

To set up this integration you will need:

OFN API Authentication

Airtable API key and Airtable base with exact same fields as used in the SET module

Workflow

Find the workflow code for download and import here.

How to use/adapt the workflow

Trigger: Can be manual/scheduled/webhook

HTTP Module (Get Bulk Products): Add/use existing OFN credentials. By default it will give all the products the user has access to. To filter by enterprise, use “q[supplier_id_in]” in the query parameters as shown below

Set module: Add the field you want to have in Airtable.

Airtable module:

Credential: Use or add existing Airtable credential

Operation: Append Base: URL: Open the table you want to get the data in and copy the web URL of the page.

Last updated