GetRecordAsHtml & Alternative Key Fields

  • 0
  • 1
  • Question
  • Updated 2 years 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 ?


Photo of damien page

damien page

  • 282 Points 250 badge 2x thumb

Posted 2 years ago

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

QuickBaseCoach App Dev./Training, Champion

  • 69,572 Points 50k badge 2x thumb

=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

  • 30,184 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.

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.