Classic file types are no longer available for use as of January 2021. You can transition your classic files or download a PDF. Learn More

DML in WData Table?

Answered
Request Demo

Is it possible to perform basic DML statements such as insert into or update in WData tables via Chains / API?  What are my options for modifying data in a Table?  I know I can import a file into a table.  But if I now want to update all rows where column X = some value?  As far as I understand the API "Update a single table" is for DDL updates, not DML.

0

Comments

1 comment

Date Votes
  • Jeff Hickey

    Hi Waldo, To ensure data integrity, the SQL editor supports read-only statements like SELECT, but not read/write statements like INSERT or DELETE. If you would like to update data in a Wdata table, you'll need to identify the file it is associated to, unimport/delete the file from the table, then upload a new file containing the correction(s) as well as the all old unchanged data that was in the original file.

    0

Please sign in to leave a comment.