Discussions

Expand all | Collapse all

API_AddRecord To Enter Scanned Bar Codes Into Database

  • 1.  API_AddRecord To Enter Scanned Bar Codes Into Database

    Posted 19 days ago
    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
    ------------------------------


  • 2.  RE: API_AddRecord To Enter Scanned Bar Codes Into Database

    Posted 19 days ago
    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
    ------------------------------



  • 3.  RE: API_AddRecord To Enter Scanned Bar Codes Into Database

    Posted 19 days ago
    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
    ------------------------------



  • 4.  RE: API_AddRecord To Enter Scanned Bar Codes Into Database

    Posted 19 days ago
    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
    ------------------------------



  • 5.  RE: API_AddRecord To Enter Scanned Bar Codes Into Database

    Posted 19 days ago
    Well the limit on the length of a URL is in the thousands of characters, so you have headroom for more complexity  :)

    ------------------------------
    Mark Shnier (YQC)
    Quick Base Solution Provider
    Your Quick Base Coach
    http://QuickBaseCoach.com
    mark.shnier@gmail.com
    ------------------------------