Hello,

I am working on a project in which we are using Python Panda DataFrames,

I am doing a simple HTTP Get using location object structure e.g.

<host>maximo/api/os/lbl_ds_locations?lean=1&oslc.select=location,lo1,parent,description,disabled,lo4,lo5,lo6,lo14,lbl_structure_type,lbl_structure_detail,lbl_changedate&oslc.where=gisparam1="B"

The json payload contains the desired results. However it does not display the data in the same order as I specified in "oslc.select".  For example it shows something like :









------------------------------
Pankaj Bhide
Computer Systems Engineer
Berkeley National Laboratory
Berkeley CA
------------------------------



#MaximoIntegrationandScripting
#AssetandFacilitiesManagement
#Maximo

I don't think we provide a way to control the order of the attributes. Normally position isn't important in JSON. Is it needed for DataFrame? If so that would potentially be worth requesting.

As for the second, add a query parameter of ignorecollectionref=1. That will suppress those from appearing in the body. If you want to suppress the href and/or rowstamp then add the ignorekeyref=1 & ignorers=1 query parameters. Those will remove those from the payload as well.

------------------------------
Steven Shull
------------------------------

Original Message:
Sent: Sat April 23, 2022 07:21 AM
From: Pankaj Bhide
Subject: OSLC JSON Rest oslc.select question for Panda DataFrames

Hello,

I am working on a project in which we are using Python Panda DataFrames,

I am doing a simple HTTP Get using location object structure e.g.

<host>maximo/api/os/lbl_ds_locations?lean=1&oslc.select=location,lo1,parent,description,disabled,lo4,lo5,lo6,lo14,lbl_structure_type,lbl_structure_detail,lbl_changedate&oslc.where=gisparam1="B"

The json payload contains the desired results. However it does not display the data in the same order as I specified in "oslc.select".  For example it shows something like :

"member": [

        {

            "lo4": "H",

            "parent": "H",

            "_rowstamp": "1861359227",

            "lbl_structure_type": "O",

            "lo6": "4",

            "lo5": "H",

            "lochierarchy_collectionref": "https://maximofac.dev.lbl.gov/maximo/api/os/lbl_ds_locations/_MDYyRi9GQUM-/lochierloconly",

            "description": "Storage container",

            "disabled": false,

            "location": "062F",

            "href": "https://maximofac.dev.lbl.gov/maximo/api/os/lbl_ds_locations/_XXXXXXX",

            "lo1": "062F"

        },

   
1) Is there any argument that will render the results in the same order as I specified in "oslc.select" For example, location,lo1,parent,description,... and so on

2) Is it possible to suppress   "lochierarchy_collectionref" element? 

------------------------------
Pankaj Bhide
Computer Systems Engineer
Berkeley National Laboratory
Berkeley CA
------------------------------



#Maximo
#MaximoIntegrationandScripting
#AssetandFacilitiesManagement

Original Message:
Sent: 4/25/2022 11:38:00 AM
From: Steven Shull
Subject: RE: OSLC JSON Rest oslc.select question for Panda DataFrames

I don't think we provide a way to control the order of the attributes. Normally position isn't important in JSON. Is it needed for DataFrame? If so that would potentially be worth requesting.

As for the second, add a query parameter of ignorecollectionref=1. That will suppress those from appearing in the body. If you want to suppress the href and/or rowstamp then add the ignorekeyref=1 & ignorers=1 query parameters. Those will remove those from the payload as well.

------------------------------
Steven Shull
------------------------------

Original Message:
Sent: Sat April 23, 2022 07:21 AM
From: Pankaj Bhide
Subject: OSLC JSON Rest oslc.select question for Panda DataFrames

Hello,

I am working on a project in which we are using Python Panda DataFrames,

I am doing a simple HTTP Get using location object structure e.g.

<host>maximo/api/os/lbl_ds_locations?lean=1&oslc.select=location,lo1,parent,description,disabled,lo4,lo5,lo6,lo14,lbl_structure_type,lbl_structure_detail,lbl_changedate&oslc.where=gisparam1="B"

The json payload contains the desired results. However it does not display the data in the same order as I specified in "oslc.select".  For example it shows something like :

