Table of Contents

Connections

Commands

Connections

BlackLine OAuth2

The BlackLine connection that authenticates via OAuth2. You will need an integration in user with integration permissions, as well as the proper scopes and roles.

Inputs

Input

Type

Detail

Notes

Username

TextField

The username of the integration user.

Password

TextField

The password given to you when the integration account was created (NOTE: This is not the same password as when logging in to your BlackLine instance via the web.)

Client ID

TextField

The Client ID for the integration user.

Client Secret

TextField

The Client Secret of the integration user.

Scopes

TextField

The scopes that you this connection will have and that have been enabled for the integration user.

Instance Host Name

TextField

The host name of your BlackLine instance. Do not include the https://. An example is (sbus2.api.blackline.com) which is the default and a development environment.

API Version

DropdownField

The API version. If you are unsure please contact Blackline support to find out which version your credentials are for.

Commands

Account Settings

Imports data in a CSV file to BlackLine. Based on the import type, a different data structure is required. The BizApp handles this for you, but the format should map to the BlackLine Import Templates

Inputs

Input

Type

Detail

Notes

Delimiter

TextField

The delimiter of the CSV file.

CSV Data Source

FileField

The CSV file that contains the data for the Account Settings import.

Column Mappings

GroupField

This import requires a specific column order, as prescribed in the BlackLine Import Template. If the CSV has the same header names as the import, this is unnecessary. If the CSV file has different header names than the import template, use this group of fields to specify which columns in the CSV map to the columns in the import template. (e.g. ID --> Entity Unique Identifier)

Outputs

Output

Output Type

Notes

Import

Json

Exit Codes

Code

Type

Detail

0

Success

Success

1

Error

There was an error with the import

3

Error

Could not retrieve the status of the import

Accounts

Imports data in a CSV file to BlackLine. Based on the import type, a different data structure is required. The BizApp handles this for you, but the format should map to the BlackLine Import Templates

Inputs

Input

Type

Detail

Notes

Delimiter

TextField

The delimiter of the CSV file.

CSV Data Source

FileField

The CSV file that contains the data for the Accounts import.

Column Mappings

GroupField

This import requires a specific column order, as prescribed in the BlackLine Import Template. If the CSV has the same header names as the import, this is unnecessary. If the CSV file has different header names than the import template, use this group of fields to specify which columns in the CSV map to the columns in the import template. (e.g. ID --> Entity Unique Identifier)

Outputs

Output

Output Type

Notes

Import

Json

Exit Codes

Code

Type

Detail

0

Success

Success

1

Error

There was an error with the import

3

Error

Could not retrieve the status of the import

Bank Balances

Imports data in a CSV file to BlackLine. Based on the import type, a different data structure is required. The BizApp handles this for you, but the format should map to the BlackLine Import Templates

Inputs

Input

Type

Detail

Notes

Delimiter

TextField

The delimiter of the CSV file.

CSV Data Source

FileField

The CSV file that contains the data for the Bank Balances import.

Column Mappings

GroupField

This import requires a specific column order, as prescribed in the BlackLine Import Template. If the CSV has the same header names as the import, this is unnecessary. If the CSV file has different header names than the import template, use this group of fields to specify which columns in the CSV map to the columns in the import template. (e.g. ID --> Entity Unique Identifier)

Outputs

Output

Output Type

Notes

Import

Json

Exit Codes

Code

Type

Detail

0

Success

Success

1

Error

There was an error with the import

3

Error

Could not retrieve the status of the import

Currency Rates

Imports data in a CSV file to BlackLine. Based on the import type, a different data structure is required. The BizApp handles this for you, but the format should map to the BlackLine Import Templates

Inputs

Input

Type

Detail

Notes

Delimiter

TextField

The delimiter of the CSV file.

CSV Data Source

FileField

The CSV file that contains the data for the Currency Rates import.

Column Mappings

GroupField

This import requires a specific column order, as prescribed in the BlackLine Import Template. If the CSV has the same header names as the import, this is unnecessary. If the CSV file has different header names than the import template, use this group of fields to specify which columns in the CSV map to the columns in the import template. (e.g. ID --> Entity Unique Identifier)

