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

SOLVED

Update/modify Filters for a Query with SOAP/XML

Avatar

Level 2

What function can I utilize to update/add/modify filters for a query in a workflow? 

 

I asked this similar question (https://experienceleaguecommunities.adobe.com/t5/adobe-campaign-classic-questions/how-do-i-update-th...) but it doesn't really allow me to change it other than by adding new variables via an external signal. The variables themselves are useful but doesn't address adding or removing filters.

1 Accepted Solution

Avatar

Correct answer by
Administrator

Hi @perry_liu ,

Were you able to solve this with the solution provided here? Let us know.

Thanks!

View solution in original post

6 Replies

Avatar

Community Advisor

Hi,

 

Use SOAPAction: xtk:persist#Write

<?xml version='1.0'?>
<SOAP-ENV:Envelope xmlns:xsd='http://www.w3.org/2001/XMLSchema'
	xmlns:xsi='http://www.w3.org/2001/XMLSchema-instance'
	xmlns:ns='urn:xtk:persist'
	xmlns:SOAP-ENV='http://schemas.xmlsoap.org/soap/envelope/'>
	<SOAP-ENV:Body>
		<Write xmlns='urn:xtk:persist' SOAP-ENV:encodingStyle='http://schemas.xmlsoap.org/soap/encoding/'>
			<__sessiontoken xsi:type='xsd:string'></__sessiontoken>
			<domDoc xsi:type='ns:Element' SOAP-ENV:encodingStyle='http://xml.apache.org/xml-soap/literalxml'>
				<workflow _operation="update" id="8620" xtkschema="xtk:workflow">
					<activities>
						<query _operation="update" label="1 equal to 1" name="query">
							<where _operation="delete" id="3450798105"/>
							<where _operation="insert" displayFilter="1 equal to 1" filterName="backGroundFilterFrm" id="3455451164">
								<condition compositeKey="" dependkey="" enabledIf="" expr="1 = 1" internalId="3455254554"/>
							</where>
							<humanCond>Query: 1 equal to 1</humanCond>
						</query>
					</activities>
				</workflow>
			</domDoc>
		</Write>
	</SOAP-ENV:Body>
</SOAP-ENV:Envelope>

 

Thanks,

-Jon

Avatar

Community Advisor
So you have to define what you want to remove and what you want to add <where _operation ="delete" id ="3450798105" /> nice.. 🙂

Avatar

Correct answer by
Administrator

Hi @perry_liu ,

Were you able to solve this with the solution provided here? Let us know.

Thanks!