I am looking for syntax and usage of the rid field for the API_GetRecordInfo call. . How do I reference a different field in the table to pull a record?

  • 0
  • 1
  • Question
  • Updated 4 years ago
  • Answered

 I have tried replacing "rid" with the name of the field i want to search but it gives the error: API_GetRecordInfo 30     No such record     Missing "rid" parameter

Photo of Justry Weir

Justry Weir

  • 10 Points

Posted 4 years ago

  • 0
  • 1
Photo of Jack

Jack, Champion

  • 50 Points
The rid parameter defines the record to be accessed (a unique value), if you are using a different field as the primary key you need to replace rid with krid. You must replace the rid or krid value with the specified field that contains the record ID or primary key field value.

Here's an example formula below:
Replace DATABASE ID with the DATABASE ID of the table
Replace field name
Replace app token

URLRoot() & "db/DATA BASE ID?a=API_GetRecordInfo&rid="& [FIELD NAME] &"&apptoken=ENTER APP TOKEN HERE