Export Query from Sage Business Cloud Accounting

This task will download data from any API resource from your instance of Sage Business Cloud Accounting in an XML format.

Settings

Sage Business Cloud Accounting Connection

Required
The connection to Sage Business Cloud Accounting to use. See Connecting To Sage Business Cloud Accounting if you require more information on how to create/manage connections.

Output File

Required
The file to save the downloaded records to.

Items Per Page

Required
The number records to fetch per request to Sage Business Cloud Accounting. Increasing this value will reduce the number of requests needed to export the records, which may reduce the time taken.

Resource

Required
The resource you would like to return from the Sage Business Cloud Accounting Accounting API.

Root

Required
Enter a name for the root element of the XML in the output file.

Zynk Settings

See Common Task Settings

Example

A sample output file is shown below. This data is from the 'products' resource.

<Root>
  <_x0024_total>3</_x0024_total>
  <_x0024_page>1</_x0024_page>
  <_x0024_next />
  <_x0024_back />
  <_x0024_itemsPerPage>20</_x0024_itemsPerPage>
  <_x0024_items>
    <id>f9ab6c74315d11e691e20a5d7cf84c3e</id>
    <displayed_as>Oasis - Definitely Maybe</displayed_as>
    <_x0024_path>/products/f9ab6c74315d11e691e20a5d7cf84c3e</_x0024_path>
  </_x0024_items>
  <_x0024_items>
    <id>8b940509316711e691e20a5d7cf84c3e</id>
    <displayed_as>Oasis - (What's the story) morning glory?</displayed_as>
    <_x0024_path>/products/8b940509316711e691e20a5d7cf84c3e</_x0024_path>
  </_x0024_items>
  <_x0024_items>
    <id>97a54a32318311e691e20a5d7cf84c3e</id>
    <displayed_as>Oasis - Heathen Chemistry</displayed_as>
    <_x0024_path>/products/97a54a32318311e691e20a5d7cf84c3e</_x0024_path>
  </_x0024_items>
</Root>