blair_elzinga

Re: Can you use sessionMethodsSoap Write and/or WriteCollection to delete table rows using a field other than the primary key? - Adobe Experience Manager 11-05-2017

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 can I get the WSDL for this API?

363

Re: Can you use sessionMethodsSoap Write and/or WriteCollection to delete table rows using a field other than the primary key? - Adobe Experience Manager 11-05-2017

367

Re: Sending a mail using Adobe Campaign API - Adobe Campaign Standard 11-05-2017

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:UpdateSchemaUpdate a schemaUpdateSchema ( XML content)ParameterscontentContentReturn valuesNone.FeaturesSchema: xtk:sqlSchemaStatic: Yes That isn't much different that what the WSDL already gave me. The API needs bet...

1.7K

Can you use sessionMethodsSoap Write and/or WriteCollection to delete table rows using a field other than the primary key? - Adobe Experience Manager 11-05-2017

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 remove based on the date, it returns with an error after 300 seconds. Consistently. And the rows are not removed. When I try to use the WriteCollection API to remove rows based on dates, it returns alm...

642

Re: Get XML source of any object in adobe via JSAPI - Adobe Campaign Standard 11-05-2017

On a related note, you can get the structure of tables through the SOAP API - here's an example for a table 'foo': ...my token... Note that the 'queryDef' node is a child of

1.4K

Re: Campaign SOAP API: How to specify greater-than ('>') or less-than ('<') in ExecuteQuery - Adobe Campaign Standard 11-05-2017

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

800

Re: Campaign SOAP API: How to specify greater-than ('>') or less-than ('<') in ExecuteQuery - Adobe Campaign Standard 11-05-2017

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

771

Re: About write record to a database and remove usless schema database - Adobe Campaign Standard 11-05-2017

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 you're thinking about addressing this in some way. Look forward to it. Thanks.

1.7K

Re: About write record to a database and remove usless schema database - Adobe Campaign Standard 05-05-2017

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 actual delete. Quite a pain to get things deleted for hosted customers!

1.6K

Re: Campaign SOAP API: How to specify greater-than ('>') or less-than ('<') in ExecuteQuery - Adobe Campaign Standard 05-05-2017

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

794

Likes from

User

Count

Learn

Documentation

Community

Support

Resources

Adobe account

Adobe