Looking for PowerObjects? Don’t worry, you’re in the right place! We’ve been part of HCL for several years, and we’ve now taken the final step in our acquisition journey: moving our website to the HCL domain. Nothing else is changing – we are still fanatically focused on Microsoft Business Applications!

PowerObjects Blog 

for Microsoft Business Applications


How to Pass MSMQ XML Field Value as Parameter to a Scribe Job with SQL Source

Post Author: Joe D365 |

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!

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!

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

PowerObjects Recommends