---
id: post/aardvarklabs-blog/3631
type: post
title: Using Power Automate for Business Central SFTP
summary: "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."
tier: community
language: en
tags:
  - sftp
  - power automate
  - file handling
  - api
  - blob storage
  - automation
  - file import
system: integration
review:
  state: reviewed
  by: opus
  at: "2026-10-08T01:54:46.335Z"
  flags: []
generated:
  at: "2026-10-08T01:26:53.141Z"
  pipeline: 0.2.0
  prompts:
    extract-post: 1
  input_hash: dcf75f742cafa4379e164a57d3fe75ff495b69d1867c133d133dc90fdf0248ce
evidence:
  - kind: blog
    url: https://aardvarklabs.blog/2026/06/19/using-power-automate-for-business-central-sftp/
    title: Using Power Automate for Business Central SFTP
    date: "2026-06-19"
    commit: null
    t: null
    quote: null
  - kind: blog
    url: https://aardvarklabs.blog/2026/06/19/using-power-automate-for-business-central-sftp/
    title: Using Power Automate for Business Central SFTP
    date: "2026-06-19"
    commit: null
    t: null
    quote: For this example, we are going to use Power Automate.
links:
  learn: []
  objects: []
  features: []
  topics: []
  localizations: []
  videos: []
  posts: []
  guidelines: []
post_id: "3631"
source_id: aardvarklabs-blog
source_name: Aardvark Labs
url: https://aardvarklabs.blog/2026/06/19/using-power-automate-for-business-central-sftp/
published_at: "2026-06-19T12:00:00.000Z"
author: Marcel Chabot
full_text: false
words: 1040
quotes:
  - text: For this example, we are going to use Power Automate.
    why_it_matters: Establishes Power Automate as the external service for handling SFTP communication outside Business Central's AL code space
code_objects_mentioned:
  - table ARD_PA_FTPPush
  - page ARD_FTPPushAPI
  - page ARD_FTPFiles
  - page ARD_FTP File Card
systems:
  - integration
  - development
versions_mentioned: []
preview:
  embeddable: true
  frame_url: https://aardvarklabs.blog/2026/06/19/using-power-automate-for-business-central-sftp/embed/
  image: https://i0.wp.com/aardvarklabs.blog/wp-content/uploads/2026/06/copilot_20260609_214659.png?fit=1200%2C800&ssl=1
  image_alt: null
  image_w: 1200
  image_h: 800
  site_name: Aardvark Labs
  favicon: https://aardvarklabs.blog/wp-content/uploads/2024/04/design-1.png?w=32
  probed_at: "2026-10-07T11:50:29.800Z"
---

# Using Power Automate for Business Central SFTP

[Read the post](https://aardvarklabs.blog/2026/06/19/using-power-automate-for-business-central-sftp/) · Aardvark Labs (Marcel Chabot) · 2026-06-19 · 1040 words · tier community · reviewed (checked by Opus)

> 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.

## 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.