Skip to main content
Open

Make it easier to work with JSON/XML result from REST Service call

Related products:Transformers
  • October 16, 2017
  • 3 replies
  • 87 views

fmelizard
Safer
Forum|alt.badge.img+22

With REST web services, generally they return JSON/XML, which I then need to manipulate into attributes.

The pattern of work is often:

  1. Add Creator, HTTPCaller, Logger/Inspector
  2. Run workspace
  3. Inspect returned JSON/XML - determine if need to fragment and flatten or only flatten.
  4. Add JSONFragmenter or JSONFlattener or XML equivalent and Logger/Inspector.
  5. Run workspace.
  6. Inspect attributes created from flattening.
  7. Expose attribute names that were created by flattening.

I wish this was less work.

3 replies

fmelizard
Safer
Forum|alt.badge.img+22
  • Author
  • Safer
  • October 17, 2017

nickison
Contributor
Forum|alt.badge.img+3
  • Contributor
  • October 17, 2017

As someone who has done these steps every day for the past 6 months, yes please!


u12runm
Contributor
Forum|alt.badge.img+4
  • Contributor
  • February 22, 2024

I hate working with complex Json files… this process needs to be easier/more automated or more help.