You're almost there! Please answer a few more questions for access to the Applications content. Complete registration
Interested in joining? Complete your registration by providing Areas of Interest here. Register

OTM/GTM REST API for Saved Query passing parameter

edited Dec 24, 2025 9:35AM in Workforce Management

Summary:


OTM/GTM REST API for Saved Query passing parameter

Content (please ensure you mask any confidential information):


We have created below saved query in OTM/GTM Saved query :

select gt.GTM_TRANSACTION_TYPE_GID,gts.STATUS_VALUE_GID from gtm_transaction_status gts,gtm_transaction gt, gtm_trans_refnum gtr where gt.gtm_transaction_gid=gtr.gtm_transaction_gid and gt.gtm_transaction_gid = gts.gtm_transaction_gid and gtr.GTM_TRANS_REFNUM_QUAL_GID = 'SOURCE_ORDER_NUMBER' and gtr.refnum_value in ('?')

API call is not returning the data its always giving 500 Internal Server error. How can we pass the input value via REST API for saved query?

Tagged:

Howdy, Stranger!

Log In

To view full details, sign in.

Register

Don't have an account? Click here to get started!