Help Desk

Submit a ticket My Tickets
Welcome
Login

BlackLine Command Reference

The Blackline BizApp allows users to perform data imports, data exports, and general automation within your BlackLine instance.

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.

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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
B
Brian is the author of this solution article.

Did you find it helpful? Yes No

Send feedback
Sorry we couldn't be helpful. Help us improve this article with your feedback.