Outputs

Output

Output Type

Notes

Import

Json

Exit Codes

Code

Type

Detail

0

Success

Success

1

Error

There was an error with the import

3

Error

Could not retrieve the status of the import

Download Report

List the available reports for download.

Inputs

Input

Type

Detail

Notes

Report ID/Name

TextField

The ID or name of the report run. If you specify the name, this will download the most recent run of the report.

Format

DropdownField

The format of the report.

Outputs

Output

Output Type

Notes

Report

File

Exit Codes

Code

Type

Detail

0

Success

Success

1

Error

There was an error

Entities

Imports data in a CSV file to BlackLine. Based on the import type, a different data structure is required. The BizApp handles this for you, but the format should map to the BlackLine Import Templates

Inputs

Input

Type

Detail

Notes

Delimiter

TextField

The delimiter of the CSV file.

CSV Data Source

FileField

The CSV file that contains the data for the Entities import.

Column Mappings

GroupField

This import requires a specific column order, as prescribed in the BlackLine Import Template. If the CSV has the same header names as the import, this is unnecessary. If the CSV file has different header names than the import template, use this group of fields to specify which columns in the CSV map to the columns in the import template. (e.g. ID --> Entity Unique Identifier)

Outputs

Output

Output Type

Notes

Import

Json

Exit Codes

Code

Type

Detail

0

Success

Success

1

Error

There was an error with the import

3

Error

Could not retrieve the status of the import

Entity Types

Imports data in a CSV file to BlackLine. Based on the import type, a different data structure is required. The BizApp handles this for you, but the format should map to the BlackLine Import Templates

Inputs

Input

Type

Detail

Notes

Delimiter

TextField

The delimiter of the CSV file.

CSV Data Source

FileField

The CSV file that contains the data for the Entity Types import.

Column Mappings

GroupField

This import requires a specific column order, as prescribed in the BlackLine Import Template. If the CSV has the same header names as the import, this is unnecessary. If the CSV file has different header names than the import template, use this group of fields to specify which columns in the CSV map to the columns in the import template. (e.g. ID --> Entity Unique Identifier)

Outputs

Output

Output Type

Notes

Import

Json

Exit Codes

Code

Type

Detail

0

Success

Success

1

Error

There was an error with the import

3

Error

Could not retrieve the status of the import

Get Import Errors

Retrieve a list of the errors that occurred during an import.

Inputs

Input

Type

Detail

Notes

Import ID

TextField

The import ID.

Outputs

Output

Output Type

Notes

Error Details

Array

Total Errors

Integer

Exit Codes

Code

Type

Detail

0

Success

Success

1

Error

There was an error

3

Error

Could not retrieve the status of the import

Import Data

Queue an import in BlackLine to be run on the next schedule date/time

Inputs

Input

Type

Detail

Notes

Import ID

TextField

The ID (Import Profile Name) of the import

Format

DropdownField

The format of the input data

Data

FileField

The data to import

Delimiter

DropdownField

The delimiter of the data to import. This only applies if using the CSV data format.

Outputs

Output

Output Type

Notes

Import ID

String

Resource ID

String

Exit Codes

Code

Type

Detail

0

Success

Success

1

Error

There was an error

Items

Imports data in a CSV file to BlackLine. Based on the import type, a different data structure is required. The BizApp handles this for you, but the format should map to the BlackLine Import Templates

Inputs

Input

Type

Detail

Notes

Delimiter

TextField

The delimiter of the CSV file.

CSV Data Source

FileField

The CSV file that contains the data for the Items import.

Column Mappings

GroupField

This import requires a specific column order, as prescribed in the BlackLine Import Template. If the CSV has the same header names as the import, this is unnecessary. If the CSV file has different header names than the import template, use this group of fields to specify which columns in the CSV map to the columns in the import template. (e.g. ID --> Entity Unique Identifier)

Outputs

Output

Output Type

Notes

Import

Json

Exit Codes

Code

Type

Detail

0

Success

Success

1

Error

