Discussions

 View Only
  • 1.  Webhooks and Commas

    Posted 08-05-2020 06:06
    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
    ------------------------------


  • 2.  RE: Webhooks and Commas

    Posted 08-05-2020 13:02
    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.