Feb 19, 2021 08:35 AM
We are looking for ways to pull data from our Linnworks.NET account (basically and order and inventory management platform) to Airtable. So far we have been using MiniExtensions to import csv files with data exported from Linnworks to Dropbox or FTP server. This has worked well, but MiniExtenions have a limit of 10 instances of their csv import app, meaning that we are limited in the type of data we can import. We have already hit this limit.
I realise that the best solution for transferring data would be via api, but I am not yet very familiar yet with writing api calls. The big stumbling block to this going ahead, from what I can see, is managing Linnworks Authorization. Linnworks Developer Resources - API Home
My question is a general one. Does Airtable scripting allow means to acquire auth tokens and use them in subsequent calls to Linnworks.NET for data, or would we need a 3rd party app as a go between?
Thanks in advance for any help or insights here.
Feb 19, 2021 08:58 AM
Hi @Dominic_Rannie, and welcome to the community!
Yes. But… the script must factor in the responses and the security workflow to accommodate such integrations.
I’ve never worked with Linnworks API but I suspect it’s pretty straightforward -
This approach completely bypasses the need to push to FTP or a file system so there are more advantages than simply the ability to scale beyond ten instances of the integration process.
Feb 19, 2021 09:53 AM
Many thanks Bill for your prompt response. I do realise that by developing an api connection we there are suddenly a whole number of possibilities to expand what we are already doing with Airtable. I already have quite a long list of applications in mind! For this reason I feel it would be well worth the time I would need to invest to understand how these scripts are built.
Feb 19, 2021 10:43 AM
Any type of security-related information should be abstracted away from the app itself. Databases are a terrible choice if security matters. Airtable provides a script properties environment for managing authentication data and I’ve also experimented with encrypting such values as well in Airtable script blocks.
My hunch is Linnworks already has some good examples and forum content to guide your move in this direction.