There was an error with the import

3

Error

Could not retrieve the status of the import

List Reports

List the available reports for download.

Inputs

None

Outputs

Output

Output Type

Notes

Reports

Json

Exit Codes

Code

Type

Detail

0

Success

Success

1

Error

There was an error

Multi-Currency Balances

Imports data in a CSV file to BlackLine. Based on the import type, a different data structure is required. The BizApp handles this for you, but the format should map to the BlackLine Import Templates

Inputs

Input

Type

Detail

Notes

Delimiter

TextField

The delimiter of the CSV file.

CSV Data Source

FileField

The CSV file that contains the data for the Multi-Currency Balances import.

Column Mappings

GroupField

This import requires a specific column order, as prescribed in the BlackLine Import Template. If the CSV has the same header names as the import, this is unnecessary. If the CSV file has different header names than the import template, use this group of fields to specify which columns in the CSV map to the columns in the import template. (e.g. ID --> Entity Unique Identifier)

Outputs

Output

Output Type

Notes

Import

Json

Exit Codes

Code

Type

Detail

0

Success

Success

1

Error

There was an error with the import

3

Error

Could not retrieve the status of the import

Subledgers

Imports data in a CSV file to BlackLine. Based on the import type, a different data structure is required. The BizApp handles this for you, but the format should map to the BlackLine Import Templates

Inputs

Input

Type

Detail

Notes

Delimiter

TextField

The delimiter of the CSV file.

CSV Data Source

FileField

The CSV file that contains the data for the Subledgers import.

Column Mappings

GroupField

This import requires a specific column order, as prescribed in the BlackLine Import Template. If the CSV has the same header names as the import, this is unnecessary. If the CSV file has different header names than the import template, use this group of fields to specify which columns in the CSV map to the columns in the import template. (e.g. ID --> Entity Unique Identifier)

Outputs

Output

Output Type

Notes

Import

Json

Exit Codes

Code

Type

Detail

0

Success

Success

1

Error

There was an error with the import

3

Error

Could not retrieve the status of the import

Task Auto-Certify Completed

Imports data in a CSV file to BlackLine. Based on the import type, a different data structure is required. The BizApp handles this for you, but the format should map to the BlackLine Import Templates

Inputs

Input

Type

Detail

Notes

Delimiter

TextField

The delimiter of the CSV file.

CSV Data Source

FileField

The CSV file that contains the data for the Task Auto-Certify Completed import.

Column Mappings

GroupField

This import requires a specific column order, as prescribed in the BlackLine Import Template. If the CSV has the same header names as the import, this is unnecessary. If the CSV file has different header names than the import template, use this group of fields to specify which columns in the CSV map to the columns in the import template. (e.g. ID --> Entity Unique Identifier)

Outputs

Output

Output Type

Notes

Import

Json

Exit Codes

Code

Type

Detail

0

Success

Success

1

Error

There was an error with the import

3

Error

Could not retrieve the status of the import

Task Dependencies

Imports data in a CSV file to BlackLine. Based on the import type, a different data structure is required. The BizApp handles this for you, but the format should map to the BlackLine Import Templates

Inputs

Input

Type

Detail

Notes

Delimiter

TextField

The delimiter of the CSV file.

CSV Data Source

FileField

The CSV file that contains the data for the Task Dependencies import.

Column Mappings

GroupField

This import requires a specific column order, as prescribed in the BlackLine Import Template. If the CSV has the same header names as the import, this is unnecessary. If the CSV file has different header names than the import template, use this group of fields to specify which columns in the CSV map to the columns in the import template. (e.g. ID --> Entity Unique Identifier)

Outputs

Output

Output Type

Notes

Import

Json

Exit Codes

Code

Type

Detail

0

Success

Success

1

Error

There was an error with the import

3

Error

Could not retrieve the status of the import

Tasks

Imports data in a CSV file to BlackLine. Based on the import type, a different data structure is required. The BizApp handles this for you, but the format should map to the BlackLine Import Templates

Inputs

Input

Type

Detail

Notes

Delimiter

TextField

The delimiter of the CSV file.

