Solved

JSON Help with extract attributes

dor1411993
Rank
Badge +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!

icon

Best answer by danilo_fme 13 June 2022, 02:06

View original

3 replies

danilo_fme
Rank
Userlevel 4
Badge +30

Hi @dor1411993​ 

 

I edited your transformer JSONFragmenter - the Query:

 

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

The results in FME Data Inspector:

 

Results 

Thanks in Advance,

Danilo

dor1411993
Rank
Badge +5

Thanks very much!

@danilo_fme​ 

danilo_fme
Rank
Userlevel 4
Badge +30

Thanks very much!

@danilo_fme​ 

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

Reply


Community Stats

28,692
Posts
109,433
Replies
36,543
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.