Your achievements

Level 1

0% to

Level 2

Tip /
Sign in

Sign in to Community

to gain points, level up, and earn exciting badges like the new
Bedrock Mission!

Learn more

View all

Sign in to view all badges

blair_elzinga
Community profile blair_elzinga Level 2
Job title here
Location here
9 BADGES
Level 2

Level 2

Learn more
Joined the community 30-05-2017 7:10:36 AM
Offline
Top badges earned by blair_elzinga
Customize the badges you want to showcase on your profile
Re: Can you use sessionMethodsSoap Write and/or WriteCollection to delete table rows using a field other than the primary key?
Avatar
Give Back 10
Level 2
blair_elzinga
Level 2

Likes

4 likes

Total Posts

15 posts

Correct reply

0 solutions
Top badges earned
Give Back 10
Ignite 3
Give Back 5
Give Back 3
Give Back
View profile
blair_elzinga
- Adobe Experience Manager
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?

Views

288

Likes

0

Replies

0
Re: Can you use sessionMethodsSoap Write and/or WriteCollection to delete table rows using a field other than the primary key?
Avatar
Give Back 10
Level 2
blair_elzinga
Level 2

Likes

4 likes

Total Posts

15 posts

Correct reply

0 solutions
Top badges earned
Give Back 10
Ignite 3
Give Back 5
Give Back 3
Give Back
View profile
blair_elzinga
- Adobe Experience Manager
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?

Views

292

Likes

0

Replies

0
Re: Sending a mail using Adobe Campaign API
Avatar
Give Back 10
Level 2
blair_elzinga
Level 2

Likes

4 likes

Total Posts

15 posts

Correct reply

0 solutions
Top badges earned
Give Back 10
Ignite 3
Give Back 5
Give Back 3
Give Back
View profile
blair_elzinga
- Adobe Campaign Standard
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...

Views

1.4K

Like

1

Replies

0
Can you use sessionMethodsSoap Write and/or WriteCollection to delete table rows using a field other than the primary key?
Avatar
Give Back 10
Level 2
blair_elzinga
Level 2

Likes

4 likes

Total Posts

15 posts

Correct reply

0 solutions
Top badges earned
Give Back 10
Ignite 3
Give Back 5
Give Back 3
Give Back
View profile
blair_elzinga
- Adobe Experience Manager
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...

Views

567

Likes

0

Replies

3
Re: Get XML source of any object in adobe via JSAPI
Avatar
Give Back 10
Level 2
blair_elzinga
Level 2

Likes

4 likes

Total Posts

15 posts

Correct reply

0 solutions
Top badges earned
Give Back 10
Ignite 3
Give Back 5
Give Back 3
Give Back
View profile
blair_elzinga
- Adobe Campaign Standard
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

Views

1.1K

Like

1

Replies

0
Re: Campaign SOAP API: How to specify greater-than ('>') or less-than ('<') in ExecuteQuery
Avatar
Give Back 10
Level 2
blair_elzinga
Level 2

Likes

4 likes

Total Posts

15 posts

Correct reply

0 solutions
Top badges earned
Give Back 10
Ignite 3
Give Back 5
Give Back 3
Give Back
View profile
blair_elzinga
- Adobe Campaign Standard
Yes, you found the issue - I didn't realize that I needed to add the semi-colon. Thanks for the help!

Views

631

Likes

0

Replies

0
Re: Campaign SOAP API: How to specify greater-than ('>') or less-than ('<') in ExecuteQuery
Avatar
Give Back 10
Level 2
blair_elzinga
Level 2

Likes

4 likes

Total Posts

15 posts

Correct reply

0 solutions
Top badges earned
Give Back 10
Ignite 3
Give Back 5
Give Back 3
Give Back
View profile
blair_elzinga
- Adobe Campaign Standard
Yes, you found the issue - I didn't realize that I needed to add the semi-colon. Thanks for the help!

Views

602

Likes

0

Replies

0
Re: About write record to a database and remove usless schema database
Avatar
Give Back 10
Level 2
blair_elzinga
Level 2

Likes

4 likes

Total Posts

15 posts

Correct reply

0 solutions
Top badges earned
Give Back 10
Ignite 3
Give Back 5
Give Back 3
Give Back
View profile
blair_elzinga
- Adobe Campaign Standard
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.

Views

1.5K

Likes

0

Replies

