You can use Alliant API to Import Transaction data to the Alliant system by sending requests with pages of Transaction data to the Import Transaction endpoints. When all of the Transactions in an Import Transaction Batch have been sent, you use the Submit
parameter to submit the Import Batch Job for processing by the Import Batch Service. When you want to Import Transaction data into the Alliant system, you must first create the Import Transaction Batch using the HTTP POST api/Import/Transactions/Batch endpoint. You can send the first page of Transaction data with the POST endpoint. When the Import Transaction Batch includes only a single page of Transaction data that is included in the POST request, you can create the Import Transaction Batch and submit it for processing in the same request using the Submit
parameter. When the Import Transaction Batch includes multiple pages of Transaction data, you send each page of Transactions and submit the batch for processing using the HTTP PATCH api/Import/Transactions/Batch/{batchId} endpoint after the Import Transaction Batch is created using the HTTP POST endpoint. You can read the data for an Import Transaction Batch using the HTTP GET api/Import/Transactions/Batch/{batchId} endpoint. When you want to clear the Transactions from an Import Transaction Batch, you can use the HTTP POST api/Import/Transactions/Batch/{batchId}/clear.
Create an Import Transaction Batch
When you want to Import Transaction data into the Alliant system, you must first issue this endpoint to create the Import Transaction Batch.
The POST Request Body must include the Import File Name, the page size (the number of Transactions to be submitted per batch), and the total number of Transactions. When a batch of Transaction data is included in the initial POST Request, the POST Request Body also includes a Description for the batch, a page number for the batch, and an array of Transaction data. When the entire batch of Transactions is contained within the POST request, you can use the Submit
parameter to submit the job for processing in the same request. The request response includes the batchId value used to submit subsequent pages of Import Transaction data for the Batch Job.
query Parameters
Request Body schema: application/jsonrequired
Include as much information as possible regarding the Import Transaction Batch
OK
Bad Request
Forbidden
Not Found
Method Not Allowed
Conflict
Unsupported Media Type
Internal Server Error
- Payload
{- "importFileName": "APITransactions",
- "description": "Transaction Import from Alliant API",
- "pageSize": 2,
- "totalTransactions": 2
}
- 201
- 400
- 403
- 404
- 405
- 409
- 415
- 500
{- "result": {
- "batchId": 1,
- "jobQueueGuid": "e29a07ac-4391-4846-9cf6-492fbba5b2dc"
}, - "errors": [ ],
- "warnings": [ ],
- "hasErrors": false,
- "hasWarnings": false
}
Submit Transactions for an Import Transaction Batch
Once the Import Transaction Batch is created using the HTTP POST endpoint, you submit each page of Transactions using this endpoint.
When you are submitting a page of Transaction data, the PATCH Request Body must include the Page Number for the Transactions and an array of Transaction data. When you are submitting the final page of Transactions, you can also include the Submit
parameter to submit the batch for processing.
When you are not submitting a page of Transaction data but only submitting the batch for processing, no Request Body data is required and you must include the Submit
parameter to submit the batch for processing.
Note: You cannot submit pages of Transactions to an Import Transaction Batch that has been cleared. When you clear an Import Transaction Batch, the Transaction data is removed from the Database. However, you must create a new Import Transaction Batch to submit new pages of Transactions.
query Parameters
Request Body schema: application/jsonrequired
Include the Page Number and the Transaction data for the page of Transactions.
Note: The Request Body is required only when submitting a page of Transaction data. When submitting the Import job for processing without a page of Transaction data, no Request Body is required.
OK
Bad Request
Forbidden
Not Found
Method Not Allowed
Conflict
Unsupported Media Type
Internal Server Error
- Payload
{- "pageNumber": 0,
- "transactions": [
- {
- "financialPostDateTime": "2018-01-31",
- "altDateTime": "2019-01-31",
- "startUserDateTime": "2020-01-01",
- "endUserDateTime": "2020-01-31",
- "udkey1Segment": "C Major",
- "udkey2Segment": "IMPORT",
- "udkey3Segment": "CURRENT",
- "udkey4Segment": "REG",
- "udkey5Segment": "USA",
- "udkey6Segment": "T21",
- "udkey7Segment": "GLCV DSP 1",
- "udkey8Segment": "C01",
- "udkey9Segment": "TIER GROUP 1",
- "udkey10Segment": "Unspecified",
- "udkey11Segment": "1",
- "udkey12Segment": "Unspecified",
- "udkey13Segment": "Unspecified",
- "udkey14Segment": "Unspecified",
- "udkey15Segment": "Unspecified",
- "udkey16Segment": "Unspecified",
- "udkey20Segment": "Red",
- "userContact1Segment": "alliant",
- "userContact2Segment": "alma",
- "userContact3Segment": "kelly",
- "userContact4Segment": "tfa",
- "pricePoint": 10.5,
- "altPricePoint": 9.25,
- "user1Rate": 8,
- "user2Rate": 9,
- "user3Rate": 10,
- "amount": 16.75,
- "altAmount": 18.88,
- "quantity": 125.5,
- "altQuantity": 500,
- "xref1": "xref1",
- "xref2": "xref2",
- "xref3": "xref3",
- "xref4": "xref4",
- "xref5": "xref5",
- "xref6": "xref6",
- "xref7": "xref7",
- "xref8": "xref8",
- "xref9": "xref9",
- "xref10": "xref10",
- "xref11": "xref11",
- "xref12": "xref12",
- "xref13": "xref13",
- "xref14": "xref14",
- "xref15": "xref15",
- "xref16": "xref16",
- "xref17": "xref17",
- "xref18": "xref18",
- "xref19": "xref19",
- "xref20": "xref20",
- "xref21": "xref21",
- "xref22": "xref22",
- "xref23": "xref23",
- "xref24": "xref24",
- "xref25": "xref25",
- "xref26": "xref26",
- "xref27": "xref27",
- "userComment": "Comment",
- "altUserComment": "Alternate Comment"
}, - {
- "financialPostDateTime": "2018-01-31",
- "altDateTime": "2019-01-31",
- "startUserDateTime": "2020-01-01",
- "endUserDateTime": "2020-01-31",
- "udkey1Segment": "C Major",
- "udkey2Segment": "IMPORT",
- "udkey3Segment": "CURRENT",
- "udkey4Segment": "REG",
- "udkey5Segment": "USA",
- "udkey6Segment": "T21",
- "udkey7Segment": "GLCV DSP 1",
- "udkey8Segment": "C01",
- "udkey9Segment": "TIER GROUP 1",
- "udkey10Segment": "Unspecified",
- "udkey11Segment": "1",
- "udkey12Segment": "Unspecified",
- "udkey13Segment": "Unspecified",
- "udkey14Segment": "Unspecified",
- "udkey15Segment": "Unspecified",
- "udkey16Segment": "Unspecified",
- "udkey20Segment": "Red",
- "userContact1Segment": "alliant",
- "userContact2Segment": "alma",
- "userContact3Segment": "kelly",
- "userContact4Segment": "tfa",
- "pricePoint": 10.5,
- "altPricePoint": 9.25,
- "user1Rate": 8,
- "user2Rate": 9,
- "user3Rate": 10,
- "amount": 16.75,
- "altAmount": 18.88,
- "quantity": 125.5,
- "altQuantity": 500,
- "xref1": "xref1",
- "xref2": "xref2",
- "xref3": "xref3",
- "xref4": "xref4",
- "xref5": "xref5",
- "xref6": "xref6",
- "xref7": "xref7",
- "xref8": "xref8",
- "xref9": "xref9",
- "xref10": "xref10",
- "xref11": "xref11",
- "xref12": "xref12",
- "xref13": "xref13",
- "xref14": "xref14",
- "xref15": "xref15",
- "xref16": "xref16",
- "xref17": "xref17",
- "xref18": "xref18",
- "xref19": "xref19",
- "xref20": "xref20",
- "xref21": "xref21",
- "xref22": "xref22",
- "xref23": "xref23",
- "xref24": "xref24",
- "xref25": "xref25",
- "xref26": "xref26",
- "xref27": "xref27",
- "userComment": "Comment",
- "altUserComment": "Alternate Comment"
}
]
}
- 200
- 400
- 403
- 404
- 405
- 409
- 415
- 500
{- "result": { },
- "errors": [ ],
- "warnings": [ ],
- "hasErrors": false,
- "hasWarnings": false
}
Read Import Transaction Batch Data
Read the data for an Import Transaction Batch.
query Parameters
OK
Bad Request
Forbidden
Not Found
Method Not Allowed
Conflict
Unsupported Media Type
Internal Server Error
- 200
- 400
- 403
- 404
- 405
- 409
- 415
- 500
{- "result": {
- "importFileName": "transactions",
- "importFileSID": 140,
- "description": "Transaction Import from Alliant API",
- "fileDownloadNumber": null,
- "pageSize": 2,
- "totalTransactions": 2,
- "batchId": 22,
- "pageNumber": 0,
- "receivedTransactions": 2,
- "createdDateTime": "2022-27-25",
- "transactions": [
- {
- "financialPostDateTime": "2018-01-31T00:00:00",
- "altDateTime": "2019-01-31T00:00:00",
- "startUserDateTime": "2020-01-01T00:00:00",
- "endUserDateTime": "2020-01-31T00:00:00",
- "udKey1Segment": "C Major",
- "udKey2Segment": "IMPORT",
- "udKey3Segment": "CURRENT",
- "udKey4Segment": "REG",
- "udKey5Segment": "USA",
- "udKey6Segment": "T21",
- "udKey7Segment": "GLCV DSP 1",
- "udKey8Segment": "C01",
- "udKey9Segment": "TIER GROUP 1",
- "udKey10Segment": "Unspecified",
- "udKey11Segment": "1",
- "udKey12Segment": "Unspecified",
- "udKey13Segment": "Unspecified",
- "udKey14Segment": "Unspecified",
- "udKey15Segment": "Unspecified",
- "udKey16Segment": "Unspecified",
- "udKey20Segment": "Red",
- "userContact1Segment": "alliant",
- "userContact2Segment": "alma",
- "userContact3Segment": "kelly",
- "userContact4Segment": "tfa",
- "pricePoint": 10.5,
- "altPricePoint": 9.25,
- "user1Rate": 8,
- "user2Rate": 9,
- "user3Rate": 10,
- "amount": 16.75,
- "altAmount": 18.88,
- "quantity": 125.5,
- "altQuantity": 500,
- "xRef1": "xref1",
- "xRef2": "xref2",
- "xRef3": "xref3",
- "xRef4": "xref4",
- "xRef5": "xref5",
- "xRef6": "xref6",
- "xRef7": "xref7",
- "xRef8": "xref8",
- "xRef9": "xref9",
- "xRef10": "xref10",
- "xRef11": "xref11",
- "xRef12": "xref12",
- "xRef13": "xref13",
- "xRef14": "xref14",
- "xRef15": "xref15",
- "xRef16": "xref16",
- "xRef17": "xref17",
- "xRef18": "xref18",
- "xRef19": "xref19",
- "xRef20": "xref20",
- "xRef21": "xref21",
- "xRef22": "xref22",
- "xRef23": "xref23",
- "xRef24": "xref24",
- "xRef25": "xref25",
- "xRef26": "xref26",
- "xRef27": "xref27",
- "userComment": "Comment",
- "altUserComment": "Alternate Comment"
}, - {
- "financialPostDateTime": "2018-01-31T00:00:00",
- "altDateTime": "2019-01-31T00:00:00",
- "startUserDateTime": "2020-01-01T00:00:00",
- "endUserDateTime": "2020-01-31T00:00:00",
- "udKey1Segment": "C Major",
- "udKey2Segment": "IMPORT",
- "udKey3Segment": "CURRENT",
- "udKey4Segment": "REG",
- "udKey5Segment": "USA",
- "udKey6Segment": "T21",
- "udKey7Segment": "GLCV DSP 1",
- "udKey8Segment": "C01",
- "udKey9Segment": "TIER GROUP 1",
- "udKey10Segment": "Unspecified",
- "udKey11Segment": "1",
- "udKey12Segment": "Unspecified",
- "udKey13Segment": "Unspecified",
- "udKey14Segment": "Unspecified",
- "udKey15Segment": "Unspecified",
- "udKey16Segment": "Unspecified",
- "udKey20Segment": "Red",
- "userContact1Segment": "alliant",
- "userContact2Segment": "alma",
- "userContact3Segment": "kelly",
- "userContact4Segment": "tfa",
- "pricePoint": 10.5,
- "altPricePoint": 9.25,
- "user1Rate": 8,
- "user2Rate": 9,
- "user3Rate": 10,
- "amount": 16.75,
- "altAmount": 18.88,
- "quantity": 125.5,
- "altQuantity": 500,
- "xRef1": "xref1",
- "xRef2": "xref2",
- "xRef3": "xref3",
- "xRef4": "xref4",
- "xRef5": "xref5",
- "xRef6": "xref6",
- "xRef7": "xref7",
- "xRef8": "xref8",
- "xRef9": "xref9",
- "xRef10": "xref10",
- "xRef11": "xref11",
- "xRef12": "xref12",
- "xRef13": "xref13",
- "xRef14": "xref14",
- "xRef15": "xref15",
- "xRef16": "xref16",
- "xRef17": "xref17",
- "xRef18": "xref18",
- "xRef19": "xref19",
- "xRef20": "xref20",
- "xRef21": "xref21",
- "xRef22": "xref22",
- "xRef23": "xref23",
- "xRef24": "xref24",
- "xRef25": "xref25",
- "xRef26": "xref26",
- "xRef27": "xref27",
- "userComment": "Comment",
- "altUserComment": "Alternate Comment"
}
]
}, - "errors": [ ],
- "warnings": [ ],
- "hasErrors": false,
- "hasWarnings": false
}
Clear the Transactions from an Import Transaction Batch
Clear the Transactions from an Import Transaction Batch. This endpoint removes the Transactions in the Import Transaction Batch from the database. You should use this Tool when Transactions were mistakenly added in an Import Transaction Batch or when an error occurs while processing the Import job, as necessary. You can no longer use an Import Transaction Batch once it is cleared. When you want to resubmit any cleared Transactions, you must create a new Import Transaction Batch.
Note: You cannot submit pages of Transactions to an Import Transaction Batch that has been cleared. When you clear an Import Transaction Batch, the Transaction data is removed from the Database. However, you must create a new Import Transaction Batch to submit new pages of Transactions.
OK
Bad Request
Forbidden
Not Found
Method Not Allowed
Conflict
Unsupported Media Type
Internal Server Error
- 200
- 400
- 403
- 404
- 405
- 409
- 415
- 500
{- "result": null,
- "errors": [ ],
- "warnings": [ ],
- "hasErrors": false,
- "hasWarnings": false
}
Get multiple Import Transaction Batches
Read the data for multiple Import Transaction Batches.
You can use the parameters available for multiple-Item endpoints to filter the results based on the Batch ID (returned as the sid parameter) or the Job Queue Globally Unique Identifier (returned as the jobQueueGUID parameter). For example, when you want to Read the information for an API Transaction Import Batch with the batchId value of 1, the endpoint can be as follows:
{Base Address}/api/data/stagingAPIBatch?$Filter=sid eq 1
query Parameters
OK
Bad Request
Forbidden
Not Found
Internal Server Error
- 200
- 400
- 403
- 404
- 500
{- "result": {
- "previousPageUrl": "string",
- "nextPageUrl": "string",
- "itemCount": 1,
- "totalItemCount": 20,
- "items": [
- {
- "_type": "dataItemType",
- "displayName": "string",
- "guid": "6c556cd8-ac27-4167-844c-f00ddb170b3f",
- "comment": "string",
- "createdDatetime": "2019-08-24T14:15:22Z",
- "fileDownloadNumber": 0,
- "importFileReference": {
- "_type": "dataItemType",
- "displayName": "string",
- "guid": "6c556cd8-ac27-4167-844c-f00ddb170b3f"
}, - "jobQueueGUID": "6c556cd8-ac27-4167-844c-f00ddb170b3f",
- "pageSize": 0,
- "processingProcedureEndDatetime": "2019-08-24T14:15:22Z",
- "processingProcedureStartDatetime": "2019-08-24T14:15:22Z",
- "receivedTransactions": 0,
- "sid": 1,
- "stagingClearedDatetime": "2019-08-24T14:15:22Z",
- "submittedDatetime": "2019-08-24T14:15:22Z",
- "systemModifiedDatetime": "2019-08-24T14:15:22Z",
- "totalTransactions": 0
}
]
}, - "errors": [ ],
- "warnings": [ ],
- "hasErrors": false,
- "hasWarnings": false
}
Get a single Import Transaction Batch
Read the data for a single Import Transaction Batch.
query Parameters
minimal | boolean When you specify this Verbosity parameter, the |
default | boolean Use this Verbosity parameter option when you want Alliant API to return a response that includes all properties for the Item, including UD Fields. This is the default option that is used when no Verbosity parameter is provided. |
verbose | boolean Use this Verbosity parameter option when you want Alliant API to return UD Field Lookups, Adjustments on Tab, Child Collection, and Cross-Reference properties in addition to the properties from the default Verbosity level. Note: Using this parameter may affect performance and should only be used when necessary. |
include | string Use this Verbosity parameter to specify the properties to include in the response, separated by commas. You can also specify that you want to include Adjustments on Tab, Cross-Reference data Items, Child Items, and Child fields in the response. When you set the Verbosity of the response to minimal or default, Items only display as much information as the Verbosity parameter allows. You can use the ChildDataItem.ChildPropertyName syntax to specify when you want to return additional Child properties. Note: When the values specified in the include parameter are not valid, the query parameter is ignored and a warning is added to response includes property1, childItem1 child collection, childProperty2 of childItem2 collection, udLookup_UDField1 UD Field lookup collection. include=property1,childItem1,childItem2.childProperty2,udLookup_UDField1 |
exclude | string Use this Verbosity parameter to specify the properties to exclude from the response, separated by commas. You can also specify that you want to exclude Adjustments on Tab, Cross-Reference data Items, Child Items, and Child fields from the response. You can use the ChildDataItem.ChildPropertyName syntax to specify when you want to exclude specific Child properties. Note: When the values specified in the exclude parameter are not valid, the query parameter is ignored and a warning is added to response includes all properies according to Verbosity parameter, except for property1, childItem1 collection, childProperty2 of childItem2 collection, and udLookup_UDField1 UD Field lookup collection. exclude=property1,childItem1,childItem2.childProperty2,udLookup_UDField1 |
autoLogOff | boolean Use the autoLogOff parameter to log off Alliant API, discard the Alliant session Security Token, and release the Alliant license currently in use by Alliant API once the request completes. |
OK
Forbidden
Not Found
Internal Server Error
- 200
- 403
- 404
- 500
{- "result": {
- "_timestamp": "00000000008D644C",
- "_type": "stagingAPIBatch",
- "comment": "Transaction Import from Alliant API",
- "createdDatetime": "2022-03-24T12:11:50.843",
- "displayName": "1",
- "fileDownloadNumber": null,
- "guid": "fab1ea91-86b1-4301-a499-415d6429865f",
- "importFileReference": {
- "_type": "importFile",
- "displayName": "transactions",
- "guid": "21ca795a-c916-4124-8973-aaa6b17f8dff"
}, - "jobQueueGUID": null,
- "pageSize": 2,
- "processingProcedureEndDatetime": null,
- "processingProcedureStartDatetime": null,
- "receivedTransactions": 3,
- "sid": 1,
- "stagingClearedDatetime": "2022-03-24T12:26:51.813",
- "submittedDatetime": null,
- "systemModifiedDatetime": "2022-03-24T12:26:51.813",
- "totalTransactions": 3
}, - "errors": [ ],
- "warnings": [ ],
- "hasErrors": false,
- "hasWarnings": false
}
Get multiple Job Queue Summaries
Read the Job Queue Information for an API Transaction Import Batch Job.
You can use the parameters available for multiple-Item endpoints to filter the results based on the Job Queue Globally Unique Identifier (returned as the jobQueueGUID parameter when you read the data for an API Transaction Import Batch). For example, when you want to Read the information for an API Transaction Import Batch with the jobQueueGUID value of 51fe9515-0eb7-4ab9-90ed-847b867e3ba7, the endpoint can be as follows:
{Base Address}/api/data/JobQueueSummaries?$filter=jobQueueGUID eq '51fe9515-0eb7-4ab9-90ed-847b867e3ba7'
query Parameters
$filter | string Use the $filter parameter to filter returned data Items in a manner similar to the Alliant User Applications column filter. This parameter uses the following format: {filterBy} {operator} {value}
You can use the and and or operators to combine multiple filter parameter criteria. The response includes only data Items with a displayName value that contains 'rin' $filter=displayName contains 'rin'The response includes only data Items with a comment value that ends with 'ing' $filter=comment endswith 'ing'The response includes only data Items with a description value that starts with 'str' $filter=description startswith 'str'The response includes a single data Item with an id value equal to 'ABC123' $filter=id eq 'ABC123'The response includes only data Items with a udfVersionNumber value equal to 1 $filter=udfVersionNumber ge 1The response includes only data Items with a displayName value that starts with 'rin' or data Items with a comment value that ends with 'ing' and data Items with description value that starts with 'str' $filter=(displayName contains 'rin' or comment endswith 'ing') and description startswith 'str'The response includes only data Items that have no Admin Class $filter=adminClassReference eq null | ||||||||||||||||||||||||||||||
$orderby | string Use the $orderby parameter to specify the sort order of the returned data Items. You can specify a property or a property of a Reference property followed by asc or desc to sort returned data Items by a property in ascending or descending order. Note: When this parameter is not specified, the returned data Items are sorted by Display Name in ascending order. ascending sort by property1 $orderby=property1descending sort by property1 of the referenceProperty $orderby=referenceProperty.property1 desc | ||||||||||||||||||||||||||||||
$top | integer Use the $top parameter to specify the maximum number of Items to return. When you do not specify this parameter, 20 Items are returned by default. When you specify the verbose parameter, the maximum number of Items that you can request 100. When you specify the minimal or default parameters, the maximum number of Items that you can request 1000. This query parameter combined with $skip query parameter can be used to facilitate paging. The response includes 30 data Items $top=30 | ||||||||||||||||||||||||||||||
$skip | integer Use the $skip parameter to specify the number of Items to skip from the first result. This query parameter combined with the $top query parameter can be used to facilitate paging. For example, $skip=20&$top=20 returns the second page of 20 Items. The response includes data Items that follow the first 30 data Items $skip=30 | ||||||||||||||||||||||||||||||
minimal | boolean When you specify this Verbosity parameter, the | ||||||||||||||||||||||||||||||
default | boolean Use this Verbosity parameter option when you want Alliant API to return a response that includes all properties for the Item, including UD Fields. This is the default option that is used when no Verbosity parameter is provided. | ||||||||||||||||||||||||||||||
verbose | boolean Use this Verbosity parameter option when you want Alliant API to return UD Field Lookups, Adjustments on Tab, Child Collection, and Cross-Reference properties in addition to the properties from the default Verbosity level. Note: Using this parameter may affect performance and should only be used when necessary. | ||||||||||||||||||||||||||||||
include | string Use this Verbosity parameter to specify the properties to include in the response, separated by commas. You can also specify that you want to include Adjustments on Tab, Cross-Reference data Items, Child Items, and Child fields in the response. When you set the Verbosity of the response to minimal or default, Items only display as much information as the Verbosity parameter allows. You can use the ChildDataItem.ChildPropertyName syntax to specify when you want to return additional Child properties. Note: When the values specified in the include parameter are not valid, the query parameter is ignored and a warning is added to response includes property1, childItem1 child collection, childProperty2 of childItem2 collection, udLookup_UDField1 UD Field lookup collection. include=property1,childItem1,childItem2.childProperty2,udLookup_UDField1 | ||||||||||||||||||||||||||||||
exclude | string Use this Verbosity parameter to specify the properties to exclude from the response, separated by commas. You can also specify that you want to exclude Adjustments on Tab, Cross-Reference data Items, Child Items, and Child fields from the response. You can use the ChildDataItem.ChildPropertyName syntax to specify when you want to exclude specific Child properties. Note: When the values specified in the exclude parameter are not valid, the query parameter is ignored and a warning is added to response includes all properies according to Verbosity parameter, except for property1, childItem1 collection, childProperty2 of childItem2 collection, and udLookup_UDField1 UD Field lookup collection. exclude=property1,childItem1,childItem2.childProperty2,udLookup_UDField1 | ||||||||||||||||||||||||||||||
autoLogOff | boolean Use the autoLogOff parameter to log off Alliant API, discard the Alliant session Security Token, and release the Alliant license currently in use by Alliant API once the request completes. |
OK
Bad Request
Forbidden
Not Found
Internal Server Error
- 200
- 400
- 403
- 404
- 500
{- "result": {
- "previousPageUrl": null,
- "nextPageUrl": null,
- "itemCount": 1,
- "totalItemCount": 1,
- "items": [
- {
- "_type": "jobQueueSummary",
- "actualEndDatetime": null,
- "actualStartDatetime": null,
- "batchProcessReference": {
- "_type": "batchProcess",
- "displayName": "Import",
- "guid": "c2613a3a-a32a-4601-af34-f0316e7555e0"
}, - "dependencyGroupGUID": "df4f13b2-e7ad-457f-8304-704c1a5d8f3b",
- "dependencyGroupOrderNumber": 0,
- "displayName": "[EntityReference,S]: [JobQueue,S]; [RowIdentity,S]: 6302",
- " "eligibleGroupProcessFlag"": false,
- "entityReference": {
- "_type": "alliantEntityConfig",
- "displayName": "JobQueue",
- "guid": "26be7d8b-9f52-4e8f-8dad-d089d03ced74"
}, - "jobName": "API Import Transaction Batch 1",
- "jobPriority": 1,
- "jobQueueGUID": "51fe9515-0eb7-4ab9-90ed-847b867e3ba7",
- "lastAlarmNotifiedDatetime": null,
- "modifiedByUserReference": {
- "_type": "user",
- "displayName": "Alliant Administrator",
- "guid": "fdec8d27-5aa9-49c0-95f0-ffb34110164c"
}, - "modifiedDatetime": "2022-03-24T14:49:06.627",
- "multipleProcessingTypeReference": null,
- "processedQuantityMessage": null,
- "processingTypeReference": {
- "_type": "processingType",
- "displayName": "As Soon As Possible",
- "guid": "bc744ca6-462d-4a44-b56e-2d0b4a722b1b"
}, - "reoccurFlag": false,
- "requestedStartDatetime": "2022-03-24T14:49:06.627",
- "rescheduleFromDatetime": "2022-03-24T14:49:06.627",
- "rescheduleSequenceNumber": 0,
- "retryNumber": 0,
- "rowIdentity": 6302,
- "runAsPreviewFlag": false,
- "startRelativeToCutoffFlag": false,
- "startRelativeToPeriodReference": null,
- "statusReference": {
- "_type": "status",
- "displayName": "Waiting",
- "guid": "766f56f8-d5a9-478f-acbf-06ae4873e5cc"
}, - "submittedByUserReference": {
- "_type": "user",
- "displayName": "Alliant Administrator",
- "guid": "fdec8d27-5aa9-49c0-95f0-ffb34110164c"
}, - "submittedDatetime": "2022-03-24T14:49:06.627",
- "systemModifiedDatetime": "2022-03-24T14:49:06.627"
}
]
}, - "errors": [ ],
- "warnings": [ ],
- "hasErrors": false,
- "hasWarnings": false
}
Get multiple Transmission History Entries
Read the Transmission History information for an API Transaction Import Batch Job.
You can use the parameters available for multiple-Item endpoints to filter the results based on the System ID (SID) value for the apiBatchReference property, which corresponds to the batchID value for the API Transaction Import Batch. For example, when you want to Read the Transmission History information for an API Transaction Import Batch Job with the System ID (SID) value of 1 for the apiBatchReference property, the endpoint can be as follows:
{Base Address}/api/data/TransmissionHistories?$Filter=apiBatchReference.SID eq 1
Note: When you use Alliant API to submit an Import Transaction Batch and there are configuration issues that prevent the batch from being added to Import Transmission History, the batchID value for the Import Transaction Batch and the System ID (SID) value for the apiBatchReference property in Transmission History can get out of sync. When this occurs, use the Import Transaction Batch Clear endpoint to clear any batches that were submitted with the incorrect configuration. The batchID value for subsequent Import Transaction Batches will correspond to the System ID (SID) value for the apiBatchReference property in Transmission History.
query Parameters
$filter | string Use the $filter parameter to filter returned data Items in a manner similar to the Alliant User Applications column filter. This parameter uses the following format: {filterBy} {operator} {value}
You can use the and and or operators to combine multiple filter parameter criteria. The response includes only data Items with a displayName value that contains 'rin' $filter=displayName contains 'rin'The response includes only data Items with a comment value that ends with 'ing' $filter=comment endswith 'ing'The response includes only data Items with a description value that starts with 'str' $filter=description startswith 'str'The response includes a single data Item with an id value equal to 'ABC123' $filter=id eq 'ABC123'The response includes only data Items with a udfVersionNumber value equal to 1 $filter=udfVersionNumber ge 1The response includes only data Items with a displayName value that starts with 'rin' or data Items with a comment value that ends with 'ing' and data Items with description value that starts with 'str' $filter=(displayName contains 'rin' or comment endswith 'ing') and description startswith 'str'The response includes only data Items that have no Admin Class $filter=adminClassReference eq null | ||||||||||||||||||||||||||||||
$orderby | string Use the $orderby parameter to specify the sort order of the returned data Items. You can specify a property or a property of a Reference property followed by asc or desc to sort returned data Items by a property in ascending or descending order. Note: When this parameter is not specified, the returned data Items are sorted by Display Name in ascending order. ascending sort by property1 $orderby=property1descending sort by property1 of the referenceProperty $orderby=referenceProperty.property1 desc | ||||||||||||||||||||||||||||||
$top | integer Use the $top parameter to specify the maximum number of Items to return. When you do not specify this parameter, 20 Items are returned by default. When you specify the verbose parameter, the maximum number of Items that you can request 100. When you specify the minimal or default parameters, the maximum number of Items that you can request 1000. This query parameter combined with $skip query parameter can be used to facilitate paging. The response includes 30 data Items $top=30 | ||||||||||||||||||||||||||||||
$skip | integer Use the $skip parameter to specify the number of Items to skip from the first result. This query parameter combined with the $top query parameter can be used to facilitate paging. For example, $skip=20&$top=20 returns the second page of 20 Items. The response includes data Items that follow the first 30 data Items $skip=30 | ||||||||||||||||||||||||||||||
minimal | boolean When you specify this Verbosity parameter, the | ||||||||||||||||||||||||||||||
default | boolean Use this Verbosity parameter option when you want Alliant API to return a response that includes all properties for the Item, including UD Fields. This is the default option that is used when no Verbosity parameter is provided. | ||||||||||||||||||||||||||||||
verbose | boolean Use this Verbosity parameter option when you want Alliant API to return UD Field Lookups, Adjustments on Tab, Child Collection, and Cross-Reference properties in addition to the properties from the default Verbosity level. Note: Using this parameter may affect performance and should only be used when necessary. | ||||||||||||||||||||||||||||||
include | string Use this Verbosity parameter to specify the properties to include in the response, separated by commas. You can also specify that you want to include Adjustments on Tab, Cross-Reference data Items, Child Items, and Child fields in the response. When you set the Verbosity of the response to minimal or default, Items only display as much information as the Verbosity parameter allows. You can use the ChildDataItem.ChildPropertyName syntax to specify when you want to return additional Child properties. Note: When the values specified in the include parameter are not valid, the query parameter is ignored and a warning is added to response includes property1, childItem1 child collection, childProperty2 of childItem2 collection, udLookup_UDField1 UD Field lookup collection. include=property1,childItem1,childItem2.childProperty2,udLookup_UDField1 | ||||||||||||||||||||||||||||||
exclude | string Use this Verbosity parameter to specify the properties to exclude from the response, separated by commas. You can also specify that you want to exclude Adjustments on Tab, Cross-Reference data Items, Child Items, and Child fields from the response. You can use the ChildDataItem.ChildPropertyName syntax to specify when you want to exclude specific Child properties. Note: When the values specified in the exclude parameter are not valid, the query parameter is ignored and a warning is added to response includes all properies according to Verbosity parameter, except for property1, childItem1 collection, childProperty2 of childItem2 collection, and udLookup_UDField1 UD Field lookup collection. exclude=property1,childItem1,childItem2.childProperty2,udLookup_UDField1 | ||||||||||||||||||||||||||||||
autoLogOff | boolean Use the autoLogOff parameter to log off Alliant API, discard the Alliant session Security Token, and release the Alliant license currently in use by Alliant API once the request completes. |
OK
Bad Request
Forbidden
Not Found
Internal Server Error
- 200
- 400
- 403
- 404
- 500
{- "result": {
- "previousPageUrl": null,
- "nextPageUrl": null,
- "itemCount": 1,
- "totalItemCount": 1,
- "items": [
- {
- "_type": "transmissionHistory",
- "apiBatchReference": {
- "_type": "stagingAPIBatch",
- "displayName": "1",
- "guid": "965509c8-82b6-4ba3-9dd7-13339fde27d0"
}, - "bigRowIdentity": 3,
- "detailRecordsCount": 0,
- "displayName": "[ImportFileReference,S]: ; [BigRowIdentity,S]: 3",
- "downloadAttemptSequenceNumber": 1,
- "fileDownloadNumber": 3,
- "importEndDatetime": "2022-03-29T08:12:46",
- "importFileName": "Transactions [schedule]",
- "importFileReference": {
- "_type": "importFile",
- "displayName": "Transactions",
- "guid": "bbb57cac-15d6-439c-aa18-1e1806fe82c9"
}, - "importStartDatetime": "2022-03-29T08:12:38",
- "processingProcedureCompleteFlag": true,
- "processingProcedureEndDatetime": "2022-03-29T08:12:41",
- "processingProcedureStartDatetime": "2022-03-29T08:12:41",
- "ssisPackageCompleteFlag": false,
- "ssisPackageEndDatetime": null,
- "ssisPackageStartDatetime": null,
- "statusReference": {
- "_type": "status",
- "displayName": "Accepted",
- "guid": "43041de0-1f1b-4a1f-a574-8ceaee210f51"
}, - "systemModifiedDatetime": "2022-03-29T08:12:46",
- "totalCurrentAddedCount": 1,
- "totalCurrentDeletedCount": 0,
- "totalCurrentErroredCount": 0,
- "totalCurrentIgnoredCount": 0,
- "totalCurrentModifiedCount": 0,
- "totalCurrentSuspendedCount": 0,
- "totalOriginalAddedCount": 1,
- "totalOriginalDeletedCount": 0,
- "totalOriginalErroredCount": 0,
- "totalOriginalIgnoredCount": 0,
- "totalOriginalModifiedCount": 0,
- "totalOriginalSuspendedCount": 0,
- "totalPostJobErroredCount": 0,
- "transmissionFileCreatedDate": "2022-03-29T08:12:38.853",
- "transmissionReceivedDate": "2022-03-29T08:12:38",
- "tsaHistortyActualDetailCount": 0,
- "tsaHistoryDetailCount": 0,
- "tsaSummaryActualDetailCount": 1,
- "tsaSummaryDetailCount": 0,
- "useProcessingProcedureFlag": true,
- "useSSISPackageFlag": false
}
]
}, - "errors": [ ],
- "warnings": [ ],
- "hasErrors": false,
- "hasWarnings": false
}
Get multiple Transmission History Error Records
You can use the parameters available for multiple-Item endpoints to filter the results based on the System ID (SID) value for the apiBatchReference property, which corresponds to the batchID value for the API Transaction Import Batch. For example, when you want to Read the Transmission History error information for an API Transaction Import Batch Job with the System ID (SID) value of 1 for the apiBatchReference property, the endpoint can be as follows:
{Base Address}/api/data/TransmissionHistoryErrors?$Filter=apiBatchReference.SID eq 1
Note: When you use Alliant API to submit an Import Transaction Batch and there are configuration issues that prevent the batch from being added to Import Transmission History, the batchID value for the Import Transaction Batch and the System ID (SID) value for the apiBatchReference property in Transmission History can get out of sync. When this occurs, use the Import Transaction Batch Clear endpoint to clear any batches that were submitted with the incorrect configuration. The batchID value for subsequent Import Transaction Batches will correspond to the System ID (SID) value for the apiBatchReference property in Transmission History Errors.
query Parameters
$filter | string Use the $filter parameter to filter returned data Items in a manner similar to the Alliant User Applications column filter. This parameter uses the following format: {filterBy} {operator} {value}
You can use the and and or operators to combine multiple filter parameter criteria. The response includes only data Items with a displayName value that contains 'rin' $filter=displayName contains 'rin'The response includes only data Items with a comment value that ends with 'ing' $filter=comment endswith 'ing'The response includes only data Items with a description value that starts with 'str' $filter=description startswith 'str'The response includes a single data Item with an id value equal to 'ABC123' $filter=id eq 'ABC123'The response includes only data Items with a udfVersionNumber value equal to 1 $filter=udfVersionNumber ge 1The response includes only data Items with a displayName value that starts with 'rin' or data Items with a comment value that ends with 'ing' and data Items with description value that starts with 'str' $filter=(displayName contains 'rin' or comment endswith 'ing') and description startswith 'str'The response includes only data Items that have no Admin Class $filter=adminClassReference eq null | ||||||||||||||||||||||||||||||
$orderby | string Use the $orderby parameter to specify the sort order of the returned data Items. You can specify a property or a property of a Reference property followed by asc or desc to sort returned data Items by a property in ascending or descending order. Note: When this parameter is not specified, the returned data Items are sorted by Display Name in ascending order. ascending sort by property1 $orderby=property1descending sort by property1 of the referenceProperty $orderby=referenceProperty.property1 desc | ||||||||||||||||||||||||||||||
$top | integer Use the $top parameter to specify the maximum number of Items to return. When you do not specify this parameter, 20 Items are returned by default. When you specify the verbose parameter, the maximum number of Items that you can request 100. When you specify the minimal or default parameters, the maximum number of Items that you can request 1000. This query parameter combined with $skip query parameter can be used to facilitate paging. The response includes 30 data Items $top=30 | ||||||||||||||||||||||||||||||
$skip | integer Use the $skip parameter to specify the number of Items to skip from the first result. This query parameter combined with the $top query parameter can be used to facilitate paging. For example, $skip=20&$top=20 returns the second page of 20 Items. The response includes data Items that follow the first 30 data Items $skip=30 | ||||||||||||||||||||||||||||||
minimal | boolean When you specify this Verbosity parameter, the | ||||||||||||||||||||||||||||||
default | boolean Use this Verbosity parameter option when you want Alliant API to return a response that includes all properties for the Item, including UD Fields. This is the default option that is used when no Verbosity parameter is provided. | ||||||||||||||||||||||||||||||
verbose | boolean Use this Verbosity parameter option when you want Alliant API to return UD Field Lookups, Adjustments on Tab, Child Collection, and Cross-Reference properties in addition to the properties from the default Verbosity level. Note: Using this parameter may affect performance and should only be used when necessary. | ||||||||||||||||||||||||||||||
include | string Use this Verbosity parameter to specify the properties to include in the response, separated by commas. You can also specify that you want to include Adjustments on Tab, Cross-Reference data Items, Child Items, and Child fields in the response. When you set the Verbosity of the response to minimal or default, Items only display as much information as the Verbosity parameter allows. You can use the ChildDataItem.ChildPropertyName syntax to specify when you want to return additional Child properties. Note: When the values specified in the include parameter are not valid, the query parameter is ignored and a warning is added to response includes property1, childItem1 child collection, childProperty2 of childItem2 collection, udLookup_UDField1 UD Field lookup collection. include=property1,childItem1,childItem2.childProperty2,udLookup_UDField1 | ||||||||||||||||||||||||||||||
exclude | string Use this Verbosity parameter to specify the properties to exclude from the response, separated by commas. You can also specify that you want to exclude Adjustments on Tab, Cross-Reference data Items, Child Items, and Child fields from the response. You can use the ChildDataItem.ChildPropertyName syntax to specify when you want to exclude specific Child properties. Note: When the values specified in the exclude parameter are not valid, the query parameter is ignored and a warning is added to response includes all properies according to Verbosity parameter, except for property1, childItem1 collection, childProperty2 of childItem2 collection, and udLookup_UDField1 UD Field lookup collection. exclude=property1,childItem1,childItem2.childProperty2,udLookup_UDField1 | ||||||||||||||||||||||||||||||
autoLogOff | boolean Use the autoLogOff parameter to log off Alliant API, discard the Alliant session Security Token, and release the Alliant license currently in use by Alliant API once the request completes. |
OK
Bad Request
Forbidden
Not Found
Internal Server Error
- 200
- 400
- 403
- 404
- 500
{- "result": {
- "previousPageUrl": null,
- "itemCount": 20,
- "totalItemCount": 57,
- "items": [
- {
- "_type": "transmissionHistoryError",
- "apiBatchReference": {
- "_type": "stagingAPIBatch",
- "displayName": "4",
- "guid": "965509c8-82b6-4ba3-9dd7-13339fde27d0"
}, - "displayName": "11833",
- "downloadAttemptSequenceNumber": 1,
- "fileDownloadNumber": 3,
- "importFileReference": {
- "_type": "importFile",
- "displayName": "Transactions",
- "guid": "bbb57cac-15d6-439c-aa18-1e1806fe82c9"
}, - "logDatetime": "2019-08-02T15:34:10",
- "logText": "Message Text",
- "logTypeReference": {
- "_type": "logType",
- "displayName": "Informational Message",
- "guid": "a8a14d5e-f5ce-421c-8846-4ec233a892e7"
}, - "rowIdentity": 11833,
- "systemModifiedDatetime": null
}
]
}, - "errors": [ ],
- "warnings": [ ],
- "hasErrors": false,
- "hasWarnings": false
}