OneByte: Outbound Integration: Exporting Data from D365 F&O with Recurring Batch APIs – Part 3 | OnActuate
 In A-CRM, A-How To, Microsoft Dynamics 365

Welcome to Part 3 of our Microsoft Dynamics 365 Finance & Operations Integration Series. 

After covering how to bring data into D365 through inbound integrations, we’re now focusing on the outbound side – where D365 acts as the data source, pushing information out to external systems on a recurring schedule. 

In this guide, you’ll learn how to configure Recurring Batch APIs (Application Programming Interface) to export data efficiently and reliably. Whether you’re syncing to a data warehouse, third-party application, or reporting system, outbound integrations play a crucial role in building a connected, AI-ready ecosystem. 

Let’s get started with automating your data exports from D365 F&O. 

Step 1: Set Up the Outbound Batch Recurring API 

To begin your outbound integration, create an Export Project in D365 F&O. 

  1. Navigate to Data Management > Export
  2. Click + New to create a new export project
  3. Add the “Terms of payment” entity (PaymentTermEntity) to the project

This project will be used to schedule a recurring batch job that automatically exports Data from D365 to external systems. 

Step 2: Configure the Recurring Data Job 

  1. Click on Create recurring data job within the export project
  2. Enter a name for the recurring job (e.g., PaymentTermsOutboundJob) 
  3. Under Setup authorization policy: 
    1. In Application ID, paste the Client ID 
    2. Check the box to Enable the job 
  4. Set the recurrence schedule (e.g., daily, hourly) based on how often you want data to be exported 
  5. Click OK to save and activate the recurring batch job 

Step 3: Set Up the API for Export and Acknowledgement 

To trigger and acknowledge the export job via API, use the following endpoints: 

  1. Export API (Dequeue): https://<base URL>/api/connector/dequeue/<activity ID> 
  2. Acknowledgement API: https://<base URL>/api/connector/ack/<activity ID> 
  3. In Postman, create a new request 
    1. Set the method to GET 
    2. Name the request “Payment Terms” 
    3. Replace <base URL> and <activity ID> with your actual environment values 
    4. This API call retrieves the exported data and sends an acknowledgment once processed. 

Step 4: Add Required Headers 

  1. In your Postman request, configure the necessary headers to authenticate and communicate with the D365 F&O API. 
  2. Headers to Add: 
    1. Authorization 
    2. Content Type  
  3. The Authorization header allows access using your bearer token, while the Content-Type ensures the request is formatted correctly for the API. 

Step 5: Send the Request and Review the Response 

  1. Click the Send button in Postman to execute the export API request 
  2. If successful, the response will return the exported data payload along with a Message ID 

This response confirms that the data has been successfully dequeued from D365 F&O and is ready for processing or storage on the external system. Make sure to store the Message ID – it will be used for tracking and acknowledgment. 

Step 6: Download the Exported Data 

  1. In Postman, add a new request 
  2. Name the request “Download PaymentTerms” 
  3. From the previous API response, copy the DownloadLocation URL 
  4. Paste the DownloadLocation into the URL field of your new request
  5. Click the dropdown arrow next to the Send button in Postman, then select “Send and Download” to download the exported file to your system. 
  6. Save the file as filename.zip, replacing filename with your preferred name. 
  7. You’ll receive the data as a ZIP file upon download.
  8. Inside the ZIP file, open the CSV named Terms of payment.
  9. The export process finished successfully.

Step 7: Send Acknowledgement to D365 

After the client downloads the data, an acknowledgement must be sent back to D365 to confirm that the export was received successfully. This ensures the system marks the data as processed and avoids duplicate sending. 

  1. In Postman, add a new request 
  2. Name the request “Acknowledge” 
  3. Set the method to GET  
  4. Use the following URL format:  
    1. URL: {{resource}}/api/connector/ack/{EABBD85F-0572-4E77-988E-FE108C7B5A64}
  5. Be sure to add the following header to the Acknowledgement API request: 
    Content-Type: application/json 
    1. If this header is missing or incorrectly set (e.g., Content-Type: text/csv), the API call will return an error after clicking the Send button. Using the correct content type is essential for successful acknowledgement. 

Step 8: Add Required Headers 

In the Acknowledgement request, add the following headers: 

Key  Value 
Authorization  Bearer {{access_token}} 
Content-Type  application/json 

Note: The Content-Type must be set to application/json for the acknowledgement API to work correctly. 

Step 9: Add the Response Payload to the Request Body 

  1. Go to the Body tab in Postman 
  2. Select raw as the input type 
  3. Ensure the format is set to JSON (from the dropdown) 
  4. Paste the full response you received from the initial Export API (dequeue request) 
    1. This response body is required to acknowledge that the data was successfully received and processed.
  5. Click send 
    1. The response code should be 200.  

Step 10: Verify Acknowledgement Status 

  1. After sending the acknowledgement request, check the response. 
  2. The status should update to: Acknowledged 

This confirms that all steps in the Outbound Recurring Batch API process have been completed successfully. 

Automating Data Exports with Confidence

In this final part of our Dynamics 365 F&O Integration Series, we explored how to configure and run Outbound Integrations using Recurring Batch APIs. From setting up the export project and scheduling the batch job to downloading the exported data and sending acknowledgements, each step helps automate the flow of data from D365 to external systems. 

By streamlining these exports, you not only reduce manual effort but also ensure your external applications are always working with the most up-to-date information – an essential step toward building AI-ready, connected business ecosystems. 

With both Inbound and Outbound integrations in place, your D365 environment is now positioned to support scalable, automated, and intelligent operations across your organization. 

About the expert
Priyansh Gupta, Microsoft Dynamics Technical Consultant, OnActuate 

Priyansh Gupta is a Microsoft Dynamics 365 Finance & Operations Technical Consultant with hands-on experience in platform customization, development, and integration. With a strong focus on streamlining business processes and enhancing user experience, Priyansh brings a practical approach to solving real-world challenges within D365 F&O.  

He holds the MB-500 certification in Dynamics 365 F&O development and is passionate about sharing his technical knowledge through blogging and community engagement. 

The “OneByte” blog series are technical how-to articles by OnActuate’s expert consultants covering software solutions that enhance operational efficiency, such as Microsoft Business Applications (Microsoft Dynamics, Power Platform) and Dayforce. Have a topic you would like to learn more about? Email us at info@onactuate.com! 

Additionally, you can also read…

OneByte: Custom Workspace

Integration Basics & OData API Setup in D365 F&O – Part 1 
How to Install Dev Tools

 Inbound Integration: Pushing Data into D365 F&O with Recurring Batch Jobs – Part 2


How to Optimize D365 OData API Performance Testing with JMeter 

Our website uses cookies to personalize and enhance your experience and improve the delivery of information to you. By clicking "Accept", you agree to our use of cookies. Click “Learn more” to read our Privacy Policy

Simplified Creation/Uploading of Opening Balances for Item-Tracked Inventory