Skip to main content
mayurim3258
mayurim3258
Known Participant
Nov 30, 2023 6:05 AM UTC
Question

JSON to Excel converter

Hi, I need to export data from multiple data store entities into excel sheet. Current I am using "Export Data Store Entity to Excel" smart service but this services takes only one Data store Entity value as highlighted below.

How can I take multiple Data Store Entity values and export to excel at once? Please advise.

5 replies

annap0005
annap0005
Participating Frequently
Nov 30, 2023 7:36 AM UTC

Two ways, If you need it in one sheet then you can create a view and use that dse.

if you need that in separate sheet in excel then use multiple node or loop logic.

mayurim3258
mayurim3258Author
Known Participant
Nov 30, 2023 9:30 AM UTC

Hi Anna, Thank you for your reply.

I need different sheet for each DSE. How can I pass use loop login to pass multiple DSE? Could you please advise

annap0005
annap0005
Participating Frequently
Nov 30, 2023 10:08 AM UTC

First create new doc the way you are doing for one dse extract, next node use same doc in doc to update and provide new sheet number

Terms & ConditionsAccessibility statement