BC Observatoryunofficial, made by waldo
community postIntegration & APIscommunity - not Microsoftreviewed - checked by Opus

Using Power Automate for Business Central SFTP

Shows an alternative to native SFTP in Business Central: a custom table with a BLOB field, list and card pages, and an API page keyed on SystemId. A Power Automate flow reads a file from an SFTP server, creates a record through the API, then uploads the file content to the BLOB so it can be parsed in Business Central. The reverse direction, pushing files to SFTP, can be triggered with Business Events.

Open in Claude3631.md

post Aardvark Labs

Marcel Chabot · 2026-06-19 · 1,040 words · about 5 min

"For this example, we are going to use Power Automate."
Show the post hereRead on Aardvark Labs

Key points

  • Create a table with BLOB field to store file content and supporting pages for UI management
  • Build an API page with System ID and ODataKeyFields to enable Power Automate to interact with the table
  • Use Power Automate to retrieve SFTP files and post them to Business Central via the API in two steps: create record then upload file content
  • The approach also works in reverse to push Business Central documents to SFTP servers using Business Events
  • Downloaded files can be processed by existing delimited data parsers within Business Central

Quotes

  • “For this example, we are going to use Power Automate.” (Establishes Power Automate as the external service for handling SFTP communication outside Business Central’s AL code space)

AL objects mentioned

As named in the post. A name that matches one object page by exact type and name links to it; the others stay as named.

  • table “ARD_PA_FTPPush”
  • page “ARD_FTPPushAPI”
  • page “ARD_FTPFiles”
  • page “ARD_FTP File Card”

Not found in BC28-30: table “ARD_PA_FTPPush”, page “ARD_FTPPushAPI”, page “ARD_FTPFiles”, page “ARD_FTP File Card”.

Context

  • Features: Power Automate integration, SFTP file retrieval, BLOB file storage, Custom API pages, File processing automation, Business Event triggers

Source: Aardvark Labs, community blog. Summary, key points and quotes are derived (CONTENT-NOTICE.md); read the original for the full text.