Forum Discussion

DanMcLaughlin's avatar
DanMcLaughlin
Qrew Trainee
4 years ago

Webhooks and Commas

Here is my Dilemma:
I have a table that i use an an import template to bring price lists into my database.  Once date is prepped I use a checkbox to fire web hooks that distribute the date to all related tables.  Whenever it sees a comma in the currency fields it thinks its a delimiter and corrupts my data.

Looking for a fresh perspective.

Here is the code:<qdbapi>
<udata>mydata</udata>
<usertoken>%user.token.b5j4s2_nxee_cj32.Add price list%</usertoken>
<apptoken>pec4yzstjethdn47tr5dz5qdbj</apptoken>
<records_csv>
<![CDATA[
%RepeatOn%
[Description],[Related Category],[Related Type],[Unit of Measure],[Related Vendor],[Unit cost],[Unit MAP],[Unit List],[MFG #],[Model],[Weight],[Model Num],[Image]
%RepeatOff%
]]>
</records_csv>
<clist>7.17.15.8.72.74.75.76.77.79.40.78.81</clist>
</qdbapi>

------------------------------
Dan McLaughlin
------------------------------
APIs and custom code
webhook

1 Reply

Sort By
  • AustinK's avatar
    AustinK
    Qrew Commander
    4 years ago
    How does the raw line of the csv file you are uploading look? Specifically a line that is causing issues?

    The line should have double quotes around the number in question if it has a comma inside it. That might allow it to be uploaded I think, although the preferred way is to just have your data without commas in the first place. If it is just a number like 14567.88 then Quick Base can handle displaying that in the way you prefer, like $14,567.88.