Skip to main content

SCRIBE Connector Development - Handling Array List

Are you working on creating a connector with SCRIBE's CDK?  In your connector do you have an array of strings or list of  strings that you need to pass?  SCRIBE makes this easy to do within the CDK and SCRIBE Online.

I came across this scenario on a connector I was creating that passes a JSON message to an API.  In the JSON message it had a list of strings for entity ID's. Here is an easy way to accomplish this:

1) Create you Property Definition as past or your Object Definition.
1:  new PropertyDefinition  
2:  {
3:        Description = "Use TOLIST() to pass in a list of entity id's.",  
4:        FullName = "Entity IDs",  
5:        IsPrimaryKey = false,  
6:        MaxOccurs = 1,  
7:        MinOccurs = 0,  
8:        Name = "PublishTo",  
9:        Nullable = true,  
10:       NumericPrecision = 0,  
11:       NumericScale = 0,  
12:       PresentationType = "string",  
13:       PropertyType = typeof(string).Name,  
14:       UsedInActionInput = true,  
15:       UsedInActionOutput = true,  
16:       UsedInLookupCondition = true,  
17:       UsedInQueryConstraint = true,  
18:       UsedInQuerySelect = true,  
19:       UsedInQuerySequence = true  
20   }  

Here I want to note lines 12 and 13.  Set these to the value types that your list will contain.  In this case we will have a list of strings.

2) Publish connector so you can use it in SCRIBE Online.
3) Create your mapping and for this attribute use the TOLIST() function.  It can be found in Functions -> Conversion -> TOLIST().

This function takes 6 arguments all separated by a comma.
1) The list of items. Example "ABC123, DEF456, GHI789" - Here you can use a function to read from a source instead of typing in all the data.
2) The delimiter we used to separate the list. Example ","
3) The type for the data.  Example "string"
4) How to sort the data.  Example "a" for ascending.
5) Do you want to remove quotes?  Example true.
6) Do you want to remove empty values? Example true.

Here is the expression completed with the examples above:
 TOLIST("ABC123, DEF456, GHI789", ",", "string", "a", true, true)  

Here is the output:
 "EntityIDs":   
 [  
   "ABC123",  
   "DEF456",  
   "GIH789"  
 ]  

Comments

Popular posts from this blog

Azure Blob Storage For Storing Microsoft Dynamics 365 Attachments

In my Living In SCRIBE Online Blog I talked about work I did to migrate CRM 4.0 on-premise to Dynamics 365 using SCRIBE Online.  In that blog I mentioned how there are about 80 GB worth of attachments that had to be moved into the cloud.  Well this could quickly get expensive if we stored them directly in CRM.  Also, this client wasn't using SharePoint.  So what option do we have to store this data so end users can access the data?  Why not use Azure Blob Storage?

Microsoft has an app in AppSource to move attachments from CRM to Azure blob storage.  Not only does it all for this, but it also has a web resource in it so you can allow for bulk uploads.  Here is how to set it up:

1) Go To AppSource
2) Install the Attachment Management App by clicking the "Get It Now" button under the image.
3) While its installing go to Azure and setup your blob storage account.
4) For each CRM instance you will need to setup 2 containers in your blob storage.  One is for email attachments …

Dynamics 365 v9 Unit Testing and .NET Confusion

Recently while creating a plugin for Dynamics 365 v9, I ran into an issue trying to connect to CRM via the tooling connector in my unit test project.  The underlying problem was that the .NET version I was using in my unit test was 4.5.2.  This was preventing me from being able to connect to CRM to create my organization service.  I updated the .NET version on my unit test project to 4.6.1 and was then finally able to connect.  I will also add that I am using the latest nuget package version for Dynamics 365 v9.

For consistence, I updated the plugin project I was working on to .NET 4.6.1.  Locally, everything was working great.  I was able to connect to CRM and make sure that all the methods I had written did what they where suppose to do using test driven development practices.

Then when publishing my plugin via the latest version of the plugin registration tool, I received an error and could not publish my plugin.  The error was due to the .NET version of my plugin project not bein…

XrmToolBox Bulk Attachment Manager - Version 2018.2.2.7 Released!

Today I have published version 2018.2.2.7 of my XrmToolBox plugin.  The purpose of this plugin is to make it easy to download and backup attachments in CRM.  This release is a major release as it is the first built version with all pieces working.  The first version only had note downloads working.

Overview of Plugin:
Current Version: 2018.2.2.7Purpose: Download Attachments and E-Mail attachmentsGitHub Link.GitHub Wiki Link.Nuget Package Link.How To Use The Tool: Launch XRMToolBox.Connect to organization.Step 1, choose what you want to download. (Once a choice is made, Step 2 becomes usable)Notes - Download attachments from note entity.E-Mail - Download attachments from emails.Both - Downloads attachments from notes and emails entities.Step 2, choose if you want to download all attachments in the system or specific attachments.  All Attachments - This will search the chosen entity to find all records that have an attachment and download them.Click on "Browse" and choose where t…