Microsoft Dynamics CRM (Archived)

FetchXML - "Expected type of attribute value: System.Guid. Exception raised: Guid should contain 32 digits with 4 dashes (xxxxxxxx-xxxx-xxxx-xxxx-xxxxxxxxxxxx)." Error while using lookup text as input value instead of GUID as input in condition

(0) Share

Report

Posted on by Veer Balla

105

Hi Experts,

I am getting error while using look up text as input value instead of GUID.

And I am getting error

" Expected type of attribute value: System.Guid. Exception raised: Guid should contain 32 digits with 4 dashes (xxxxxxxx-xxxx-xxxx-xxxx-xxxxxxxxxxxx)."

My requirement is to import data from Excel and I am checking if value exists in CRM before creating a record with data from excel as below.

Below is my code:

String query = @"<fetch distinct='true' mapping='logical' output-format='xml-platform' version='1.0'>
<entity name='lead'>
<attribute name='fullname'/>
<attribute name='companyname'/>
<attribute name='telephone1'/>
<attribute name='leadid'/>
<order descending='false' attribute='fullname'/>
<filter type='and'>
<condition attribute='new_projectnameid' operator='eq' value='Aparna Cyberlife'/>
</filter>
</entity>
</fetch>";

EntityCollection results = service.RetrieveMultiple(new FetchExpression(query));

Can you please tell me how to do it...

Thanks.

*This post is locked for comments

I have the same question (0)

All responses (7)

Answers (1)

Rajkumar Rajaraman on at

Like (0)

Report

Veer,

Walkthrough the following blog:

fixitsanta.blogspot.in/.../crm-2011-quick-find-error.html

Hope this helps.

Regards,

R.Rajkumar

"Please mark my answer as verified if you found it helpful"

Was this reply helpful? Yes No
Veer Balla 105 on at

Like (0)

Report

Hi Rajkumar,

Thanks for you reply.

I followed as per your link and in quick find view Project Name lookup (new_projectnameid) is already unchecked

by default as shown below.

It is not checked and I am still getting error.

Any help please...

Thanks.

Was this reply helpful? Yes No
Verified answer

Shantnu Sharma 655 on at

Like (1)

Report

In the condition you have taken the attribute as projectnameid but you are equating it to a string. When a lookup is created, it's value is stored as (in your case) new_projectnameid of type guid and new_projectnameidname as text. Try, new_projectnameidname if it is exposed. You may try this else you will have to provide GUID.

Please let me know for more clarity.

Was this reply helpful? Yes No
Abhishek Gupta 2,003 on at

Like (0)

Report

Hi Veer,

In your fetchXml Aparna Cyberlife is a text that's why you are getting that particular error. Just try to match with Data Types

Was this reply helpful? Yes No
Surmeet Singh 3,075 on at

Like (0)

Report

Hi, the value has to be Guid.

If the you want to query by name the you will have to use query with link entity like this:

Was this reply helpful? Yes No
Veer Balla 105 on at

Like (0)

Report

Hey,

Your solution worked Shantnu.

Thanks mate.

Was this reply helpful? Yes No
Shilpa Pahuja 47 on at

Like (0)

Report

Hi Shantnu,

Have you seen this error-

{ "error": { "code": "0x80040203", "message": "An exception System.FormatException was thrown while trying to convert input value 'rt_accountnumber='0003000722'' to attribute 'rt_account_rt_partner.accountid'. Expected type of attribute value: System.Guid. Exception raised: Guid should contain 32 digits with 4 dashes (xxxxxxxx-xxxx-xxxx-xxxx-xxxxxxxxxxxx).

We are getting this error in Muelsoft, while SAP is pushing this data to dynamics, muelsoft is throwing this error.

Do you know what could be the origin of the issue, looks like exception is from CRM only.

Any help would be appreciated.

Thanks,

Shilap Pahuja

Was this reply helpful? Yes No