"member": [

        {

            "lo4": "H",

            "parent": "H",

            "_rowstamp": "1861359227",

            "lbl_structure_type": "O",

            "lo6": "4",

            "lo5": "H",

            "lochierarchy_collectionref": "https://maximofac.dev.lbl.gov/maximo/api/os/lbl_ds_locations/_MDYyRi9GQUM-/lochierloconly",

            "description": "Storage container",

            "disabled": false,

            "location": "062F",

            "href": "https://maximofac.dev.lbl.gov/maximo/api/os/lbl_ds_locations/_XXXXXXX",

            "lo1": "062F"

        },

   
1) Is there any argument that will render the results in the same order as I specified in "oslc.select" For example, location,lo1,parent,description,... and so on

2) Is it possible to suppress   "lochierarchy_collectionref" element? 

------------------------------
Pankaj Bhide
Computer Systems Engineer
Berkeley National Laboratory
Berkeley CA
------------------------------



#MaximoIntegrationandScripting
#AssetandFacilitiesManagement
#Maximo

Original Message:
Sent: 4/25/2022 11:38:00 AM
From: Steven Shull
Subject: RE: OSLC JSON Rest oslc.select question for Panda DataFrames

I don't think we provide a way to control the order of the attributes. Normally position isn't important in JSON. Is it needed for DataFrame? If so that would potentially be worth requesting.

As for the second, add a query parameter of ignorecollectionref=1. That will suppress those from appearing in the body. If you want to suppress the href and/or rowstamp then add the ignorekeyref=1 & ignorers=1 query parameters. Those will remove those from the payload as well.

------------------------------
Steven Shull
------------------------------

Original Message:
Sent: Sat April 23, 2022 07:21 AM
From: Pankaj Bhide
Subject: OSLC JSON Rest oslc.select question for Panda DataFrames

Hello,

I am working on a project in which we are using Python Panda DataFrames,

I am doing a simple HTTP Get using location object structure e.g.

<host>maximo/api/os/lbl_ds_locations?lean=1&oslc.select=location,lo1,parent,description,disabled,lo4,lo5,lo6,lo14,lbl_structure_type,lbl_structure_detail,lbl_changedate&oslc.where=gisparam1="B"

The json payload contains the desired results. However it does not display the data in the same order as I specified in "oslc.select".  For example it shows something like :

"member": [

        {

            "lo4": "H",

            "parent": "H",

            "_rowstamp": "1861359227",

            "lbl_structure_type": "O",

            "lo6": "4",

            "lo5": "H",

            "lochierarchy_collectionref": "https://maximofac.dev.lbl.gov/maximo/api/os/lbl_ds_locations/_MDYyRi9GQUM-/lochierloconly",

            "description": "Storage container",

            "disabled": false,

            "location": "062F",

            "href": "https://maximofac.dev.lbl.gov/maximo/api/os/lbl_ds_locations/_XXXXXXX",

            "lo1": "062F"

        },

   
1) Is there any argument that will render the results in the same order as I specified in "oslc.select" For example, location,lo1,parent,description,... and so on

2) Is it possible to suppress   "lochierarchy_collectionref" element? 

------------------------------
Pankaj Bhide
Computer Systems Engineer
Berkeley National Laboratory
Berkeley CA
------------------------------



#MaximoIntegrationandScripting
#Maximo
#AssetandFacilitiesManagement

It looks like you did it correctly. My guess is you're on 7.6.1.1 because we added this after 7.6.1.1 was released and changes like this typically are not something that gets put into an IFIX. If you're on 7.6.1.2 and seeing issues let me know.

------------------------------
Steven Shull
------------------------------

Original Message:
Sent: Mon April 25, 2022 08:45 PM
From: Pankaj Bhide
Subject: OSLC JSON Rest oslc.select question for Panda DataFrames

Hello Steve,

Sorry to bother you. The ignorecollectionref worked. However suppressing rowstamp with ignorers=1 is not working. Any clue?

Original Message:
Sent: 4/25/2022 11:38:00 AM
From: Steven Shull
Subject: RE: OSLC JSON Rest oslc.select question for Panda DataFrames

I don't think we provide a way to control the order of the attributes. Normally position isn't important in JSON. Is it needed for DataFrame? If so that would potentially be worth requesting.

As for the second, add a query parameter of ignorecollectionref=1. That will suppress those from appearing in the body. If you want to suppress the href and/or rowstamp then add the ignorekeyref=1 & ignorers=1 query parameters. Those will remove those from the payload as well.

------------------------------
Steven Shull

Original Message:
Sent: Sat April 23, 2022 07:21 AM
From: Pankaj Bhide
Subject: OSLC JSON Rest oslc.select question for Panda DataFrames

Hello,

I am working on a project in which we are using Python Panda DataFrames,

I am doing a simple HTTP Get using location object structure e.g.

