Ingesting JSON data

Edit online

As an alternative to using CSV files, you can upload your data by using JSON files. Then, the Envizi Supply Chain Intelligence reads, processes, and displays the relevant data on the available dashboards.

Before you begin

  1. Create a dedicated object storage bucket to store your JSON files and link the bucket with Envizi Supply Chain Intelligence for flawless processing. For more information, see Managing object storage.
  2. Review the data dictionary and prepare your JSON files. For more information, see Sample JSON data.
  3. Define a rule within Envizi Supply Chain Intelligence to process your uploaded JSON files. For more information, see Creating import rules.

About this task

The preferred approach is to upload data by using CSV files, so that your data is easy to build, consume, and initially load. CSV files are the recommended method because they can be used to efficiently set up demo data, daily data integration, and automated data loads for production data.

You can send data in batches from external data storage, such as object storage. Then, Envizi Supply Chain Intelligence reads, processes, and transforms your data for use in dashboards, work queues, and other Envizi Supply Chain Intelligence applications.

Procedure

  • For IBM Cloud® Object Storage bucket, make an API call to the storage service. For more information, see Create (upload) an object.
    If file location is specified in your import rule, make sure that you upload your file to the same folder in the object storage.
  • For Amazon Cloud Object Storage (AWS-S3) bucket, make an API call to the storage service. For more information, see PutObject.
    If file location is specified in your import rule, make sure that you upload your file to the same folder in the object storage.

What to do next

Check the status of your import in Job management.

  1. From the side navigation menu, click Management > Job management.

    The Job management page shows recent jobs. The import rule that processed your JSON file, shows the JSON file name as a job name.

  2. Click the job ID that is assigned for your job to view the job details.
  3. Check the File summary and Job details sections. If the status of the job is other than completed then resolve the highlighted errors and re-upload the file to designated object storage.
  4. In the Debugging section, view the events, check the error events, and view the objects for your current job in GraphiQL editor.

    The event section contains information about the recent business objects that have been created or updated. Each edge contains an object property with more detailed information about the event, including the timestamp when the event was received by the system and the ID of the business object that was affected by the event.

    In the object section, edges contain information about the most recently created or updated business objects. Each edge contains an object property with more detailed information about the business object, including its unique ID.