POWEROBJECTS

718 Washington Ave. N. Suite #101
Minneapolis, MN 55401
View map and all Locations

Send us a message

Have you run into a scenario where you want to use the Scribe publisher for CRM and generate an XML file, while only using the primary key as the parameter for a DTS with SQL as source? If this is something that you would like to do, today’s blog will show you how!

MSMQ XML Field Value

Scribe publisher for CRM can generate an XML file whenever there is an action (Insert, Update, or Delete) in CRM based on your settings. However, it will not be able to publish all the required data from multiple entities that might be needed for processing.

In this example below, we will publish “Sales Order Detail” record.

MSMQ XML Field Value

Then pass the salesorerdetailid key as a parameter to the DTS.

MSMQ XML Field Value

In Scribe workbench, create a user variable to accept that parameter.

MSMQ XML Field Value

And use that parameter in the source query.

MSMQ XML Field Value

And there you have it! Now you know how to pass MSMQ XML field value as parameter to a scribe job with SQL source. If you would like more information or have questions, please consider opening a support request with PowerObjects today!

Happy Dynamics 365’ing!

Avatar for JoeCRM

JoeCRM

Joe CRM is a CRM superhero who runs on pure Microsoft Dynamics CRM adrenaline. As the face of PowerObjects, Joe CRM’s mission is to reveal innovative ways to use Dynamics CRM and bring the application to more businesses and organizations around the world.