0
Re: About write record to a database and remove usless schema database
Avatar
Give Back 10
Level 2
blair_elzinga
Level 2

Likes

4 likes

Total Posts

15 posts

Correct reply

0 solutions
Top badges earned
Give Back 10
Ignite 3
Give Back 5
Give Back 3
Give Back
View profile
blair_elzinga
- Adobe Campaign Standard
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!

Views

1.3K

Like

1

Replies

0
Re: Campaign SOAP API: How to specify greater-than ('>') or less-than ('<') in ExecuteQuery
Avatar
Give Back 10
Level 2
blair_elzinga
Level 2

Likes

4 likes

Total Posts

15 posts

Correct reply

0 solutions
Top badges earned
Give Back 10
Ignite 3
Give Back 5
Give Back 3
Give Back
View profile
blair_elzinga
- Adobe Campaign Standard
Apparently, '<' does not work, but '>' does.Therefore, a solution is to use NOT (... > ...) which will be equivalent to (... < ...)Weird!

Views

625

Likes

0

Replies

0
Re: Campaign SOAP API: How to specify greater-than ('>') or less-than ('<') in ExecuteQuery
Avatar
Give Back 10
Level 2
blair_elzinga
Level 2

Likes

4 likes

Total Posts

15 posts

Correct reply

0 solutions
Top badges earned
Give Back 10
Ignite 3
Give Back 5
Give Back 3
Give Back
View profile
blair_elzinga
- Adobe Campaign Standard
The mystery deepens:I just tried this query, and it works with '>'!?:

Views

611

Likes

0

Replies

0
Re: Campaign SOAP API: How to specify greater-than ('>') or less-than ('<') in ExecuteQuery
Avatar
Give Back 10
Level 2
blair_elzinga
Level 2

Likes

4 likes

Total Posts

15 posts

Correct reply

0 solutions
Top badges earned
Give Back 10
Ignite 3
Give Back 5
Give Back 3
Give Back
View profile
blair_elzinga
- Adobe Campaign Standard
here is my full soap contents: [deleted]

Views

603

Likes

0

Replies

0
Campaign SOAP API: How to specify greater-than ('>') or less-than ('<') in ExecuteQuery
Avatar
Give Back 10
Level 2
blair_elzinga
Level 2

Likes

4 likes

Total Posts

15 posts

Correct reply

0 solutions
Top badges earned
Give Back 10
Ignite 3
Give Back 5
Give Back 3
Give Back
View profile
blair_elzinga
- Adobe Campaign Standard
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: However, when I use a similar query, I get the response: SOAP-ENV:Client The XML SOAP message is invalid (service 'ExecuteQuery', method 'xtk:queryDef'). (16:38) : A '<' character cannot be used in attribute 'expr', except through &lt;...So then I try as the error message suggests and use '&lt' instead of <<condition expr="@id &lt 5000"/>and I get a ...

Views

1.7K

Likes

0

Replies

7
Re: Need a little help with queryDefMethodsSoapClient - using the SOAP client
Avatar
Give Back 10
Level 2
blair_elzinga
Level 2

Likes

4 likes

Total Posts

15 posts

Correct reply

0 solutions
Top badges earned
Give Back 10
Ignite 3
Give Back 5
Give Back 3
Give Back
View profile
blair_elzinga
- Adobe Campaign Standard
Thanks for the response Amit. I came back to this and now it is working and I'm not sure what changed.

Views

517

Likes

0

Replies

0
Need a little help with queryDefMethodsSoapClient - using the SOAP client
Avatar
Give Back 10
Level 2
blair_elzinga
Level 2

Likes

4 likes

Total Posts

15 posts

Correct reply

0 solutions
Top badges earned
Give Back 10
Ignite 3
Give Back 5
Give Back 3
Give Back
View profile
blair_elzinga
- Adobe Campaign Standard
Through the forum, I've been able to formulate working ExecuteQuery examples in SOAP U/I. However, when trying to get the same to work in c#, it isn't clear to me how to get the response data.Here's a snippet of my code:XmlElement response = null; try { XmlElement xml = buildQuery(); response = client.ExecuteQuery(secureToken, xml); client.Close(); } catch (FaultException f) {The ExecuteQuery runs without exception, but when I look at the returned XmlElement, it only contains the empty structure...

Views

702

Like

1

Replies

4
Likes from