Searchable quick reference with copy-paste examples in HTTP, C#, JavaScript, and PowerShell.
25 results
Insert a new record with different attribute types: string, number, lookup, choice, boolean, and date.
Create a record if it doesn't exist, or update it if it does. Requires an alternate key on the table.
Get a record by its ID with specific columns.
Get a list of records with filtering, sorting, and paging.
Retrieve a record and include related records in the same request.
Quick reference for OData filter syntax.
Get the total count of records in a table.
Update specific fields on an existing record. Only include the fields you want to change.
Remove a lookup association (set it to null).
Permanently delete a record by ID.
Execute a FetchXML query via the Web API.
Run aggregate queries to get totals, counts, and averages.
Join related tables in a FetchXML query.
Send multiple operations in a single HTTP request to reduce round trips.
Group write operations into an atomic transaction. All succeed or all fail.
Get the current user's ID, business unit, and organization.
Change a record's statecode and statuscode.
Change ownership of a record.
Invoke a bound or unbound custom action defined in your solution.
Create a many-to-many relationship between two records.
Remove a many-to-many relationship between two records.
Get all records related through a navigation property.
Retrieve metadata for a specific table.
Retrieve metadata for all columns on a table.
Retrieve the label and value pairs for a choice column.