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)

Verified answer

Community Member on at

Like (1)

Report

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

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

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
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

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

Quick Links

Responsible AI policies

Neeraj Kumar – Community Spotlight

Congratulations to the November 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

Quick Links

Responsible AI policies

Neeraj Kumar – Community Spotlight

Congratulations to the November Top 10 Community Leaders!

Subscribe to this forum!

Select categories

Leaderboard > Customer experience | Sales, Customer Insights, CRM

Featured topics

Product updates