I found an interesting possible alternative in the JS API documentation:path: jsapi-en->JavaScript->Objects, methods and properties->database->DBEngine->batchDelete.The remarks there seem to imply that you can do a PK based delete with a filter on a non-PK field.Can I call this through SOAP? Where c...

I found an interesting possible alternative in the JS API documentation:path: jsapi-en->JavaScript->Objects, methods and properties->database->DBEngine->batchDelete.The remarks there seem to imply that you can do a PK based delete with a filter on a non-PK field.Can I call this through SOAP? Where c...

I find the JSAPI CHM documentation not very helpful.  It often lacks any useful detail.  Sometimes there is an explanation or an example - those *are* useful.  But when not there, it isn't helpful at all.For example - for the xtk->sqlSchema->UpdateSchema call, here is the documentation:UpdateSchemaU...

I have a large custom table that I want to remove targeted rows from on a regular basis, in order to keep the row count at a reasonable number for performance reasons.The primary key (PK) is on an integer field, but I was to delete based on a date field.  However, when I try to use the Write API to ...

On a related note, you can get the structure of tables through the SOAP API - here's an example for a table 'foo':<soapenv:Envelope xmlns:soapenv="http://schemas.xmlsoap.org/soap/envelope/" xmlns:urn="urn:xtk:queryDef">   <soapenv:Header/>   <soapenv:Body>      <urn:ExecuteQuery>         <urn:sessio...

Yes, you found the issue - I didn't realize that I needed to add the semi-colon.  Thanks for the help!