Update/modify Filters for a Query with SOAP/XML

Forum|Forum|5 years ago
August 12, 2020
3 replies
2323 views

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-the-filter-on-a-query-through-soap/qaq-p/372697) 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.

This post is no longer active and is closed to new replies. Need help? Start a new post to ask your question.

Best answer by Sukrity_Wadhwa

Hi @perry_liu ,

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

Thanks!

Jonathon_wodnicki

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