|
Klassieke bestandstypen zijn vanaf januari 2021 niet meer beschikbaar voor gebruik. U kunt uw klassieke bestanden omzetten of een PDF downloaden. Meer informatie

Array to CSV issue

Demo aanvragen
Gerelateerd aan connections chains

Hello,

We are trying to run the "Array to csv" connector for a JSON response as below. It runs successfully but its output has no values.  

{"pov":[],"columns":[["Q1","Q2","Q3","Q4"]],"rows":[{"headers":["FCCS_Net Income","BU_XXXXX","FY25","AN2222","Actual","Final","Total Project","Total Product","YTD","Consolidation","Total Data Source","Total Function","Color","Intercompany","Total Geography","Movement"],"data":["255555","22222","55555","68942"]}

here is the output result

Please advise the recommended process for converting a JSON response to CSV that outputs the value for each column.

here is a JSON connector we used to test it. 

 

1

Opmerkingen

2 opmerkingen

Datum Stemmen
  • Brooke Mortvedt

    Hi Rajesh Shrestha - Thanks for contacting us regarding your issue! To determine the issue, we recommend reaching out to your CSM so they can grab some more information & assist. 

    Have a great day!

    0
  • Jeff Hickey

    Hi Rajesh Shrestha,

    I recommend using the Handlebars Connector to build your output from the JSON. If you haven't used Handlebars before, we have quite a few resources below to help.

    Using the following sample JSON:

    {
      "pov": [],
      "columns": [
        [
          "Q1",
          "Q2",
          "Q3",
          "Q4"
        ]
      ],
      "rows": [
        {
          "headers": [
            "FCCS_Net Income",
            "BU_XXXXX",
            "FY25",
            "AN2222",
            "Actual",
            "Final",
            "Total Project",
            "Total Product",
            "YTD",
            "Consolidation",
            "Total Data Source",
            "Total Function",
            "Color",
            "Intercompany",
            "Total Geography",
            "Movement"
          ],
          "data": [
            "255555",
            "22222",
            "55555",
            "68942"
          ]
        }
      ]
    }

    You can make use of the Render Text Template command with the following example template to output a comma separated result.

    "headers","data"
    {{#each json.rows}}
    "{{#each headers}}{{this}}{{#unless @last}},{{/unless}}{{/each}}","{{#each data}}{{this}}{{#unless @last}},{{/unless}}{{/each}}"
    {{/each}}

    With the above example template, the output will be:

    "headers","data"
    "FCCS_Net Income,BU_XXXXX,FY25,AN2222,Actual,Final,Total Project,Total Product,YTD,Consolidation,Total Data Source,Total Function,Color,Intercompany,Total Geography,Movement","255555,22222,55555,68942"

    Thanks,
    Jeff

    0

U moet u aanmelden om een opmerking te plaatsen.