How does one use a variable in a webapi filter?

(0) Share

Report

Posted on by Community Member

Error message: Syntax error at position 22 in 'msdyn_name eq CA-90028'.

Script:

        if (formContext.getAttribute("shipto_postalcode").getValue() && formContext.getAttribute("shipto_stateorprovince").getValue()) {
            var taxGroupName = formContext.getAttribute("shipto_stateorprovince").getValue()   "-"   formContext.getAttribute("shipto_postalcode").getValue();
            alert(taxGroupName);

            Xrm.WebApi.retrieveMultipleRecords("msdyn_taxgroup", "?$select=msdyn_name&$filter=msdyn_name eq "   taxGroupName).then(

or am I making some simpler syntax error?

TIA

I have the same question (0)

All responses (5)

Answers (1)

Sort by

Verified answer

Community Member on at

Like (1)

Report
Copy link

Link copied!

Try single quotes around the taxGroupName

Go to:

-assuming your version is 9.1, change as needed.

YOURCRMBASEURL.com/.../msdyn_taxgroups eq 'CA-90028'

What comes back?

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report
Copy link

Link copied!

Now, unfortunately I have to figure out a way to have it fire before the order save (double saving required.)

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report
Copy link

Link copied!

So what is needed to happen and why a double save? Maybe I can help get it down to 1.

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report
Copy link

Link copied!
I have placed shipto_name/_stateorprovince/_postalcode fields to the address form and added this method to their onChange events. Of course, add/change addresses run through an mscrm method attached to the lookup address button/dialog.

I change the address and can see fields change but the method does not fire until I save; and I have no place to script ".fireOnChange()".

Hence it saves and comes back dirty.

ps- for all the kids out there:
Xrm.WebApi.retrieveMultipleRecords("msdyn_taxgroup", "?$select=msdyn_name&$filter=msdyn_name eq '" taxGroupName "'").then(

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report
Copy link

Link copied!

I think there is a way by modifying the ribbon to move the mscrm function from the button to the javascript and replace the command on the button but, I'm hoping there is a more easily maintainable solution.

Was this reply helpful? Yes No

Join the conversation

Community site session details

How does one use a variable in a webapi filter?

Helpful resources

News and Announcements

Quick Links

Season of Sharing Community Challenge Winners!

Women in Power Builds Momentum

Congratulations to the July Top 10 Community Leaders

Leaderboard > Customer experience | Sales, Customer Insights, CRM

Featured topics

Product updates

Community site session details

How does one use a variable in a webapi filter?

Helpful resources

News and Announcements

Quick Links

Season of Sharing Community Challenge Winners!

Women in Power Builds Momentum

Congratulations to the July Top 10 Community Leaders

Subscribe to this forum!

Select categories

Leaderboard > Customer experience | Sales, Customer Insights, CRM

Featured topics

Product updates