chrisbodman
New Contributor II
Joined 5 years ago
User Profile
User Widgets
Contributions
Re: CRM Snap Pack - Resolve Incidents (Cases0
Hi, Thank you for the responses. I am familiar with the Microsoft Dynamics 365 product family, what with me being a Microsoft Dynamics Developer. I’ve also worked extensively with the Web API, having written my own APIs and console applications that utilize the SDK. The only operations we have available in our version of the CRM Snap pack are; MS Dynamics CRM 1 Snaps Dynamics CRM Create Dynamics CRM Delete Dynamics CRM Read Dynamics CRM Search Dynamics CRM Update Dynamics CRM Upsert None of these will invoke the CloseIncidentRequest required by the 8.2 version of the CRM Framework. I’ll speak to our Account Manager at our meeting this afternoon to see where we go from here.3KViews0likes0CommentsCRM Snap Pack - Resolve Incidents (Cases0
Hi Everyone, Is the Dynamics CRM Snap pack not really used? I can’t seem to find much guidance on how to use it? We’ve run into an issue where we can’t resolve cases. In the SDK or using the API, we need to execute a close incident request (which involves creating a new instance of the incident resolution and passing it as a parameter to the method). Obviously I know we need to do it slightly differently using Snap, but there doesn’t seem to be any Snaplogic documentation around it. The error I’m getting is OrganizationServiceFault ErrorCode: -2147220970, Message: This message can not be used to set the state of incident to Closed. In order to set state of incident to Closed, use the CloseIncidentRequest message instead. Is anyone able to offer some guidance? It seems like this crucial part of integrating with CRM is missing.3.4KViews0likes4CommentsMapper following Group By Field
Hi Everyone, I have a record, that has a field of CSVs. I split the CSVs using the JSON splitter, and then use a group by fields snap to create my objects which have the recordId, and the individual values from the CSV field. I end up with what I need ( {Id:1, Roof:true}, {Id:1, doors:true}), but then I need to have the object created with the options as fields… So {Id:1, Roof:true, doors:true}. Sometimes, there’s no roof attribute, or doors attribute. There could be 1 field in the original CSV field, there could be 10.2.7KViews0likes1CommentSetting Option set values in CRM
Hi Everyone, Can you set an optionset value using the int value rather than the string name? Also, do we need to refresh the meta data after adding new values in our CRM environment? We’ve added a new value which we can see in the front end and in the database, but snap keeps telling us that the value doesn’t exist. Definitely pointing at right database, value definitely exists.1.4KViews0likes0CommentsRe: Not Comparable Objects: BigInteger 350930 and Integer 350930
Hi, It works in validation if I give it a static value. So, if I have the expression, $propertyid == 123456, it’ll work fine in validation, but then I get the error if I try to execute it. If I have $propertyid == propId, it’ll fail both in validation and execution with the same error (which is the same as the other error message). Reason: Not comparable objects: BigInteger 350930 and Integer 350930 Hide Details... Join[5fd9a86c47060ece477be9b6_087b0009-f8f6-4091-a8c5-3223a624649d -- 15187eed-c7f4-4a27-941c-19d928dcf354] com.snaplogic.snap.api.SnapDataException: Failed to perform join operation at com.snaplogic.snaps.transform.MultiJoin.execute(MultiJoin.java:216) at com.snaplogic.cc.snap.common.SnapRunnableImpl.executeSnap(SnapRunnableImpl.java:770) at com.snaplogic.cc.snap.common.SnapRunnableImpl.execute(SnapRunnableImpl.java:552) at com.snaplogic.cc.snap.common.SnapRunnableImpl.doRun(SnapRunnableImpl.java:836) at com.snaplogic.cc.snap.common.SnapRunnableImpl.call(SnapRunnableImpl.java:402) at com.snaplogic.cc.snap.common.SnapRunn ableImpl.call(SnapRunnableImpl.java:116) at java.base/java.util.concurrent.FutureTask.run(Unknown Source) at java.base/java.util.concurrent.Executors$RunnableAdapter.call(Unknown Source) at java.base/java.util.concurrent.FutureTask.run(Unknown Source) at java.base/java.util.concurrent.ThreadPoolExecutor.runWorker(Unknown Source) at java.base/java.util.concurrent.ThreadPoolExecutor$Worker.run(Unknown Source) at java.base/java.lang.Thread.run(Unknown Source) Reason: Not comparable objects: BigInteger 350930 and Integer 350930 Resolution: Please address the reported issue. Error Fingerprint[0] = efp:com.snaplogic.snaps.transform.Ix2j0m3w3KViews0likes1CommentNot Comparable Objects: BigInteger 350930 and Integer 350930
I’ve done a join to 5 tables. All works fine in validation. No errors at all. If I use a specific value in the where clause in the 4 SQL Selects, it’ll run fine. If I give it a parameter (instead of a hardcoded value). I get the error “Not Comparable Objects: BigInteger 350930 and Integer 350930”. They’re exactly the same field type in the DB. If I replace $PropertyId with 350930, it’ll work. It’s getting the values, as they’re shown in the error. I’ve tried casting them both to the same time (Integer, Float, and String), and then I get the error that they’re not ascending, if I change to ascending, I get an error saying they’re not descending, etc etc.4.6KViews1like5CommentsGroup by to one object
Hi Everyone, I have a group by field that’s working as expected. What I need to do next is iterate through the rows combing them into one document. For example. Customer 1 2 3 Orders Customer Order Item 1 1 Dog 2 2 Cat 1 3 Fish Customer Orders 1 Dog 3 Fish1.5KViews0likes1CommentRe: Sub Query Comparing two lists
Thank you for the suggestion. I went with the outer join, and it’s worked. Is it possible to skip a row in the mapper? I did an expression to say if Case = null, then set Customer to null, else give me the customer ID. But now I’ve got a list of nulls, with the customer id’s scattered through out. Is it possible to say if the incoming field doesnt contain a certain value, then dont map at all?3.3KViews0likes0CommentsCRM SnapPack In vs EQ
Hi Everyone, I’m building up a CRM Search, but I need to use IN as opposed to EQ. It doesnt matter how I enter the values when using IN, I get an error saying the IN condition doesnt contain any values. I’ve tried strings and Ints, I’ve also tried using FetchXML (xxxx<\value>). How do you use the IN condition?1.2KViews0likes0Comments