Converting Salesforce JSON to Excel values

Hi All,

I'm using the Input tool to connect to a Salesforce instance that hosts an existing report that I need for the workflow.

Output of Salesforce extract is a single JSON record. I tried using JSON parse tool. But that just converts JSON to JSON_Name and JSON_ValueString combination values.

How do I convert JSON extract to a readable format/ an excel file containing all column and row values (that are in Salesforce report)? I need to use row and column values from the Report for further workflow processing.

Thanks!

Workflow

Common Use Cases

Best Practices

Accepted answers

@atcodedog05 I was able to successfully parse data by selecting parsing checkbox while importing data from Salesforce. Very simple solution.

All comments

You may have to parse it out. Can you provide some sample data.

Hi @atcodedog05,

Sample Dataset below. This is an existing Salesforce report. Objective is to import Salesforce report in the below format.

Customer Customer Id Shipping City

ABC 235678 Boston

FGT 845678 Miami

CDE 523679 Chicago

OCG 450999 L.A.

KTB 423567 NYC

@atcodedog05 I was able to successfully parse data by selecting parsing checkbox while importing data from Salesforce. Very simple solution.

Thats awesome @Ronny_39 🙂

You can mark your post as a solution so that this question is marked as solved.

One note - it`s very simple solution BUT it is working only for reports with <2000 rows.

It pulls only 2000 rows.

If u have report in SF with >2000 rows it wont help.

Quick Links

Tags

This months top contributors

atcodedog05 19598

Qiu 15867

MarqueeCrew 13708

apathetichell 13703