<host>maximo/api/os/lbl_ds_locations?lean=1&oslc.select=location,lo1,parent,description,disabled,lo4,lo5,lo6,lo14,lbl_structure_type,lbl_structure_detail,lbl_changedate&oslc.where=gisparam1="B"

The json payload contains the desired results. However it does not display the data in the same order as I specified in "oslc.select".  For example it shows something like :

"member": [

        {

            "lo4": "H",

            "parent": "H",

            "_rowstamp": "1861359227",

            "lbl_structure_type": "O",

            "lo6": "4",

            "lo5": "H",

            "lochierarchy_collectionref": "https://maximofac.dev.lbl.gov/maximo/api/os/lbl_ds_locations/_MDYyRi9GQUM-/lochierloconly",

            "description": "Storage container",

            "disabled": false,

            "location": "062F",

            "href": "https://maximofac.dev.lbl.gov/maximo/api/os/lbl_ds_locations/_XXXXXXX",

            "lo1": "062F"

        },

   
1) Is there any argument that will render the results in the same order as I specified in "oslc.select" For example, location,lo1,parent,description,... and so on

2) Is it possible to suppress   "lochierarchy_collectionref" element? 

------------------------------
Pankaj Bhide
Computer Systems Engineer
Berkeley National Laboratory
Berkeley CA
------------------------------



#MaximoIntegrationandScripting
#Maximo
#AssetandFacilitiesManagement

Original Message:
Sent: 4/26/2022 8:16:00 AM
From: Steven Shull
Subject: RE: OSLC JSON Rest oslc.select question for Panda DataFrames

It looks like you did it correctly. My guess is you're on 7.6.1.1 because we added this after 7.6.1.1 was released and changes like this typically are not something that gets put into an IFIX. If you're on 7.6.1.2 and seeing issues let me know.

------------------------------
Steven Shull
------------------------------

Original Message:
Sent: Mon April 25, 2022 08:45 PM
From: Pankaj Bhide
Subject: OSLC JSON Rest oslc.select question for Panda DataFrames

Hello Steve,

Sorry to bother you. The ignorecollectionref worked. However suppressing rowstamp with ignorers=1 is not working. Any clue?

Original Message:
Sent: 4/25/2022 11:38:00 AM
From: Steven Shull
Subject: RE: OSLC JSON Rest oslc.select question for Panda DataFrames

I don't think we provide a way to control the order of the attributes. Normally position isn't important in JSON. Is it needed for DataFrame? If so that would potentially be worth requesting.

As for the second, add a query parameter of ignorecollectionref=1. That will suppress those from appearing in the body. If you want to suppress the href and/or rowstamp then add the ignorekeyref=1 & ignorers=1 query parameters. Those will remove those from the payload as well.

------------------------------
Steven Shull

Original Message:
Sent: Sat April 23, 2022 07:21 AM
From: Pankaj Bhide
Subject: OSLC JSON Rest oslc.select question for Panda DataFrames

Hello,

I am working on a project in which we are using Python Panda DataFrames,

I am doing a simple HTTP Get using location object structure e.g.

<host>maximo/api/os/lbl_ds_locations?lean=1&oslc.select=location,lo1,parent,description,disabled,lo4,lo5,lo6,lo14,lbl_structure_type,lbl_structure_detail,lbl_changedate&oslc.where=gisparam1="B"

The json payload contains the desired results. However it does not display the data in the same order as I specified in "oslc.select".  For example it shows something like :

"member": [

        {

            "lo4": "H",

            "parent": "H",

            "_rowstamp": "1861359227",

            "lbl_structure_type": "O",

            "lo6": "4",

            "lo5": "H",

            "lochierarchy_collectionref": "https://maximofac.dev.lbl.gov/maximo/api/os/lbl_ds_locations/_MDYyRi9GQUM-/lochierloconly",

            "description": "Storage container",

            "disabled": false,

            "location": "062F",

            "href": "https://maximofac.dev.lbl.gov/maximo/api/os/lbl_ds_locations/_XXXXXXX",

            "lo1": "062F"

        },

   
1) Is there any argument that will render the results in the same order as I specified in "oslc.select" For example, location,lo1,parent,description,... and so on

2) Is it possible to suppress   "lochierarchy_collectionref" element? 

------------------------------
Pankaj Bhide
Computer Systems Engineer
Berkeley National Laboratory
Berkeley CA
------------------------------



#Maximo
#AssetandFacilitiesManagement
#MaximoIntegrationandScripting