Microsoft Dynamics Search for Order by Email

Finds a customer's most recent sales order in Microsoft Dynamics 365 by email address and returns it together with its order lines. Use it in order tracking or returns flows where the customer is identified by email.

What it does

  • Authenticates with Microsoft Dynamics using the provided credentials.
  • Retrieves the most recent sales order matching the email address.
  • Adds the order lines (the individual items on the order) to the result.
  • Reports whether an order was found through the Success flag.

Inputs

NameTypeDescription
EmailStringEmail for searching
ResourceStringMicrosoft Dynamics resource e.g. https://{domain}.operations.dynamics.com
Tenant IDStringMicrosoft Dynamics tenant id
Client IDString (sensitive)Microsoft Dynamics client id
Client SecretString (sensitive)Microsoft Dynamics client secret

Outputs

NameTypeDescription
SuccessBooleanWhether order was found or not
OrderObjectOrder

Notes

  • Only the single most recent order for the email is returned, ordered by creation date.
  • Resource is the base URL of your Dynamics environment, for example https://{domain}.operations.dynamics.com.

API reference