Don't Worry, Be API: Extracting Info from JSON Data

I use multiple APIs, and each returns different data in a different structure. That's when I have the problem of extracting the information I want.

The JSONFragmenter is a great transformer to use; it's just sometimes difficult to know what to set for the JSON Query field.

This "Five Minute FME" video shows how to explore the data returned by an API to get the information you want from it, and includes a nice tip involving the AttributeFileWriter transformer too.

[audreylanglais]

Tellement clair comme explication! merci

[Sharonneke.h]

Thank you so so much for the clear and concise explanation! This helped me solve an issue that was crashing servers whenever we ran the workspace

[fredericeicheltruc]

Great shirt! 😁
Oh, and great explanations too, as always 😉
Thanks a lot Mark

[aynellrodriguez]

Thank you so much for this video. It helped me a lot, exactly what i was looking for.

[BBHQ]

How would I get the http caller to collect more than 20 features? There is ~150 in the dataset but I am only pulling 20. If I make more calls, how do I tell it to grab 21-40, 41-60, etc?

[michaellowe]

Using the AttributeFileWriter...rubs in all the time I've wasted chasing for simple JSON queries.