Skip to main content
Question

FME JSon Fragmenter

C
Forum|alt.badge.img

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
Celebrity
Forum|alt.badge.img+49
Can you post the JSON here as well? That way there's a better chance somebody here can help you out.

 

 

danilo_fme
Evangelist
Forum|alt.badge.img+44
  • danilo_fmeEvangelist
  • Evangelist
  • August 4, 2017

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

danilo_fme
1 person upvoted this
  • danilo_fme
    danilo_fme
C
Forum|alt.badge.img
  • cfordigan
  • Author
  • August 4, 2017

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

danilo_fme
1 person upvoted this
  • danilo_fme
    danilo_fme
C
Forum|alt.badge.img
  • cfordigan
  • Author
  • August 4, 2017
danilo_fme wrote:

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
1 person upvoted this
  • danilo_fme
    danilo_fme
danilo_fme
Evangelist
Forum|alt.badge.img+44
  • danilo_fmeEvangelist
  • Evangelist
  • August 4, 2017
cfordigan wrote:

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
1 person upvoted this
  • danilo_fme
    danilo_fme
danilo_fme
Evangelist
Forum|alt.badge.img+44
  • danilo_fmeEvangelist
  • Evangelist
  • August 4, 2017
cfordigan wrote:
Danielo, If you send me your email address, I can grant you access to the data

 

 

 

danilo@inovacaogis.com.br
danilo_fme
1 person upvoted this
  • danilo_fme
    danilo_fme
danilo_fme
Evangelist
Forum|alt.badge.img+44
  • danilo_fmeEvangelist
  • Evangelist
  • August 4, 2017
cfordigan wrote:
Danielo, If you send me your email address, I can grant you access to the data

 

 

 

Hi @cfordigan, did you do anything?
danilo_fme
1 person upvoted this
  • danilo_fme
    danilo_fme
C
Forum|alt.badge.img
  • cfordigan
  • Author
  • August 5, 2017

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
1 person upvoted this
  • danilo_fme
    danilo_fme
danilo_fme
Evangelist
Forum|alt.badge.img+44
  • danilo_fmeEvangelist
  • Evangelist
  • August 6, 2017

 

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
Evangelist
Forum|alt.badge.img+44
  • danilo_fmeEvangelist
  • Evangelist
  • August 6, 2017
cfordigan wrote:

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
Evangelist
Forum|alt.badge.img+44
  • danilo_fmeEvangelist
  • Evangelist
  • August 7, 2017
danilo_fme wrote:

 

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
1 person upvoted this
  • danilo_fme
    danilo_fme
danilo_fme
Evangelist
Forum|alt.badge.img+44
  • danilo_fmeEvangelist
  • Evangelist
  • August 10, 2017
cfordigan wrote:

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
1 person upvoted this
  • danilo_fme
    danilo_fme
danilo_fme
Evangelist
Forum|alt.badge.img+44
  • danilo_fmeEvangelist
  • Evangelist
  • August 11, 2017
Hello @cfordigan, Solved it your problem?

 

Thanks

 

danilo_fme
Evangelist
Forum|alt.badge.img+44
  • danilo_fmeEvangelist
  • Evangelist
  • August 11, 2017
cfordigan wrote:

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

 

danilo_fme
1 person upvoted this
  • danilo_fme
    danilo_fme

Reply


Helpful Members This Week

Community Stats

31,105
Posts
117,925
Replies
38,858
Members

Latest FME

Terms & ConditionsCookie settings

Cookie policy

We use cookies to enhance and personalize your experience. If you accept you agree to our full cookie policy. Learn more about our cookies.

 
Cookie 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.