Microsoft Dynamics 365 for Operations Connector

https://HOST_URI/api/services/UserSessionService/AifUserSessionService/ApplyTimeZone

SELECT AddressCity,AddressCounty,SiteId,WarehouseId FROM Customers

<?xml version="1.0" encoding="UTF-8"?>

<mule xmlns:dw="http://www.mulesoft.org/schema/mule/ee/dw" xmlns:json="http://www.mulesoft.org/schema/mule/json" xmlns:http="http://www.mulesoft.org/schema/mule/http" xmlns:tracking="http://www.mulesoft.org/schema/mule/ee/tracking" xmlns:dynamics365foroperations="http://www.mulesoft.org/schema/mule/dynamics365foroperations" xmlns="http://www.mulesoft.org/schema/mule/core" xmlns:doc="http://www.mulesoft.org/schema/mule/documentation"
    xmlns:spring="http://www.springframework.org/schema/beans"
    xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
    xsi:schemaLocation="http://www.springframework.org/schema/beans http://www.springframework.org/schema/beans/spring-beans-current.xsd
http://www.mulesoft.org/schema/mule/core http://www.mulesoft.org/schema/mule/core/current/mule.xsd
http://www.mulesoft.org/schema/mule/http http://www.mulesoft.org/schema/mule/http/current/mule-http.xsd
http://www.mulesoft.org/schema/mule/ee/tracking http://www.mulesoft.org/schema/mule/ee/tracking/current/mule-tracking-ee.xsd
http://www.mulesoft.org/schema/mule/dynamics365foroperations http://www.mulesoft.org/schema/mule/dynamics365foroperations/current/mule-dynamics365foroperations.xsd
http://www.mulesoft.org/schema/mule/json http://www.mulesoft.org/schema/mule/json/current/mule-json.xsd
http://www.mulesoft.org/schema/mule/ee/dw http://www.mulesoft.org/schema/mule/ee/dw/current/dw.xsd">
    <http:listener-config name="HTTP_Listener_Configuration" host="0.0.0.0" port="8081" doc:name="HTTP Listener Configuration"/>
    <dynamics365foroperations:config-oauth-user-pass name="Microsoft_Dynamics_365_for_Operations__OAuth_2_0_Username_Password" clientId="${dynamics365.clientId}" username="${dynamics365.username}" password="${dynamics365.password}" resource="${dynamics365.resource}" clientSecret="${dynamics365.clientSecret}" tokenRequestEndpoint="${dynamics365.tokenRequestEndpoint}" doc:name="Microsoft Dynamics 365 for Operations: OAuth 2.0 Username-Password"/>
    <flow name="PARSE_DEMO_TEMPLATE">
        <http:listener config-ref="HTTP_Listener_Configuration" path="/" doc:name="HTTP"/>
        <parse-template location="form.html" doc:name="Parse Template"/>
        <set-property propertyName="content-type" value="text/html" encoding="US-ASCII" mimeType="text/html" doc:name="Property"/>
    </flow>
    <flow name="IMPORT_DATA_RECURRING_JOB_DEMO">
        <http:listener config-ref="HTTP_Listener_Configuration" path="/import" doc:name="HTTP"/>
        <logger message="Requested 'Import Data Recurring Job' Operation" level="INFO" doc:name="Logger"/>
        <dynamics365foroperations:import-data-recurring-job config-ref="Microsoft_Dynamics_365_for_Operations__OAuth_2_0_Username_Password" doc:name="Microsoft Dynamics 365 for Operations" activityId="#[message.inboundAttachments.get('activityId')]" entityName="#[message.inboundAttachments.get('entity')]" in-ref="#[message.inboundAttachments.get('file')]"/>
        <logger message="#[message.inboundAttachments.get('activityId')]+ #[message.inboundAttachments.get('entity')]+ #[message.inboundAttachments.get('file')]" level="INFO" doc:name="Logger"/>
    </flow>
    <flow name="RETRIEVE_MULTIPLE_BY_URL">
        <http:listener config-ref="HTTP_Listener_Configuration" path="/retrieveCustomers" doc:name="HTTP"/>
        <logger message="Calling ${dynamics365.resource}/data/Customers" level="INFO" doc:name="Logger"/>
        <dynamics365foroperations:retrieve-multiple config-ref="Microsoft_Dynamics_365_for_Operations__OAuth_2_0_Username_Password" doc:name="Microsoft Dynamics 365 for Operations" dataQueryURL="${dynamics365.resource}/data/Customers"/>
        <logger message="Received Response from 'Retrieve Multiple' Operation" level="INFO" doc:name="Logger"/>
        <json:object-to-json-transformer doc:name="Object to JSON"/>
    </flow>
    <flow name="RETRIEVE_MULTIPLE_BY_DSQL">
        <http:listener config-ref="HTTP_Listener_Configuration" path="/retrieveCustomersByQuery" doc:name="HTTP"/>
        <logger message="Requested 'Retrieve Multiple By DataSense Query Language' Operation" level="INFO" doc:name="Logger"/>
        <dynamics365foroperations:retrieve-multiple-by-query config-ref="Microsoft_Dynamics_365_for_Operations__OAuth_2_0_Username_Password" query="dsql:SELECT AddressCity,AddressCounty,SiteId,WarehouseId FROM Customers" doc:name="Microsoft Dynamics 365 for Operations"/>
        <logger message="Received Response from 'Retrieve Multiple By DataSense Query Language' Operation" level="INFO" doc:name="Logger"/>
        <json:object-to-json-transformer doc:name="Object to JSON"/>
    </flow>
    <flow name="APPLY_TIMEZONE">
        <http:listener config-ref="HTTP_Listener_Configuration" path="/applyTimezone" doc:name="HTTP"/>
        <logger message="Requested 'Apply Timezone' Operation" level="INFO" doc:name="Logger"/>
        <dw:transform-message doc:name="Transform Message">
            <dw:set-payload><![CDATA[%dw 1.0
%output application/java
---
{
    dateTime: payload.dateTime,
    timeZoneOffset: payload.timeZoneOffset
}]]></dw:set-payload>
        </dw:transform-message>
        <dynamics365foroperations:execute-operation config-ref="Microsoft_Dynamics_365_for_Operations__OAuth_2_0_Username_Password" operation="UserSessionService||AifUserSessionService||ApplyTimeZone" doc:name="Microsoft Dynamics 365 for Operations">
            <dynamics365foroperations:parameters ref="#[payload]"/>
        </dynamics365foroperations:execute-operation>
        <logger message="Received Response from 'Apply Timezone' Operation" level="INFO" doc:name="Logger"/>
    </flow>
</mule>