Dynamics 365 Quick way to get a record's guid, and what the source data looks like
Often when testing and generating reports it's useful to get the guid of a record. There are lots of ways but the quickest and most reliable is to use the following URL structure calling the dynamics api.
https://servername/organisationname/api/data/v8.2/entitynameplural?$orderby=fieldname&$select=fieldname&$filter=contains(fieldname,'Clayton')
Server name and Organisation name
If on premise https://vs123/prod
if online then https://prod.crm11.dynamics.com
V8.2
Can be v8.2 or v9.0 depending on version
Entitynameplural
Name of entity with an s on the end of
$Orderby
Order of the data
Fieldname
name of field
Select
Fields you want to return if not set all fields are returned
Filter
Example could be contains(Fieldname,'Value')
Example 1
https://bsmt.crm4.dynamics.com/api/data/v9.0/bsmt_invoiceitems?$orderby=bsmt_name&$select=bsmt_name
Other Examples
https://bsmt.crm4.dynamics.com/api/data/v9.0/bsmt_invoiceitems?$orderby=bsmt_name&$select=bsmt_name,bsmt_externalemployee&$filter=contains(bsmt_name,'Clayton')
Microsoft Reference
https://docs.microsoft.com/en-us/dynamics365/customer-engagement/developer/webapi/query-data-web-api
