• This listing is archived.
Information
  • Author: EXL
  • Type: Plug-in (Function & Smart Service)
  • Compatible Version(s): 23.3
  • First Released:
  • Last Updated:
  • Cost: Not Applicable
    * Cost information is not applicable since this listing is archived.
Share
Home » AppMarket » Export JSON to Excel

Export JSON to Excel

Overview

  • Businesses can effortlessly convert JSON data into well-structured Excel spreadsheets, facilitating seamless analysis and reporting.
  • JSON data received from partners can be rapidly transformed into Excel files, simplifying the sharing process.
  • Appian workflows offer automated JSON to Excel conversion, enhancing overall automation efficiency.
  • Automation workflows can now incorporate JSON to Excel conversion, reducing the need for manual data handling.
  • Streamlined data entry and migration efforts by seamlessly converting JSON into Excel format.
  • Generate customized reports by converting specific JSON subsets into Excel sheets with built-in validations.
  • Archive and back up historical JSON data conveniently as Excel files.

Key Features & Functionality

  • Specify the sheet number for export.
  • Define the row number from which the export process should commence.
  • Choose whether to display headers in the Excel spreadsheet with a header flag.
  • Provide sheet names and output Excel document names as needed.
  • Support for both template-based reports with multiple/single sheets.
  • Fully customizable settings for sheet selection, row configuration, and header preferences.
  • Option to include validations, color, formulas, and header overrides with templates.
  • Template-free conversion for a more flexible approach.
  • Streamline automation processes seamlessly through Appian integration.
  • Receive detailed error messages for efficient troubleshooting.
  • Efficiently process large datasets with ease.
  • Facilitates data analysis and seamless sharing.
  • Designed for easy integration with automation workflows.
Anonymous
Parents

  • Hi Team,

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

    Input:

    My excel contains:

    Kindly guide.

  • in reply to Kirang

    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

  • in reply to Kirang

    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

  • in reply to Kirang

    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."

Comment Children
  • in reply to Kirang

    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."

© 2024 Appian. All rights reserved.
We want to hear from you! Submit a review on Gartner or G2.