Skip to main content
Question

API-Import from CSV and email notification

  • August 17, 2017
  • 0 replies
  • 26 views
Forum|alt.badge.img+6
I have a table that mirrors another table using sync on an hourly schedule. If the value in a particular cell changes after syncing, I have a webhook using API-ImportFrom CSV that checks a box in another table. Upon the checking of that box I have an email notification going out. My impression was that import from CSV makes the changes one by one, which should mean that single record notifications should go out. In my case here, multi record notifications are being sent.
Any thoughts?
    This topic has been closed for replies.

    I believe that import from CSV is a multi record operation as opposed to API_AddRecord which is one by one.  In your case, maybe the sync is syncing slowly and in effect they are updating one by one, but maybe the import from CSV is considered to be a multi record operation even if there is only 1 record in the Import.

    Maybe try the AddRecord API.
    Forum|alt.badge.img+6
    • AlinMihalcea1
    • Author
    • Registered
    • August 17, 2017
    Forgot to mention the fact that I am using Repeat on and repeat off

    Below is the code

    <qdbapi>
    <udata>mydata</udata>
     <usertoken>XXX</usertoken>
    <apptoken>XXX</apptoken>
       <records_csv>
          <![CDATA[
    %RepeatOn%
    [Record ID#2.csv],[Send Daily DFR Notification.csv],[Now.csv]
    %RepeatOFF%
          ]]>
       </records_csv>
       <clist>3.193.185</clist>
    </qdbapi>
    Forum|alt.badge.img+6
    • AlinMihalcea1
    • Author
    • Registered
    • August 18, 2017
    so, I tested the API_AddRecord. Unfortunately, this one only adds one record, even though multiple records have changed as a result of the table sync.
    I'm really stumped...
    The API_import from CSV ads the records in the app, but the notification will go as a multi record and the API_Add Record won't add all the records.

    Anyone else has any ideas? Maybe some javascript? Dan D?
    Terms & ConditionsAccessibility statement