Greetings,
I have created a Dataverse table. There is a Choice column called Country which can be either Canada or the United States. I would like to use the Web API to show only records for Canada.
The documentation says to use this function:
GET /api/data/v9.2/cr4fc_schools?$filter=Microsoft.Dynamics.CRM.ContainValues(PropertyName='cr4fc_country',PropertyValues=['197880000']) HTTP/1.1
However, I'm getting an error which says:
I thought that the error meant that the value for Canada (197880000) was wrong, but this value is in fact correct. Does anyone know what this error message means?
Thanks,
Shane.
Solved! Go to Solution.
Hello @CShaneGoodman,
Hope you are doing good, You can try below code
/api/data/v9.1/cr4fc_schools?$filter=cr4fc_country eq '197880000'
Please mark as Answer if it is helpful and provide Kudos
Subscribe : https://www.youtube.com/channel/UCnGNN3hdlKBOr6PXotskNLA
Blog : https://microsoftcrmtechie.blogspot.com
Hello @CShaneGoodman,
Hope you are doing good, You can try below code
/api/data/v9.1/cr4fc_schools?$filter=cr4fc_country eq '197880000'
Please mark as Answer if it is helpful and provide Kudos
Subscribe : https://www.youtube.com/channel/UCnGNN3hdlKBOr6PXotskNLA
Blog : https://microsoftcrmtechie.blogspot.com
A URI can't handle spaces, so I had to encode them. The value is a number, so I had to remove the quotes. The end part now looks like this:
The first Microsoft-sponsored Power Platform Conference is coming in September. 100+ speakers, 150+ sessions, and what's new and next for Power Platform.
Power Platform release plan for the 2022 release wave 2 describes all new features releasing from October 2022 through March 2023.
User | Count |
---|---|
22 | |
5 | |
4 | |
3 | |
3 |
User | Count |
---|---|
23 | |
8 | |
7 | |
6 | |
4 |