
URI Path | /REST/auth/login |
HTTP Method(s) | POST |
Request Parameters | u - User ID of Producer Manager user (required) p - Password of Producer Manager user (required) |
Return MIME Type(s) | application/xml (default) application/json |
Response Codes | 200 OK - Login successful. 403 Forbidden - Authentication failed. 500 Internal Server Error - Unexpected runtime error occurred. See Producer Manager Application Log. |
curl --request POST 'http://tenantid-pmpro-uat.callidusondemand.com/PM/REST/auth/login' \
--header 'Content-Type: application/x-www-form-urlencoded' \
--data-urlencode 'u=USERNAME' \
--data-urlencode 'p=PASSWORD'
Finally, SQL formation looks like this...
select p.producerid as ProdNo,sub.Producerno,
pv.producertype from ProducerVer pv
join Producer p on p.producerno = pv.producerno
join (select max(ProducerVerno) as pvno,ProducerNo
from producerver
${rowLevelJoins}
where
${rowLevelAnd}
prosta <> 9
group by ProducerNo)sub on sub.pvno = pv.producerverno
and p.producerid= '${ProdNo}'
URI Path(s) | /REST/query/run |
HTTP Method(s) | GET |
Request Parameters | qbqueryid - The QBQueryID of the query you wish to run. "System API" should be defined as one of the query contexts to allow the QBQueryID accessible in the API. maxrows - Optional parameter indicating that the query should be limited to the maximum number of rows. Query-specific Parameters - If the query to execute includes parameters, pass these by name as indicated within the query definition. |
Return MIME Type(s) | application/xml (default)Z application/json |
Response Codes | 200 OK - QBQuery executed successfully. Does not necessarily mean that rows were found. 400 Bad Request - Invalid QBQueryId or values were not supplied for one or more of the required query parameters. 403 Forbidden - Invalid session or user not authorized to use this API. 500 Internal Server Error - Unexpected runtime error occurred. See the Producer Manager Application Log. |
curl --request \
GET 'https://tenantid-pmpro-uat.callidusondemand.com/PM/REST/query/run?qbqueryid=testityourself&ProdNo='000253' \
--header 'CaldSessionId: A-hsbsa73le78rdcji9kosubi' \
--header 'Content-Type: application/xml'
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
6 | |
2 | |
1 | |
1 | |
1 | |
1 | |
1 | |
1 | |
1 | |
1 |