Skip to main content
Question

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

  • July 10, 2020
  • 2 replies
  • 118 views
armando_amador
Contributor
Forum|alt.badge.img+5

I'm running a workspace with a creator→hhtpcaller and I would like to have the response saved into a new csv (excel) file as a regular table format. 

This is the API as reference: 

https://datos.cdmx.gob.mx/api/records/1.0/search/?dataset=casos-asociados-a-covid-19&q=&rows=10000&facet=fecha_actualizacion&facet=id_registro&facet=origen&facet=sector&facet=entidad_um&facet=sexo&facet=entidad_nac&facet=entidad_res&facet=municipio_res&facet=tipo_paciente&facet=fecha_ingreso&facet=fecha_def&facet=edad&facet=nacionalidad&facet=embarazo&facet=habla_lengua_indi&facet=diabetes&facet=epoc&facet=asma&facet=inmusupr&facet=hipertension&facet=cardiovascular&facet=obesidad&facet=renal_cronica&facet=tabaquismo&facet=negativo&facet=migrante&facet=pais_nacionalidad&facet=rango_edad&facet=positivo&facet=pendiente&refine.entidad_res=GUANAJUATO 

Do you guys know what can I do?

 

Thanks!

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.

2 replies

danilo_fme
Celebrity
Forum|alt.badge.img+52
  • danilo_fmeCelebrity
  • Celebrity
  • 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

 

 

 

Partner Solutial Brazil - www.solutial.com.br
david_r
Celebrity
  • david_rCelebrity
  • 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.

Community Stats

32,207
Posts
122,305
Replies
39,891
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.