...
RECIDs can be accessed from several methods. The 'API', 'AdHoc Grids', Database query access, 'History Report', or 'Sharing' links can provide this information. Make sure to consult the Data Dictionary to verify what application record contains the RECID needed.
API
Using the SQL Endpoint, Users can execute SQL queries that lookup a specific record. Using a SELECT statement, Users can add the RECID column to the list of fields to see for your SELECT. The return response from the API will look something like:
| Code Block | ||
|---|---|---|
| ||
{
"status": "success",
"page": "1",
"count": 1,
"total_count": "1",
"results": {
"RECID": "433",
"TENANTS_RECID": "0",
"MODIFIED_DATE": "2018-01-16 15:30:48",
"MODIFIED_BY": "00137148",
"USERID": "01178496",
"CONTACTS_RECID": "21945"
},
"debug": {
"APIKEY": "gXafmC5zgTv4VRI4GvXdyd7x2lmWmCQJ",
"TYPEFORMAT": "sql.json",
"SQL": "SELECT RECID, TENANTS_RECID, MODIFIED_DATE, MODIFIED_BY, USERID, CONTACTS_RECID FROM USERS WHERE USERID = '01178496'",
"request_method": "POST",
"LIMIT": "20",
"PAGE": "1",
"TENANTS_RECID": "0",
"type": ""
}
} |
AdHoc Grids
Using an AdHoc Grid Users can use the Query Builder to construct an SQL Query to find the RECID you need. All Tables have a RECID column to identify each record of that table.
...
When accessing the 'History Report' Menu Option on a Form, a User can find the RECID at the top of the page. The History Report calls out the RECID as the 'Record ID'.
...
PCR-360 allows Users to share specific records to other authorized Users by the use of direct links to the record in question. Open the Options Menu on the Form, and select the "Get Link" Option.
...