Export JSON to Excel

Plugins listed on the AppMarket undergo periodic review. Upon completion of a recent review, this listing has been archived. If you have any  questions, please contact us via  appmarket@appian.com.

Hi Kirang,


Also one question do i need to pass excel template as an input to the service, if yes then I am hoping excel column names should match key values of json string passed. is this correct understanding?

To pass an Excel template as an input to the service, it's actually optional. If you choose to pass an Excel template, the data will be organized according to the template's structure. However, if you don't provide a template, a new Excel file will be created, and the data will be imported into it.

If you decide to pass an Excel template, you must specify the row number from which the data import should start. You also need to indicate whether you want the headers to be taken from the Excel template or from the JSON keys, which can be set as either "true" or "false."

Tried to pass string as pv as mentioned but still service is giving same error.

It seems like you attempted to pass a string as per the instructions but are still encountering an error. If you're working with nested JSON, please ensure you provide a standard JSON structure with key-value pairs for successful processing by the service.

Example :

[
{
"policyId": 2136,
"propertyId": 3323,
"clientId": 24528,
"subsidiaryId": 24529,
"countryId": 185,
"Client_Name": "QA- test data 6 jan -MTA bulk upload",
"Subsidiary_Name": "Sub 1",
"Fund_Name": "COSTR. IMMO. 2007 S.r.l"
},
{
"policyId": 2136,
"propertyId": 3323,
"clientId": 24528,
"subsidiaryId": 24529,
"countryId": 185,
"Client_Name": "QA- test data 6 jan -MTA bulk upload",
"Subsidiary_Name": "Sub 1",
"Fund_Name": "COSTR. IMMO. 2007 S.r.l"
}
]


Thanks & Regards ,
T . Saipriya

Have you went through this 


**Tried to pass string as pv as mentioned but still service is giving same error.**

Have you given expression in custom output as mentioned in the above screenshot?
Let me know are you fetching the data from the database?


**Also one question do i need to pass excel template as an input to the service, if yes then I am hoping excel column names should match key values of json string passed. is this correct understanding?**

By passing the Excel template ID, the service will take care of storing the data in the Excel file you specified. This is useful when you want to maintain a consistent format or structure in your Excel output.
If you decide not to provide an Excel template ID, the service will handle the data differently. It will create a new Excel file dynamically. In this case, the service will use the keys from your JSON data as column headers in the Excel file and the corresponding values as the data in those columns. This approach is convenient when you don't have a specific Excel template to use or want a quick way to generate an Excel file from your JSON data without prior formatting. The choice depends on your requirements and preferences.

**Please let me know about all the inputs of the service.**

The following are the inputs required for the service:

Json: This is where you provide the JSON data.
InputExcelTemplate: This is optional. If you provide it, the data will be stored in an Excel template you specify; otherwise, a new Excel file will be created.
SheetNumber: You need to specify the sheet number in the Excel template. It should be greater than zero.
RowNumber: You must provide the row number in the Excel template. It should also be greater than zero.
HeaderFlag: This specifies whether headers are required in the Excel template (default is true).
SheetName: In scenarios where you're not using an Excel template, you can specify the name of the resulting Excel sheet.
OutputExcelDocumentName: This is the name of the resulting Excel file, and it must not be null. The default name is "output.xlsx."

hi saipriyagoud any update on this?

Hi T . Saipriya Goud,

tried to pass string as pv as mentioned but still service is giving same error.

Also one question do i need to pass excel template as an input to the service, if yes then I am hoping excel column names should match key values of json string passed. is this correct understanding?

Please let me know about all inputs of the service.

Thanks,

Kiran

Hello Kirang,

Thank you for using the JSON to Excel plugin.

You are encountering an error because you are providing the total JSON object directly to the plugin, which is incorrect.

First, you should store the JSON in a string object and then send the string variable as input to the plugin.

Please give this a try, and kindly let us know if you encounter any errors.

Best regards,

T . Saipriya Goud

Hi Team,

I am trying to use this plug in and getting the below error.

Input:

My excel contains:

Kindly guide.