Scribe Insight Limitation – XML Source doesn’t support repeating sibling nodes


Recently we were evaluating Scribe Insight as our Integration tool for one of our clients. The requirement was to read an xml and create records in Dynamics 365 CE. The basic structure was something like below, with Account as the parent tag and Payment, Assets, Consumer as repeating child nodes of Account i.e. 1 – … Continue reading “Scribe Insight Limitation – XML Source doesn’t support repeating sibling nodes”

Scribe Online – Working with Upsert Block in Dynamics 365 CE


Continuing our previous posts on Scribe Online, let us look at the Upsert block for Dynamics 365 CRM Connector. The way it works is à The Upsert block will have a field called alternatekeyname where we need to provide the name of the alternate key as shown below. In CRM à Along with passing the … Continue reading “Scribe Online – Working with Upsert Block in Dynamics 365 CE”

Scribe Online – Working with Hierarchical Data in Dynamics 365 CE


In the previous post, we saw how to create XML connection and using it as a source to create records in Dynamics 365 CE. https://nishantrana.me/2019/01/11/scribe-online-xml-to-dynamics-365-ce/ In this post, we will see how to consume the hierarchical XML data as a source and create parent-child records in Dynamics 365 CE. Suppose this is our source data … Continue reading “Scribe Online – Working with Hierarchical Data in Dynamics 365 CE”

Scribe Online – XML to Dynamics 365 CE


Follow the earlier posts to create the Scribe Online trial and steps to create an integration solution. Below is our sample XML file that holds the contact information that we want to create inside Dynamics 365 CE For creating XML connection, we need the XSD file. So let us generate the XSD file using the … Continue reading “Scribe Online – XML to Dynamics 365 CE”

Scribe Online: Working with Lookup block – Dynamics 365 CE


Let us continue with our previous post in which we created a solution to pull data from SQL On-Premise and create lead records in Dynamics 365. Let us create a new table which will be our source here. Table Name – Transaction 2 columns – ID and Brand. Transaction and Brand have n -1 relationship … Continue reading “Scribe Online: Working with Lookup block – Dynamics 365 CE”

Working with OptionSet \ Picklist in Scribe Online


Scribe Online makes it very easy to work with OptionSets while writing Integration and Replication solutions. While creating the Dynamics 365 CE connection we can check the Include Picklist Display Names checkbox. Scribe generates a corresponding field schemaname_displayname that holds the label for the corresponding option set. Within our Query Block inside an integration type … Continue reading “Working with OptionSet \ Picklist in Scribe Online”