Custom Connector Functions Overview

Power Query exposes specific functions when developing Custom Connectors in Visual studio. You can find an overview of these below.

Custom Connector Functions

Function	Description	Input	Output
DataSource.TestConnection	Returns whether a connection to a datasource can be established and credentials are correct.	Any	Logical
Error.Unexpected		Text	Record
OpenApi.Document	Returns a table of operations from an Open API definition.	Binary	Any
SqlView.Generator	This function is intended for internal use only.	Any	Function

Action Functions

Function	Description	Input	Output
Action.DoNothing	An action that performs no action when executed and returns null as its result.	Any	Any
Action.Return	Creates an action that performs no action when executed and returns the specified value as its result.	Any	Any
Action.Sequence	Creates an action that executes a sequence of actions in order.	List	Any
Action.Try	Creates an action that executes the specified action, catching and returning any errors that occur during its execution.	Any	Any
Action.View	Creates or extends an action with user-defined handlers for query and action operations.	Any	Any
Action.ViewError	Creates a modified error record which won’t trigger a fallback when thrown by a handler defined on a view (via Action.View).	Record	Record
Action.ViewFunction	Creates a function that can be intercepted by a handler defined on a view (via Binary.View).	Function	Function

Connector – Crypto

Function	Description	Input	Output
Crypto.CreateHash		Number	Binary
Crypto.CreateHmac		Number	Binary

Enviroment Functions

Function	Description	Input	Output
Environment.Configuration	Returns the value of all configuration properties set in the current environment.	Record	Record
Environment.FeatureSwitch	Returns the value of a configuration property set in the current environment.	Text	Any
Environment.Libraries	Returns a table of libraries that are available in the current environment.	Record	Table

Extension Functions

Function	Description	Input	Output
Extension.Cache		Record	Record
Extension.Contents		Text	Binary
Extension.CredentialError		Text	Record
Extension.CurrentApplication		Record	Record
Extension.CurrentCredential		Logical	Record
Extension.HasPermission		Record	Logical
Extension.InvokeVolatileFunction		Function	Any
Extension.InvokeWithCredentials		Function	Any
Extension.InvokeWithPermissions		Function	Any
Extension.LoadString		Text	Text
Extension.Module		Text	Any
Extension.State		Table	Table

External Integrations

Function	Description	Input	Output
Delta.Since		Table	Table

Table Action Functions

Function	Description	Input	Output
TableAction.DeleteRows	Creates an action to delete rows from a table.	Table	Any
TableAction.InsertRows	Creates an action to insert rows into a table.	Table	Any
TableAction.Tee	Creates an action that executes multiple actions concurrently while reading data from a table.	Table	Any
TableAction.UpdateRows	Creates an action to update rows in a table.	Table	Any

Value Action Functions

Function	Description	Input	Output
ValueAction.BeginTransaction		Record	Any
ValueAction.CommitTransaction		Record	Any
ValueAction.NativeStatement	Creates an action to execute a statement against a target.	Any	Any
ValueAction.Replace	Creates an action that replaces the content of a value with the specified value.	Any	Any

Web Functions

Function	Description	Input	Output
Web.DefaultProxy		Text	Record
Web.SignForOAuth1		Text	Binary

Last update: December 23, 2024 | Contribute » | Contributors: Rick de Groot
© 2024 BI Gorilla. All rights reserved. Content derived from Microsoft documentation is property of Microsoft Corp.