Dynamics CRM Source: How to modify the FetchXML statement dynamically at runtime
The FetchXML statement is available in the data flow properties list. Follow these steps to set up an expression:
- Create a variable that can be loaded with the desired FetchXML statement. (Example: vFetchXMLModifiedOnDate)
- Right-click on the data flow canvas and select the Properties menu.
- Scroll down and find the properties in the group called Misc.
- Note the name of the property you want to modify dynamically at runtime. It will be named something like this: [Dynamics CRM Source].[FetchXML]. This is the property containing the FetchXML statement.
- Scroll down and find the Expressions property.
Set up an expression for the property noted above using a variable to
modify it dynamically at runtime. Here is an example of how that variable can be use in an expression to add the value from a variable:
"<fetch xmlns:generator='xxxx'><entity name='opportunity'><all-attributes /><filter><condition attribute='modifiedon' operator='gt' value='" + @[User::vFetchXMLModifiedOnDate] + " ' /></filter></entity></fetch>"
Book a Presales Call
Are you new to COZYROC and evaluating our solutions?
Book a Presales Call with us now and get 5% off SSIS+.
Book a Presales Call with us now and get 5% off SSIS+.
Related Articles
Dynamics AX Source: How to modify the statement parameter dynamically at runtime
The statement parameter is available in the data flow properties list. Follow these steps to set up an expression: Create a variable that can be loaded with the desired statement. Right-click on the data flow canvas and select the Properties menu. ...Dynamics CRM Source: How to modify the entity name dynamically at runtime
The entity's name is available in the data flow properties list. Follow these steps to set up an expression: Create a variable that can be loaded with the desired entity’s name. Right-click on the data flow canvas and select the Properties menu. ...Dynamics CRM Destination: How to modify a Dynamics CRM destination entity dynamically at runtime
The destination entity is available in the data flow properties list. Follow these steps to set up an expression: Create a variable that can be loaded with the desired name of the destination entity. Right-click on data flow canvas and select ...NetSuite Source: How to modify the SearchXML statement dynamically at runtime
The SearchXML parameter is available in the data flow properties list. Follow these steps to set up an expression: Create a variable that can be loaded with the desired SearchXML statement. Right-click on the data flow canvas and select ...Dynamics NAV Source: How to modify the Page dynamically at runtime
The Page is available in the data flow properties list. Follow these steps to set up an expression: Create a variable that can be loaded with the desired Page. Right-click on the data flow canvas and select the Properties menu. Scroll down and find ...