We are using CData’s JSON ODBC Driver for SQL Server and it works perfectly. Complete ETL automation including scheduling within SQL Server. I would recommend downloading the trial to see if you can get it working prior to purchasing.
...
I was able to get this working with the exception of 2 things:
I cannot figure out how to bring in the Record ID for each row. Is there something I need to enable on the Airtable side or is it something in the code?For my columns that are lookups, I...