CSV Data Source

FileField

The CSV file that contains the data for the Tasks import.

Column Mappings

GroupField

This import requires a specific column order, as prescribed in the BlackLine Import Template. If the CSV has the same header names as the import, this is unnecessary. If the CSV file has different header names than the import template, use this group of fields to specify which columns in the CSV map to the columns in the import template. (e.g. ID --> Entity Unique Identifier)

Outputs

Output

Output Type

Notes

Import

Json

Exit Codes

Code

Type

Detail

0

Success

Success

1

Error

There was an error with the import

3

Error

Could not retrieve the status of the import

User Account Assignments

Imports data in a CSV file to BlackLine. Based on the import type, a different data structure is required. The BizApp handles this for you, but the format should map to the BlackLine Import Templates

Inputs

Input

Type

Detail

Notes

Delimiter

TextField

The delimiter of the CSV file.

CSV Data Source

FileField

The CSV file that contains the data for the User Account Assignments import.

Column Mappings

GroupField

This import requires a specific column order, as prescribed in the BlackLine Import Template. If the CSV has the same header names as the import, this is unnecessary. If the CSV file has different header names than the import template, use this group of fields to specify which columns in the CSV map to the columns in the import template. (e.g. ID --> Entity Unique Identifier)

Outputs

Output

Output Type

Notes

Import

Json

Exit Codes

Code

Type

Detail

0

Success

Success

1

Error

There was an error with the import

3

Error

Could not retrieve the status of the import

User Entities

Imports data in a CSV file to BlackLine. Based on the import type, a different data structure is required. The BizApp handles this for you, but the format should map to the BlackLine Import Templates

Inputs

Input

Type

Detail

Notes

Delimiter

TextField

The delimiter of the CSV file.

CSV Data Source

FileField

The CSV file that contains the data for the User Entities import.

Column Mappings

GroupField

This import requires a specific column order, as prescribed in the BlackLine Import Template. If the CSV has the same header names as the import, this is unnecessary. If the CSV file has different header names than the import template, use this group of fields to specify which columns in the CSV map to the columns in the import template. (e.g. ID --> Entity Unique Identifier)

Outputs

Output

Output Type

Notes

Import

Json

Exit Codes

Code

Type

Detail

0

Success

Success

1

Error

There was an error with the import

3

Error

Could not retrieve the status of the import

User Roles

Imports data in a CSV file to BlackLine. Based on the import type, a different data structure is required. The BizApp handles this for you, but the format should map to the BlackLine Import Templates

Inputs

Input

Type

Detail

Notes

Delimiter

TextField

The delimiter of the CSV file.

CSV Data Source

FileField

The CSV file that contains the data for the User Roles import.

Column Mappings

GroupField

This import requires a specific column order, as prescribed in the BlackLine Import Template. If the CSV has the same header names as the import, this is unnecessary. If the CSV file has different header names than the import template, use this group of fields to specify which columns in the CSV map to the columns in the import template. (e.g. ID --> Entity Unique Identifier)

Outputs

Output

Output Type

Notes

Import

Json

Exit Codes

Code

Type

Detail

0

Success

Success

1

Error

There was an error with the import

3

Error

Could not retrieve the status of the import

Users

Imports data in a CSV file to BlackLine. Based on the import type, a different data structure is required. The BizApp handles this for you, but the format should map to the BlackLine Import Templates

Inputs

Input

Type

Detail

Notes

Delimiter

TextField

The delimiter of the CSV file.

CSV Data Source

FileField

The CSV file that contains the data for the Users import.

Column Mappings

GroupField

This import requires a specific column order, as prescribed in the BlackLine Import Template. If the CSV has the same header names as the import, this is unnecessary. If the CSV file has different header names than the import template, use this group of fields to specify which columns in the CSV map to the columns in the import template. (e.g. ID --> Entity Unique Identifier)

Outputs

Output

Output Type

Notes

Import

Json

Exit Codes

Code

Type

Detail

0

Success

Success

1

Error

There was an error with the import

3

Error

Could not retrieve the status of the import

Did this answer your question?