Hiya,
Im having a problem using an Airtable API https://airtable.com/ to pull data into FME. I have followed a similar solution to a previous API link, yet Im getting this error below. Can anyone help with the below?
JSONFragmenter(JSONQueryFactory): A JSON syntax error was found at line 5, column 9
JSONFragmenter(JSONQueryFactory): Unexpected character: 'v'. One of the following characters was expected: '"', '}'
The below feature caused the translation to be terminated
Hi @cfordigan, could you share your template Workspace?
I did enter the Website https://airtable.com/ and select the Airtable API. Wich one Standard API - Airtable do you want?
Thanks,
Danilo
Hi Danilo,
Please see an extract of the workspace, Im not sure the key is working and please ignore the Ragic comments. Ragic was the old database, Airtable is the one we want to replace it with
I havent applied the API key to the above as it has all of our data contained within it. Are you able to review the workflow and let me know if it should work?
Thankyou
Hi @cfordigan, could you share your template Workspace?
I did enter the Website https://airtable.com/ and select the Airtable API. Wich one Standard API - Airtable do you want?
Thanks,
Danilo
Hi Danilo,
Please see an extract of the workspace, Im not sure the key is working and please ignore the Ragic comments. Ragic was the old database, Airtable is the one we want to replace it with
I havent applied the API key to the above as it has all of our data contained within it. Are you able to review the workflow and let me know if it should work?
Thankyou
I executed your Workspace in my machine and i noted that the attribute _response_body doens't contain information in Json = Family Type Prefix, Component Type and ID.
danilo@inovacaogis.com.br
Hi @cfordigan, did you do anything?
Hi Danilo, Sorry was offline, I have included you in the Airtable link now. I wonder if there is something about the fact Im not on the paid Airtable subscription
Hi @cfordigan, thanks to add my email.
I saw the documentation API for Airtable API API - Documentation and see that needs to generate a Key to see all tables from your document.
In section Account i generated the key and put into transformer HTTPCaller the string with my Key. After the transformer AttributeKeeper_4 the structure JSON is possible to see:
Thanks,
Danilo - 9910-airtable-test-version-danilo.fmwt
Hi Danilo, Sorry was offline, I have included you in the Airtable link now. I wonder if there is something about the fact Im not on the paid Airtable subscription
Hi @cfordigan, thanks to add my email.
I saw the documentation API for Airtable API API - Documentation and see that needs to generate a Key to see all tables from your document.
In section Account i generated the key and put into transformer HTTPCaller the string with my Key. After the transformer AttributeKeeper_4 the structure JSON is possible to see:
Thanks,
Danilo - 9910-airtable-test-version-danilo.fmwt
Hi @cfordigan, thanks to add my email.
I saw the documentation API for Airtable API API - Documentation and see that needs to generate a Key to see all tables from your document.
In section Account i generated the key and put into transformer HTTPCaller the string with my Key. After the transformer AttributeKeeper_4 the structure JSON is possible to see:
Thanks,
Danilo - 9910-airtable-test-version-danilo.fmwt
Hi @cfordigan, did you see the Template file? Thanks
Hi Danilo, Sorry was offline, I have included you in the Airtable link now. I wonder if there is something about the fact Im not on the paid Airtable subscription
Hello @cfordigan the workspace is good for you?
thanks
Thanks
Hi Danilo, Sorry was offline, I have included you in the Airtable link now. I wonder if there is something about the fact Im not on the paid Airtable subscription
Thanks