Forum Discussion

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 s...

APIs and custom code

MarkShnier__You

Icon for Qrew Legend rank

Qrew Legend

5 years 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
------------------------------

JeffRogerson
Qrew Cadet
5 years 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
------------------------------
- JeffRogerson
  Qrew Cadet
  5 years 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
  ------------------------------
  - MarkShnier__You
    Qrew Legend
    5 years 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
    ------------------------------