Skip to main content
Question

GetRecordAsHtml & Alternative Key Fields

  • November 6, 2017
  • 0 replies
  • 25 views
Forum|alt.badge.img+5
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
    This topic has been closed for replies.

    Try

    =API_GetRecordAsHtml&key=613SLR.html ( I have taken out all before this)
    • anomDiebolt
    • Quickbase Alumni
    • November 6, 2017
    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.
    Terms & ConditionsAccessibility statement