Getting Started

 View Only
  • 1.  multi records add/edit (mirror records)

    Posted 03-02-2023 22:59

    Hi, 

    I am a beginner here and can't figure out what to do. Really appreciate any help I can get!!!

    I am trying to add multi records from one table to another table with this:

    <records_csv>
          <![CDATA[
    %RepeatOn%
    [Location (3 Letter).csv],[EMP_ID.csv],[First Name.csv],[Last Name.csv],[Full Name (Preferred).csv],[Job Title Description.csv]
    %RepeatOff%
       ]]>
    </records_csv>
    <clist>8.13.23.25.24.26</clist>
    </qdbapi>

    And got an error message:

    <?xml version="1.0" ?>
    <qdbapi>
    <action>API_ImportFromCSV</action>
    <errcode>11</errcode>
    <errtext>Could not parse XML input</errtext>
    <errdetail>XML Parsing Error. unclosed CDATA section at line 2010 column 9 (which is byte 69010)</errdetail>
    </qdbapi>

    I need help! Thanks!!!



    ------------------------------
    Nicole Bruun
    ------------------------------


  • 2.  RE: multi records add/edit (mirror records)

    Posted 03-05-2023 11:29
    Edited by Blake Harrison 03-05-2023 11:30

    Instead of this, have you considered using the Table-to-Table-Import (TTI) option? This will allow you to configure a saved import between tables and trigger it either manually or via Pipelines or Webhooks. A good example of how this can be used can be found in this Help Article.

    Essentially, you select a Source and Destination, map the fields, and then save the configuration. Once you've done that, you can decide how you want to trigger the import. This can be done a number of different ways including using a custom button, webhook, or Pipelines. If you're comfortable with the API, the call you'd use is API_RunImport.

    Hopefully, this points you in the right direction!



    ------------------------------
    Blake Harrison
    bharrison@datablender.io
    /
    ------------------------------



  • 3.  RE: multi records add/edit (mirror records)

    Posted 03-06-2023 23:17

    Thanks, Blake. I figured it out. I didn't need the csv extension because my source is not from a csv file. I took out all the extensions and it worked. Thanks for responding to my post!!!



    ------------------------------
    Nicole Bruun
    ------------------------------