Trying my first web hook. This is the code so far:MyData%b33nat_ks4k_dkqpnf9dgmkmb2bhh-----%[items_total]"W - Won""Bombouche"[products][total_ex_tax]This is for when a record is added.Http: POST, Format XML, Message header QUICKBASE-ACTION / API_AddRecordError MessageAPI_AddRecord11Could not parse XML inputXML Parsing Error. not well-formed (invalid token) at line 4 column 21 (which is byte 103)mydataI watched a youtube guide on this and have looked around this site but can't find an answer for it. Is there a working example out there, I'd would like a screen print if possible. I'm not sure if anything has changed since the video was put up and now. I had this with an app token but that failed with the same issue too. The user token is brand new.

If that is the actual user token, it looks incorrect.

Hi Jack,As a best practice for User Token you would want to keep them secure and be careful of sharing them. They function as a form of authentication within our API calls and can allow access to your data. To be on the safe side the end of this User Token has been cut out. If that was an actual User Token I would suggest deactivating it and instead replacing it with a new one if possible just to be on the safe side. As for error code 11 that error often comes up when the body of a Webhook contains XML characters that the API has trouble differentiating from your actual Webhook code. They can cause the message to become garbled. Do any of these fields you are passing over contain text elements and possible unique characters or XML character? Common culprits can be ", ', <, >, and &.

Thank you, I'll delete the user token but this is my test db but I'll be more careful, thankyou for answer, I'll check the data and see what pop's up.

I've checked the data and can't see any offending characters, if this is working as I'd expect it to I just added one order to the source table I'd expect to see this appear in the destination table but the information is very simple and no strange characters. The tables are about a year old so this web hook would be a new thing and cuts out a bit of manual work. Would the script just be looking at the new row or the entire table?

Whenever the webhook was triggered it would only be looking at any records that triggered the webhook, not the full table. If you are seeing that error still and your body doesn't have any of the possible trouble characters in it then there might just be a syntax error. In your live one did you have % signs around the usertoken as your example did? Also it looks like some of the markup may have gotten chewed up by the forum, could you repost the webhook again and I would suggest using the pre setting in the format bar when you submit it to help keep it from being chewed up by the forum input. I would be happy to give it another look over and see if anything jumps out at me.

First Webhook, First Error. API_AddRecord

19 Replies

QuickBaseCoachD
Qrew Captain
7 years ago
... I'm late to chime on on this thread, but out of curiosity, are you using a Webhook to learn the syntax for tacking something more complicated in the future? ie why not just use a no code Automation? Or is this perhaps a Cross Realm Webhook (which can probably be done with an Action).
JackFretwell
Qrew Assistant Captain
7 years ago
Trying stuff out, I'm not familiar with all the components of Quickbase and do have a table from Big Commerce which needs loading.

But, I would like to know if you can put two fields from the source into one field in the destination, I've not seen any syntax for this so just going one for one at the moment.
- Laura_Thacker
  Qrew Commander
  7 years ago
  Build a formula in the source table to combine the two field values; and then push the value of the formula into the destination field.
- JackFretwell
  Qrew Assistant Captain
  7 years ago
  I've done that as
  
  <field fid="10">[items_total][Company Name]</field>
  
  But I don't know the correct coding for a space, e.g.
  
  <field fid="10">[items_total] & " " & [Company Name]</field>
  
  I'm sure this would fail and I'm tempted to try:-
  
  <field fid="10">[items_total]%20[Company Name]</field>
  
  But can't find anything regarding this scenario, anywhere.
- Laura_Thacker
  Qrew Commander
  7 years ago
  No, build a formula in your table to combine the two field values together. I do not believe you can push two values from separate fields into a single field within a Webhook. I'm happy to be corrected. But creating a formula specifically for this purpose in the table would be the easiest solution.

JackFretwell

Qrew Assistant Captain

7 years ago

For anyone who finds this, a few hints:

<field fid="11">[products], [billing_company], [billing_first_name] [billing_last_name]</field>
You can add more than one source field for a destination field, and put commas between the fields.  

Populating a drop down:
<field fid="14">W - Won</field>
Don't use quotation marks in the field value.

Forum Discussion

First Webhook, First Error. API_AddRecord

19 Replies

Related Content

Delete Formula Button Error

API_AddRecord Alternative URL Redirect

404 Error on new nav

429 Error: Webhooks are exceeding the rate threshold

Webhook Pipeline Question