Skip to main content
Question

Webhooks and Commas

  • August 5, 2020
  • 0 replies
  • 45 views
Forum|alt.badge.img+5
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
------------------------------
This topic has been closed for replies.

  • AustinK
  • Registered
  • August 5, 2020
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.
Terms & ConditionsAccessibility statement