Maximo Open Forum

 View Only

 How to retrieve data from external api using maximo

  • Integrations
  • Utilities
Jose Arturo Pitti's profile image
Jose Arturo Pitti posted 05-17-2024 11:54

Hi, 

i have done all necesary to populate my object structure for weather time.

I thinks somenthing is missing, i want to keep my tabla xxx_weather updated, i have made my object structure, my endpoint, my external system, my json mapping but i read somenthing that i have to put api crontask running to retrieve data from api.weather or otherone.

Maping JSON.

This is my api url 

and my external system.

When i test my external system also works fine.

But my tabla xxx_ or objectructure isn't populate.

Any help i really appreciate that.

thanks

Attachment  View in library
Sankar Ganesh V S's profile image
Sankar Ganesh V S

Hi Jose,

As I understanf the data import preview is wokring , but not from the Maximo cron?

Could you please clarify below Questions?

Did you also try it is postman or any REST API tool to confirm?

Is it a custom cron task for pulling data from API?

If the API is workig froma tool and fails is cron task, you may check the custom code related.

Thanks!

Jose Arturo Pitti's profile image
Jose Arturo Pitti

Hi Sankar Ganesh,

I don't know how to put this in cron task, if you have an example of how i can retrieve this info, i will appreciate this.

thanks

Martin Fabra's profile image
Martin Fabra

Hi @Jose Arturo Pitti

Are you trying to insert data into Maximo from your external application into the ENS_WEATHER table? Is that so? A PUT call is what you are doing? Do you use any external application to test this, like POSTMAN?

You execute your put using the declared URI, you don't get an error and then you do a select in the ENS_WEATHER table and you don't find any data? Can you give me more information?

Regards!