Maximo Open Forum

 View Only
  • 1.  Looking for an example to process JSON data file into Maximo.

    Posted 08-19-2021 16:05
    I am new to JSON and i am looking for an example to process JSON data file into Maximo on a regular interval.  If you have any example or good resources, please share with me. 

    Thanks
    Hardik
    #Integrations

    ------------------------------
    Hardik PAtel
    Corning Inc
    ------------------------------


  • 2.  RE: Looking for an example to process JSON data file into Maximo.

    Posted 08-20-2021 09:37
    While the Maximo UI supports importing files in JSON format now, I don't think that the FLATFILECONSUMER cron task supports that option. The REST API was enhanced in newer versions to better support bulk data imports (https://www.ibm.com/docs/en/maximo-eam-saas?topic=apis-data-import-export-rest-api), including utilizing an asynchronous process where you submit everything and then check the status.

    I'm assuming you're getting the file from a third party in a different format. This would require you transform it (typically with an ETL tool) into the proper Maximo format before sending it to Maximo. Other types of files (like XML) there are ways to transform it on the Maximo side before processing. 

    Unless you're talking about large data processing, or integrating with a system that doesn't support them, I'd try to implement any new integrations utilizing web services. Most people want something near "real-time" and that requires doing web services. 

    If you've not worked with the integration framework in Maximo and need some links on concepts like object structures please let me know.

    ------------------------------
    Steven Shull
    IBM
    ------------------------------



  • 3.  RE: Looking for an example to process JSON data file into Maximo.

    Posted 08-20-2021 12:18
    Edited by Hardik PAtel 08-31-2021 13:57

    Original Message:
    Sent: 08-20-2021 09:37
    From: Steven Shull
    Subject: Looking for an example to process JSON data file into Maximo.

    While the Maximo UI supports importing files in JSON format now, I don't think that the FLATFILECONSUMER cron task supports that option. The REST API was enhanced in newer versions to better support bulk data imports (https://www.ibm.com/docs/en/maximo-eam-saas?topic=apis-data-import-export-rest-api), including utilizing an asynchronous process where you submit everything and then check the status.

    I'm assuming you're getting the file from a third party in a different format. This would require you transform it (typically with an ETL tool) into the proper Maximo format before sending it to Maximo. Other types of files (like XML) there are ways to transform it on the Maximo side before processing. 

    Unless you're talking about large data processing, or integrating with a system that doesn't support them, I'd try to implement any new integrations utilizing web services. Most people want something near "real-time" and that requires doing web services. 

    If you've not worked with the integration framework in Maximo and need some links on concepts like object structures please let me know.

    ------------------------------
    Steven Shull
    IBM