Skip to main content
mayurim3258
November 30, 2023
Question

JSON to Excel converter

  • November 30, 2023
  • 5 replies
  • 0 views

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
November 30, 2023

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
November 30, 2023

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
November 30, 2023

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