Discussions

Expand all | Collapse all

GetRecordAsHtml & Alternative Key Fields

  • 1.  GetRecordAsHtml & Alternative Key Fields

    Posted 11-06-2017 06:39
    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


  • 2.  RE: GetRecordAsHtml & Alternative Key Fields

    Posted 11-06-2017 11:53
    Try

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


  • 3.  RE: GetRecordAsHtml & Alternative Key Fields

    Posted 11-06-2017 12:45
    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.