Transform a json/csv into a table

[Eduardo_Pasquotto]

Hi

I am running an http request that is returning it:

[-{“data”: “PD Type,Table Field Name,Value\nBR CNPJ,BACKBDB1REPORTSRV.PROD_GERENCIAL_REP.ESTABELECIMENTO.CGC,99999999999999\nBR CPF,BACKBDB1REPORTSRV.PROD_GERENCIAL_REP.ESTABELECIMENTO.CPF,22222222\nEmail Address,BACKBDB1REPORTSRV.PROD_GERENCIAL_REP.ESTABELECIMENTO.EMAIL,[email protected]\nLast Name,BACKBDB1REPORTSRV.PROD_GERENCIAL_REP.ESTABELECIMENTO.NOME_FANTASIA_RECEITA_FEDERAL,MARIA JOELMA\nCountry,BACKBDB1REPORTSRV.PROD_GERENCIAL_REP.ESTABELECIMENTO_RESPONSAVEL.DS_PAIS_NASCIMENTO,BRASIL\nPhone Number,BACKBDB1REPORTSRV.PROD_GERENCIAL_REP.ESTABELECIMENTO_RESPONSAVEL.NR_CELULAR,99538\n”}]

How to convert it to a excel/csv, the csv read/consume is not working.

[martinhache]

Hey @Eduardo_Pasquotto

In the Mapping raw data to formatted table - JSON API thread you have a solution that may be useful for your query.

Here you have it adapted to the data returned by your HTTP Request node:

[Eduardo_Pasquotto]

Man, you are the king.

Very good solution.

Thanks a lot.