Use the fwConfig resource to configure column widths for flat file source, lookup, and target objects.
GET request
To request all of the fixed-width formats, use the following URI:
/api/v2/fwConfig
To request the details of a particular fixed-width format, you can include the fixed-width format ID, the fixed-width federated ID, or fixed-width format name in the URI. If you include the federated ID, the response includes the project and folder location of the fixed-width format. Use one of the following URIs:
/api/v2/fwConfig/<id>
/api/v2/fwConfig/frs/<id>
/api/v2/fwConfig/name/<name>
If you use the fixed-width format name in the URI and the fixed-width format name includes a space, replace the space with %20. For example:
/api/v2/fwConfig/name/my%20fixedwidth%20format
GET response
The fwConfig object returns the following attributes:
Field
Type
Description
id
String
Fixed-width format ID.
name
String
Fixed-width format name.
description
String
Description of the fixed-width format.
createTime
Date/time
Time that the fixed-width format was created.
updateTime
Date/time
Last time that the fixed-width format was updated.
createdBy
String
User who created the fixed-width format.
updatedBy
String
User who last updated the fixed-width format.
lineSequential
Boolean
Whether each row ends with a newline character.
- True. Line sequential is enabled.
- False. Line sequential is not enabled.
padBytes
Int
Number of bytes between the last column of one row and the first column of the next.
skipRows
Int
Number of rows to skip. You can skip blank or header rows.
nullChar
String
The character to represent a null value.
dateFormat
String
Default date format to use when a date format is not specified in the flat file connection.
nullCharType
String
Determines if the null character is single-byte or multibyte.
repeatNullChar
Boolean
Determines how to treat null characters in a single field.
- True. Read repeat null characters as a single null value.
- False. does not read repeat null characters as a single null value.
stripTrailingBlank
Boolean
Determines how to treat trailing blanks in string values.
- True. Removes trailing blanks from string values.
- False. Does not remove trailing blanks in string values.
location
String
The project and folder that the fixedd-width file resides in.
columns
String
Includes the following attributes for each column:
- name. Name of the column.
- nativeType. Native data type.
- precision. Length of the field in bytes.
- scale. Number of digits after the decimal point for numeric values.
GET example
The following example shows a request to get details for a fixed-width format using the fixed-width format ID:
GET <serverUrl>/api/v2/fwConfig/00001R29000000000002 Accept:application/json icSessionId: <icSessionId>
To create a fixed-width format, use the following URI:
/api/v2/fwConfig
If you want to specify a location for the fixed-width format, include the container ID in the request. If the container ID isn't included in the request, the fixed-width format is created in the Default folder. You can find the container ID for a project or folder in the Data Integration user interface. On the Explore page, select the folder. In the URL, the last string of characters is the container ID.
For example, in the following URL, the container ID is dH2DuGJYda7ijgW4Sm32sR
To update a fixed-width format, include the fixed-width format ID in the following URI:
/api/v2/fwConfig/<id>
You can submit a partial update using partial mode. If you want to update a field in the fwColumn object using partial mode, you must include the name. To submit a request using partial mode, use a JSON request and include the following line in the header:
Update-Mode=PARTIAL
You can use the following attributes in a fwConfig POST request:
Field
Type
Required
Description
id
String
Yes
Fixed-width format ID.
name
String
Yes
Fixed-width format name.
description
String
Description of the fixed-width format.
containerId
String
ID of the project or folder to contain the linear taskflow.
If not included in request, the linear taskflow is created in the Default folder.
lineSequential
Boolean
Yes
Whether each row ends with a newline character.
- True. Line sequential is enabled.
- False. Line sequential is not enabled.
padBytes
Int
Yes
Number of bytes between the last column of one row and the first column of the next.
skipRows
Int
Yes
Number of rows to skip. You can skip blank or header rows.
nullChar
String
Yes
The character to represent a null value.
dateFormat
String
Yes
Default date format to use when a date format is not specified in the flat file connection.
nullCharType
String
Yes
Determines if the null character is single-byte or multibyte.
repeatNullChar
Boolean
Yes
Determines how to treat null characters in a single field.
- True. Read repeat null characters as a single null value.
- False. does not read repeat null characters as a single null value.
stripTrailingBlank
Boolean
Yes
Determines how to treat trailing blanks in string values.
- True. Removes trailing blanks from string values.
- False. Does not remove trailing blanks in string values.
columns
String
Yes
Includes the following attributes for each column:
- name. Name of the column.
- nativeType. Native data type.
- precision. Length of the field in bytes.
- scale. Number of digits after the decimal point for numeric values.
POST response
If successful, returns the fwConfig object that you created or updated. Returns the error object if errors occur.