D365 Error · Dynamics 365 WEB API

{Dynamics 365 WEB API} Can’t query date values bug fixed

BIPIN KUMAR

Microsoft Dynamics 365 Web API Limitations

This issue was not actually limitation, just a syntax issue. Don’t use single quotes when specifying a date as value for a filter.

When querying a date property, such as the birthdate of a contact, the following query syntax works.

/contacts?$select=fullname,birthdate&$filter=birthdate eq 1990-01-01

Microsoft Dynamics 365 Web API Limitations

The following syntax will not:

/contacts?$select=fullname,birthdate&$filter=birthdate eq '1990-01-01'

Hope this helps!

One thought on “{Dynamics 365 WEB API} Can’t query date values bug fixed”

  1. Pingback: {Dynamics 365 WEB API} Can’t query date values bug fixed - 365 Community

Leave a Reply

Fill in your details below or click an icon to log in:

Gravatar
WordPress.com Logo

You are commenting using your WordPress.com account. ( Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. ( Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. ( Log Out /  Change )

Cancel

Connecting to %s