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...

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!

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

I think the client U/I is used by folks that aren't savvy with databases, so I understand you point there.  However, there isn't any good reason why you couldn't expose database functions like delete table to the data API, which isn't used by folks who accidentally delete tables.Glad to hear that yo...

A note on the physical delete of the table - if your solution is hosted by Adobe and not on-premise, then you don't have access to the database to delete the table.  You'll need to open a ticket with support to delete the table.  They will in turn open an internal ticket with tech-ops to do the actu...

Apparently, '<' does not work, but '>' does.Therefore, a solution is to use NOT (... > ...) which will be equivalent to (... < ...)Weird!

The mystery deepens:I just tried this query, and it works with '>'!?:<queryDef schema="nms:recipient" operation="select" lineCount="100">       <select>           <node expr="@email"/>           <node expr="@lastName"/>           <node expr="@firstName"/>       </select>       <where>           <con...

here is my full soap contents:<soapenv:Envelope xmlns:soapenv="http://schemas.xmlsoap.org/soap/envelope/" xmlns:urn="urn:xtk:queryDef">   <soapenv:Header/>   <soapenv:Body>      <urn:ExecuteQuery>         <urn:sessiontoken>[deleted]</urn:sessiontoken>         <urn:entity><queryDef operation="select"...

Hi, I have a simple query where I'm trying to use greater-than or less-than in a query.  The documentation has multiple examples of this, such as:<where>  <condition expr="(@age > 15 or @age <= 45) and  (@city = 'Newton' or @city = 'Culver City') "/></where>However, when I use a similar query, <cond...