DanMcLaughlin
5 years agoQrew Trainee
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
------------------------------
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
------------------------------