Question

FME JSon Fragmenter

C
Badge

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

14 replies

redgeographics
Rank
Userlevel 5
Badge +25
Can you post the JSON here as well? That way there's a better chance somebody here can help you out.

 

 

danilo_fme
Rank
Userlevel 4
Badge +30

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

C
Badge

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

airtable-test.fmw

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

C
Badge

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

Danielo, If you send me your email address, I can grant you access to the data

 

 

danilo_fme
Rank
Userlevel 4
Badge +30

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

airtable-test.fmw

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, Thanks your file fmw.

 

 

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_fme
Rank
Userlevel 4
Badge +30
Danielo, If you send me your email address, I can grant you access to the data

 

 

 

danilo@inovacaogis.com.br
danilo_fme
Rank
Userlevel 4
Badge +30
Danielo, If you send me your email address, I can grant you access to the data

 

 

 

Hi @cfordigan, did you do anything?
C
Badge

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

danilo_fme
Rank
Userlevel 4
Badge +30

 

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:

 

And the Workspace was run without error

 

Attached the Workspace template.

 

 

Thanks,

 

Danilo - 9910-airtable-test-version-danilo.fmwt
danilo_fme
Rank
Userlevel 4
Badge +30

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:

 

And the Workspace was run without error

 

Attached the Workspace template.

 

 

Thanks,

 

Danilo - 9910-airtable-test-version-danilo.fmwt
danilo_fme
Rank
Userlevel 4
Badge +30

 

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:

 

And the Workspace was run without error

 

Attached the Workspace template.

 

 

Thanks,

 

Danilo - 9910-airtable-test-version-danilo.fmwt

 

Hi @cfordigan, did you see the Template file? Thanks
danilo_fme
Rank
Userlevel 4
Badge +30

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

 

 

danilo_fme
Rank
Userlevel 4
Badge +30
Hello @cfordigan, Solved it your problem?

 

Thanks

 

danilo_fme
Rank
Userlevel 4
Badge +30

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, Solved it your problem?

 

Thanks

 

Reply


Community Stats

28,669
Posts
109,361
Replies
36,531
Members
Terms & ConditionsCookie settings
A product of
Safe Software respectfully acknowledges that we live, learn and work on the traditional and unceded territories of the Kwantlen, Katzie, and Semiahmoo First Nations.