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](http://docs.microsoft.com/en-us/dynamics365/customer-engagement/developer/webapi/query-data-web-api)