Hello, 

I am trying to develop a python 3.9 program (that we plan to execute externally) that performs HTTP Get from the object structure related to person and displays the JSON returned from MAXIMO.

Please see the simple code below;

=================

------------------------------
Pankaj Bhide
Associate/Analyst
Berkeley National Laboratory
Berkeley CA
(510) 486-4681
------------------------------
#AssetandFacilitiesManagement
#Maximo

You need to use python url encoding to encode the final url including the query parameters.

Document from IBM is the best to get started on using rest api of Maximo:
https://www.ibm.com/support/pages/system/files/inline-files/Maximo_NextGen_REST_API_-_nextgen.pdf

Document also explains how use different header for url encoding. It has explained the use  of oslc.where query parameter as well. This is THE document  for creating solutions in Maximo using rest api.

Also, there are github repos where maximo rest api is used to create web solutions:
https://github.com/ibmmaximorestjsonapis/maximorestclient/blob/master/src/com/ibm/maximo/oslc/MaximoConnector.java
https://github.com/ibmmaximorestjsonapis/maximorestclient
https://github.com/ibm-maximo-dev/maximo-nodejs-rest-client

These github repos can be analysed to understand the implementation and use it in your solution.

------------------------------
Biplab Choudhury
Maximo Consultant
Tata Consultancy Services
Melbourne
------------------------------

Original Message:
Sent: Mon September 27, 2021 06:54 PM
From: Pankaj Bhide
Subject: PYTHON 3.9 CODE FOR EXECUTING OSLC JSON REST API

Hello, 

I am trying to develop a python 3.9 program (that we plan to execute externally) that performs HTTP Get from the object structure related to person and displays the JSON returned from MAXIMO.

Please see the simple code below;

=================

from pprint import pprint

from requests.packages.urllib3.exceptions import InsecureRequestWarning

from urllib.parse import urlparse

import requests

import base64

from lblpycommon import lbl_libutil01

#-- ignore bad ssl

requests.packages.urllib3.disable_warnings(InsecureRequestWarning)

strObjectStructure="lbl_ds_person"

strAutomationScript=None

strListofColumns="personid,firstname,lastname,displayname,location,supervisor,lbl_status,lbl_org_level_1,lbl_org_level_2,lbl_org_level_3"

strWhere="lbl_org_level_1=%22IC%22"

strSavedQuery=None

# Get the MAXIMO URL from properties file

if (strAutomationScript==None):

    strUrl=lbl_libutil01.getPropertyValue("maximorestoslcurl")+"/"+ strObjectStructure

else:

    strUrl=lbl_libutil01.getPropertyValue("maximorestoslscriptcurl") +"/"+ strAutomationScript

# Prepare Headers

dictHeaders = {

 #'maxauth': maxauth, # BASIC auth = login:passwd

 'Accept': "application/json",

 'Content-Type': "application/json",

 'Allow-Hidden': "true",

 }

 # Prepare parameters

dictParams = {

 'lean':1, # Remove name space - recomended when working with Maximo JSON

 'oslc.select': 'personid,firstname,lastname,displayname,location,supervisor,lbl_status,lbl_org_level_1,lbl_org_level_2,lbl_org_level_3',

 'oslc.where': "location='069-0102D'",

 'oslc.pageSize':1,

 'apikey':'*********'

 }

r = requests.get(strUrl, headers=dictHeaders, params=dictParams, verify=False)

pprint(r.json())

==============================
My questions are ;

1) How to specify the "where clause" that contains something like location='069-0102D'. The line " 'oslc.where': "location='069-0102D'" gives error. I tried "location=%22069-0102D%22". However that is also not working. Also how to specify wild card search? 

2) For example ;
  'oslc.where':'assetnum=Myasset111',   -- it is not working. i tried "assetnum='%22Myasset111%22" etc.

also how to check for wildcard searches?
Also how to specify "or" "and" operators 
For example:
 'oslc.where':'assetnum=Myasset111 or location=90F



This is a python question. 

Appreciate any help.

------------------------------
Pankaj Bhide
Associate/Analyst
Berkeley National Laboratory
Berkeley CA
(510) 486-4681
------------------------------
#AssetandFacilitiesManagement
#Maximo

Use double-quotes around string literals in the oslc.where clause. For example:

'oslc.where': 'assetnum="11430" and siteid="BEDFORD"'

For wildcard searches, use the asterisk * symbol. For example:

'oslc.where': 'siteid="BEDFORD" and manufacturer="*"'

Hope this helps,

------------------------------
Alex Walter
A3J Group
------------------------------

Original Message:
Sent: Mon September 27, 2021 06:54 PM
From: Pankaj Bhide
Subject: PYTHON 3.9 CODE FOR EXECUTING OSLC JSON REST API

Hello, 

I am trying to develop a python 3.9 program (that we plan to execute externally) that performs HTTP Get from the object structure related to person and displays the JSON returned from MAXIMO.

Please see the simple code below;

=================

from pprint import pprint

from requests.packages.urllib3.exceptions import InsecureRequestWarning

from urllib.parse import urlparse

import requests

import base64

from lblpycommon import lbl_libutil01

#-- ignore bad ssl

requests.packages.urllib3.disable_warnings(InsecureRequestWarning)

strObjectStructure="lbl_ds_person"

strAutomationScript=None

strListofColumns="personid,firstname,lastname,displayname,location,supervisor,lbl_status,lbl_org_level_1,lbl_org_level_2,lbl_org_level_3"

strWhere="lbl_org_level_1=%22IC%22"

strSavedQuery=None

# Get the MAXIMO URL from properties file

if (strAutomationScript==None):

    strUrl=lbl_libutil01.getPropertyValue("maximorestoslcurl")+"/"+ strObjectStructure

else:

    strUrl=lbl_libutil01.getPropertyValue("maximorestoslscriptcurl") +"/"+ strAutomationScript

# Prepare Headers

dictHeaders = {

 #'maxauth': maxauth, # BASIC auth = login:passwd

 'Accept': "application/json",

 'Content-Type': "application/json",

 'Allow-Hidden': "true",

 }

 # Prepare parameters

dictParams = {

 'lean':1, # Remove name space - recomended when working with Maximo JSON

 'oslc.select': 'personid,firstname,lastname,displayname,location,supervisor,lbl_status,lbl_org_level_1,lbl_org_level_2,lbl_org_level_3',

 'oslc.where': "location='069-0102D'",

 'oslc.pageSize':1,

 'apikey':'*********'

 }

r = requests.get(strUrl, headers=dictHeaders, params=dictParams, verify=False)

pprint(r.json())

==============================
My questions are ;

1) How to specify the "where clause" that contains something like location='069-0102D'. The line " 'oslc.where': "location='069-0102D'" gives error. I tried "location=%22069-0102D%22". However that is also not working. Also how to specify wild card search? 

2) For example ;
  'oslc.where':'assetnum=Myasset111',   -- it is not working. i tried "assetnum='%22Myasset111%22" etc.

also how to check for wildcard searches?
Also how to specify "or" "and" operators 
For example:
 'oslc.where':'assetnum=Myasset111 or location=90F



This is a python question. 

Appreciate any help.

------------------------------
Pankaj Bhide
Associate/Analyst
Berkeley National Laboratory
Berkeley CA
(510) 486-4681
------------------------------
#Maximo
#AssetandFacilitiesManagement