Skip to main content
Solved

JSON Help with extract attributes

  • June 12, 2022
  • 3 replies
  • 23 views
dor1411993
Contributor
Forum|alt.badge.img+5

Hello!

I have a json text which I got from airtable HttpCaller.

I want to read the attributes as normal attributes, and I have some hard time with that.

I think I know what should I do:

imageFormat it, and then expose the attributes with JSONFragmenter

But It does not enter the attributes into my fileds:

imageWhat should I do?

I tried to do a lot of variations in the JSON Query, but noting helped..

 

I attached here the work sample..

Thanks you all!

Best answer by danilo_fme

Hi @dor1411993​ 

 

I edited your transformer JSONFragmenter - the Query:

 

json["records"][*]["fields"]

The results in FME Data Inspector:

 

Results 

Thanks in Advance,

Danilo

This post is closed to further activity.
It may be an old question, an answered question, an implemented idea, or a notification-only post.
Please check post dates before relying on any information in a question or answer.
For follow-up or related questions, please post a new question or idea.
If there is a genuine update to be made, please contact us and request that the post is reopened.

3 replies

danilo_fme
Celebrity
Forum|alt.badge.img+51
  • danilo_fmeCelebrity
  • Celebrity
  • 2076 replies
  • Best Answer
  • June 13, 2022

Hi @dor1411993​ 

 

I edited your transformer JSONFragmenter - the Query:

 

json["records"][*]["fields"]

The results in FME Data Inspector:

 

Results 

Thanks in Advance,

Danilo

Partner Solutial Brazil - www.solutial.com.br
dor1411993
Contributor
Forum|alt.badge.img+5
  • dor1411993Contributor
  • Author
  • Contributor
  • 39 replies
  • June 13, 2022

Thanks very much!

@danilo_fme​ 

danilo_fme
Celebrity
Forum|alt.badge.img+51
  • danilo_fmeCelebrity
  • Celebrity
  • 2076 replies
  • June 13, 2022

Thanks very much!

@danilo_fme​ 

Thanks for update. I'm happy to help you!

Partner Solutial Brazil - www.solutial.com.br

Community Stats

32,065
Posts
121,732
Replies
39,691
Members

Latest FME

Terms & ConditionsCookie settingsAccessibility statement
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.