Octoparse to Airtable: An Existing Table

Overview

This app retrieves data from a designated Octoparse task and synchronizes it to an existing Airtable table. Whether you need to transfer a small dataset or up to 1,000 records, this app provides a streamlined solution to integrate Octoparse with Airtable, ensuring your data is accessible and up-to-date in your Airtable workspace.

How to Use

1. Acquire the app from Octoparse AI app store

2. Launch the app in your list.

   

   1. Parameter description

      

      1. octoparseUsername: Your Octoparse account name or email.

      2. octoparsePassword: Your Octoparse account password.

      3. octoparseTaskId: The ID of the Octoparse task to sync data from.

      4. dataSize: The amount of data to sync, ranging from 1 to 1,000.

      5. personalAccessToken: Airtable personal access token. Refer to the "How to Get a Personal Access Token" guide for details.

      6. tableId: The ID of the Airtable table to sync data to. Refer to the "How to Get the Table ID" guide for details.

      7. baseId: The ID of the Airtable base. Refer to the "How to Get the Base ID" guide for details.

   2. Click ‘Run application’.

3. Output

   This app will:

   • Sync data from the specified Octoparse task to the chosen Airtable table.

   • Match and update the corresponding fields in Airtable based on the field names provided in the Octoparse task.

Notes

• Octoparse account must be Standard Plan or higher

• The maximum number of rows that can be accommodated in an Airtable table varies depending on your Airtable plan. If the data from your Octoparse task exceeds the row limit of your current Airtable plan, the data may not be fully synchronized to Airtable. Please click here to view the row limits for each Airtable plan.

• Please ensure that the field names of your target spreadsheet correspond to the field names specified in your Octoparse task, otherwise data synchronization may not be possible.

How to Get the Base ID

The part starting with "app" in your Airtable table URL is the baseId.

How to GET the Table ID

The part starting with "tbl" in your Airtable table URL is the baseId.

How to Get a Personal Access Token

4. In your Airtable table, click your avatar, and select Developer hub from the dropdown menu.

   

5. In the new page, click the Create new token button at the top right.

   

6. Name your token.

   

7. Click Add a scope, and configure the permissions for this personal access token. Be sure to select “data.recordComments” and “schema.bases” to enable table creation and data writing.

   

8. Click Add a base, and select the base where the new table will be created.

   

9. Click Create token, and copy the generated token. Note that the token is displayed only once, so keep it safe.

   

   Troubleshooting

   Encounter obstacles but don't know how to resolve them when executing the app?

   Please contact our support team at [email protected] to find the way out!