GetRecordAsHtml & Alternative Key Fields

  • 0
  • 1
  • Question
  • Updated 1 year ago
  • Answered
I would like to be able to pull details of records thru the use of a specific fields (field is 6 characters which are both numeric and alphabetic, for example '123ABC'.

I have set the field that contains said text as the key field, then tried the following call...

=API_GetRecordAsHtml&rid=613SLR.html ( I have taken out all before this)

The response I get is as follows..

'Sorry, there is no record in this application table with the record identifier (rid) of "613".'

Is not possible as the key field have to be numeric or am I going wrong elsewhere ?


Cheers,

Damien
Photo of damien page

damien page

  • 282 Points 250 badge 2x thumb

Posted 1 year ago

  • 0
  • 1
Photo of QuickBaseCoach App Dev./Training

QuickBaseCoach App Dev./Training, Champion

  • 53,038 Points 50k badge 2x thumb
Try

=API_GetRecordAsHtml&key=613SLR.html ( I have taken out all before this)
Photo of Ⲇanom the ultimate (Dan Diebolt)

Ⲇanom the ultimate (Dan Diebolt), Champion

  • 27,954 Points 20k badge 2x thumb
If that does not work it may be that &key is not supported on this API. The parameter &key is not listed in the docs as an allowed parameter.

https://help.quickbase.com/api-guide/index.html#getrecordashtml.html

If &key does work there may be an oversight in the API documentation.

In any case I would use script to call act=API_DoQuery or act=API_GetRecordInfo querying for key=613SLR.html and then extract the [Record ID#] value and then proceed to call act=API_GetRecordAsHTML supplying the now known [Record ID#] value.
(Edited)