Is the ARB100D1-NOI.DAT report accessible in API format?
GetTransportationInvoicePayments and provides the data of the ARB100D1-NOI.DAT report
GetTransportationInvoicePayments shows all Paid Transportation Invoices Transactions based on a date range. Data shows the Origin Release, Shipment Request, and Distribution information based on a date range.
Data Availability: Real - Time
API Library: Billing
Request Parameters for GetTransportationInvoiceTransactions:
mock.magellanlp.com/open/billing/v4/invoices/transportation/{magellanCompanyId}/{billToCustomerId}/{invoiceId}/transactions[?page][&results]
| Data Field | Information |
| Data Company ID (Required) | Accepts "1" or "MPL". This value determines which ONEOK internal database will be used to retrieve the data. |
| billToCustomerId (Required) |
The affiliate number assigned by ONEOK Refined Fuels. If you do not know your affiliate number, contact your ONEOK Company Administrator for access.
|
| invoiceId (Required) | A list of InvoiceIDs can be generated using the GETTransportationInvoices endpoint. |
Request Parameters for GetTransportationInvoiceTransactions: To find a specific Transaction on the invoice
https://api-mock.magellanlp.com/open/billing/v4/invoices/transportation/{magellanCompanyId}/{billToCustomerId}/{invoiceId}/transactions/{transactionId}
Add:
| TransactionId (Required) |
"id": "1234567890
|
Responses
| Field Name | Sample Data | Description |
| ID (required) |
1234567890
|
Invoice ID Number - if needed invoiceId a list of InvoiceIDs can be generated using the GETTransportationInvoices endpoint. |
| Location | ONEOK Refined Location -= ONEOK Terminal Names and Numbers | |
| ID | 200 | ONEOK Refined Terminal Number |
| Name | Kansas City | ONEOK Refined Terminal Name |
| Origin | Refinery or an third-party location, such as another pipeline, that brings product onto the ONEOK Refined system. | |
| ID | 1234 | ONEOK number of the refinery or an third-party location, such as another pipeline, that brings product onto the ONEOK Refined system. |
| Name | ABC Refinery | Name of the refinery or an third-party location, such as another pipeline, that brings product onto the ONEOK Refined system. |
|
bookedDate
|
2025-08-15T00:00:00
|
Date transaction was entered into the system. |
|
transactionDate
|
2025-08-15T03:01:46 | Date product actually moved into the ONEOK Refined system. |
| Volume | 100 | Volume of product entering the ONEOK Refined system |
|
unitOfMeasure
|
BBL | Barrels vs Gallons |
| Rate | 1.40 | Tariff Rate |
| Total Charge | 125 | Amount Owed By Customer |
| Rate Type | TRANSPORTATION or SURCHARGE | Service being billed |
|
RateSubType
|
TARIFF or SPECIAL HANDLING A GRADE | Tariff Classification |
| Shipment Request ID |
1234578
|
ONEOK Refined ID for the Shipment - Can be found in the Get Distributions - Shipping Endpoint
effectiveRateDate
|
|
effectiveRateDate
|
2025-07-29T15:16:09
|
Date of the Tariff effective date |
|
TicketId
|
null
|
|
|
Reference
|
null
|