Forum Discussion

damienpage's avatar
damienpage
Qrew Cadet
8 years ago

GetRecordAsHtml & Alternative Key Fields

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
Ask about Quickbase functionality
  • _anomDiebolt_'s avatar
    _anomDiebolt_
    Qrew Elite
    8 years ago
    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.