Import Api Data To Excel Update Data In
Import Api Data To Excel Code Snippet Illustrates
Import Api Data To Excel Full JSON Tree

Ensure that the data appears to have been parsed correctly on the resulting dialog, and if it is click the Load button.

We dont recommend using older versions of Excel, as Excels previous versions wont accept URLs over a certain character limit.

UPDATEADD - Updates the row if the mentioned column values are matched, else a new entry will be added ZOHOMATCHINGCOLUMNS List of comma separated column names. E.g.,: Name,Department Should be passed only when the ZOHOIMPORTTYPE is UPDATEADD.

With ManageEngine Analytics Plus API developers can easily push or pull data into or from ManageEngine Analytics Plus (data integration) for powerful reporting and analysis.

You can add powerful business intelligence capabilities to your productapplication, build add-ons to analyze data from third-party business applications.

Analytics Plus API allows you to: Add data into a table in ManageEngine Analytics Plus database Modify data in the ManageEngine Analytics Plus database Bulk AddUpdate data into a table via CSV file.

Export data and Reports in various formats such as CSV, JSON, PDF,HTML,IMAGE Fetch data from the database using SQL Select query.

How to Import data using API Sample Specifying the action Parameters for specifying the Import Options Sample Success Response 1.

Import Api Data To Excel Update Data In

With the ManageEngine Reports API, you can addupdate data in bulk.

The data to be addedupdated should be in CSV or JSON file formats.

Import Api Data To Excel Code Snippet Illustrates

The following code snippet illustrates importing data from a JSON file into ManageEngine Analytics Plus with POST parameters along with additional control parameters submitted from the HTML form.

In case you import file with multiple JSON objects separated by comma (not enclosed with square brackets), then the first object alone will be imported.

JSON object containing simple values without keys are not supported.

Specifying the action In the query string of the url, the ZOHOACTION parameter should be IMPORT.

For other mandatory query string parameters such as ZOHOOUTPUTFORMAT, Note: Value of ZOHOACTION parameter should be in the same case( UPPER CASE ) as given in this document.

Parameters for specifying the Import Options These parameters are used to specify the various options when importing.

Some of these parameters are mandatory and are highlighted and marked with star.

CSV Format DetailsThese parameters need to be specified if the ZOHOAUTOIDENTIFY is set to false.JSON Format DetailsThe following parameters need to be specified while importing data from JSON file.

Sample Success ResponseJSONThe following is a sample response in JSON format in case of successful import.

Supported formats are: CSV JSON ZOHOCREATETABLE truefalse.

Optional. Default is false.

In case it is true, then the table is created if the table referred in the URL doesnt exist in the specified database.

In case its false, no table is created even if the table refered in the URL does not exist in the database.

ZOHOSELECTEDCOLUMNS List of comma separated column names.

E.g.,: Name, Department Optional.

Specify the columns to be imported into the ManageEngine Analytics Plus table from the data being uploaded.

Import Api Data To Excel Full JSON Tree

Note: Incase of JSON files you need to specify the column names capturing the full JSON tree heirrachy eg., employee.Name, employee.Department ZOHOIMPORTTYPE APPEND TRUNCATEADD UPDATEADD APPEND - Appends the data into the table.

TRUNCATEADD - Deletes all exisiting rows in the table and adds the imported data as new entry.

UPDATEADD - Updates the row if the mentioned column values are matched, else a new entry will be added ZOHOMATCHINGCOLUMNS List of comma separated column names.

E.g.,: Name,Department Should be passed only when the ZOHOIMPORTTYPE is UPDATEADD.

Import Api Data To Excel For Mac