Forum Discussion

JeffRogerson's avatar
JeffRogerson
Qrew Cadet
5 years ago

API_AddRecord To Enter Scanned Bar Codes Into Database

Hello,

I am trying to build a POST add_record url to enter the data from scanned bar codes into a field and generate a new record.

I have a barcode reader that will build a POST url and I have successfully established the URL to get it to generate a new record  in the desired Quickbase table, but I can't get the read bar code data to populate the desired field.  Instead, when the bar code reader executes the url, it generates a new but empty record.

Here is my url...  https://target url (yes I am using my url)/db/bqpwxx32at?a=API_AddRecord&_fid_6  

I have turned off the app token so none is required (for the build stage) and the field ID of the field I wish to populate is 6.

Any help is appreciated.

Jeff

------------------------------
JRogerson JRogerson
------------------------------
  • is that the complete URL for the end part?

    ?a=API_AddRecord&_fid_6  

    ------------------------------
    Mark Shnier (YQC)
    Quick Base Solution Provider
    Your Quick Base Coach
    http://QuickBaseCoach.com
    mark.shnier@gmail.com
    ------------------------------
    • JeffRogerson's avatar
      JeffRogerson
      Qrew Cadet
      That's all I have Mark (normally there would be an additional &apptoken=xxxxx to verify authorization to execute, but for the time being as this is just a trial build, I have turned it off app tokens). 

      In the API Guide, it shows the content data of the field as part of the url, example fid_6=the data to go in the field  , but the data I want to capture is the contents of the bar code.

      So my url  generates a 0 error code and an update id.... a new record is built with no data captured in the desired field.

      ------------------------------
      JRogerson JRogerson
      ------------------------------
      • JeffRogerson's avatar
        JeffRogerson
        Qrew Cadet
        I got it Mark... in the url I had to add an action generated by the bar code reader so the quickbase api knew where the data was coming from.....   works like a charm....  my first really functional API is forty characters long....

        ------------------------------
        JRogerson JRogerson
        ------------------------------