Skip to main content
Question

How to write an HTTP CALLER response body to a CSV writter?


armando_amador
Contributor
Forum|alt.badge.img+4

2 replies

danilo_fme
Evangelist
Forum|alt.badge.img+44
  • Evangelist
  • July 10, 2020

Hi @armando_amador

The transformer HttpCaller generates json attribute.

 

There is a interesting link about Tutorial-getting-started-with-json .

 

Is necessary to use transformers for json:

Thanks in Advance,

Danilo

 

 

 


david_r
Celebrity
  • July 11, 2020

In addition to using the HTTPCaller, you can also use the regular JSON reader and point it to the service URL. The reader will automatically analyse and expose all the attributes for you, saving some effort. To prepare the data for CSV or Excel, simply use a ListExploder on the records{} list, as suggested by @danilo_fme

However, if the service endpoints expects you to do paging, i.e. multiple requests in blocks of e.g. 10'000, then the HTTPCaller inside a looping transformer might be more logical.


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