Excel Add-In for REST

Build 25.0.9434

Operations

The add-in has high-performance operations for processing XML data sources. These operations are platform neutral: Schema files that invoke these operations can be used in both .NET and Java. You can also extend the add-in with your own operations written in .NET or Java.

The add-in has the following operations:

Operation NameDescription
jsonproviderGetThe jsonproviderGet operation is an APIScript operation that is used to process JSON content. It allows you to split JSON content into rows.
xmlproviderGetThe xmlproviderGet operation is an APIScript operation that is used to process XML content. It allows you to split XML content into rows.
csvproviderGetThe csvproviderGet operation is an APIScript operation that is used to process CSV content.
oauthGetAccessTokenFor OAuth 1.0, exchange a request token for an access token. For OAuth 2.0, get an access token or get a new access token with the refresh token.
oauthGetUserAuthorizationURLGenerates the user authorization URL. OAuth 2.0 will not access the network in this operation.
utiladoSleepSuspends processes for a specified duration (in seconds).
utiladoPushPageTokenPushes a page token value to rows@next without pushing a row to the result set.
httpopsGetThe httpopsGet operation is an APIScript operation that is used to send an HTTP GET request.
httpopsPostThe httpopsPost operation is an APIScript operation that is used to send an HTTP POST request.
fileReadThe fileRead operation reads the content of the specified file as a feed of individual lines.
fileWriteThe fileWrite operation writes specified content to a specified file.

Copyright (c) 2025 CData Software, Inc. - All rights reserved.
Build 25.0.9434