Why is the rowstamp value in REST API responses in byte array instead of integer?

Question & Answer

Question

STEPS:

1) Set SQL to DEBUG in Logging application

2) Open Postman and enter a GET URL to connect to an SQL Server environment

http://hostname:port/maxrest/oslc/os/mxperson?stableId&lean=1&oslc.select=personid&stablepaging=0&lastfetchts=904687&fetchmodedelta=1

3) Get a response:

{"member": [

{

"email_collectionref": "http://hostname:port/maxrest/oslc/os/mxperson/_QUJCWQ--/email",

"_rowstamp": "[0 0 0 0 0 21 -80 -127]",

"personid": "ABBY",

"sms_collectionref": "http://hostname:port/maxrest/oslc/os/mxperson/_QUJCWQ--/sms",

"href": "http://hostname:port/maxrest/oslc/os/mxperson/_QUJCWQ--",

"phone_collectionref": "http://hostname:port/maxrest/oslc/os/mxperson/_QUJCWQ--/phone"

},

image-20220511112055-1

4) In the Maximo log, rowstamp converts to BIGINT

select * from person where (cast(rowstamp as bigint)>904687)

Question:

Why it is returning in bye array format instead of integer?

When you pass rowstamp to Maximo in the get request, the lastfetchts value is integer. Why Maximo needs rowstamp in integer format for request but returns byte array format in response?

[{"Type":"MASTER","Line of Business":{"code":"LOB77","label":"Automation Platform"},"Business Unit":{"code":"BU048","label":"IBM Software"},"Product":{"code":"SSLKT6","label":"IBM Maximo Asset Management"},"ARM Category":[{"code":"a8m50000000CbFGAA0","label":"Integration"}],"ARM Case Number":"TS009160210","Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"All Versions"}]

Log InLog in to view more of this document

This document has the abstract of a technical article that is available to authorized users once you have logged on. Please use Log in button above to access the full document. After log in, if you do not have the right authorization for this document, there will be instructions on what to do next.

Was this topic helpful?

Document Information

More support for:
IBM Maximo Asset Management

Component:
Integration

Software version:
All Versions

Document number:
6584947

Modified date:
10 May 2022

UID

ibm16584947

IBM Support

Tips