POST api/v1/Reports/Records/Sp
Request Information
URI Parameters
None.
Body Parameters
SpRequestName | Description | Type | Additional information |
---|---|---|---|
Key | integer |
None. |
|
From | integer |
None. |
|
To | integer |
None. |
|
Paid | boolean |
None. |
|
Date | string |
None. |
|
Columns | string |
None. |
|
SourceKey | string |
None. |
|
Table | string |
None. |
|
Module | string |
None. |
Request Formats
application/json, text/json
Sample:
{ "Key": 1, "From": 2, "To": 3, "Paid": true, "Date": "sample string 5", "Columns": "sample string 6", "SourceKey": "sample string 7", "Table": "sample string 8", "Module": "sample string 9" }
application/xml, text/xml
Sample:
<PRS.SpRequest xmlns:i="http://www.w3.org/2001/XMLSchema-instance" xmlns="http://schemas.datacontract.org/2004/07/PortalEntities.Models"> <Columns>sample string 6</Columns> <Date>sample string 5</Date> <From>2</From> <Key>1</Key> <Module>sample string 9</Module> <Paid>true</Paid> <SourceKey>sample string 7</SourceKey> <Table>sample string 8</Table> <To>3</To> </PRS.SpRequest>
application/x-www-form-urlencoded
Sample:
Sample not available.
Response Information
Resource Description
Collection of StoredProcedureRecordsName | Description | Type | Additional information |
---|---|---|---|
ID_Account | integer |
None. |
|
ID_ExternalReference | integer |
None. |
|
AWB | string |
None. |
|
AWBOrigin | string |
None. |
|
AWBProductGroup | string |
None. |
|
AWBDestination | string |
None. |
|
Currency | string |
None. |
|
Amount | decimal number |
None. |
|
VAT | decimal number |
None. |
|
Duties | decimal number |
None. |
|
AdminFee | string |
None. |
|
IsPaid | string |
None. |
|
Source_of_Collection | string |
None. |
|
Payment_Reference | string |
None. |
|
Payment_Date | date |
None. |
|
Total_Charge_taken | decimal number |
None. |
|
Stripe_Fee | decimal number |
None. |
|
Total_amount___Stripe_fee | decimal number |
None. |
|
ShipperReference | string |
None. |
|
CustomerName | string |
None. |
|
CustomerEmail | string |
None. |
|
EmailCount | integer |
None. |
|
CustomerNumber | string |
None. |
|
Status | string |
None. |
|
Import_Date | date |
None. |
Response Formats
application/json, text/json
Sample:
[ { "ID_Account": 1, "ID_ExternalReference": 1, "AWB": "sample string 2", "AWBOrigin": "sample string 3", "AWBProductGroup": "sample string 4", "AWBDestination": "sample string 5", "Currency": "sample string 6", "Amount": 1.0, "VAT": 1.0, "Duties": 1.0, "AdminFee": "sample string 7", "IsPaid": "sample string 8", "Source_of_Collection": "sample string 9", "Payment_Reference": "sample string 10", "Payment_Date": "2025-09-05T07:38:36.3942415+00:00", "Total_Charge_taken": 1.0, "Stripe_Fee": 1.0, "Total_amount___Stripe_fee": 1.0, "ShipperReference": "sample string 11", "CustomerName": "sample string 12", "CustomerEmail": "sample string 13", "EmailCount": 14, "CustomerNumber": "sample string 15", "Status": "sample string 16", "Import_Date": "2025-09-05T07:38:36.3942415+00:00" }, { "ID_Account": 1, "ID_ExternalReference": 1, "AWB": "sample string 2", "AWBOrigin": "sample string 3", "AWBProductGroup": "sample string 4", "AWBDestination": "sample string 5", "Currency": "sample string 6", "Amount": 1.0, "VAT": 1.0, "Duties": 1.0, "AdminFee": "sample string 7", "IsPaid": "sample string 8", "Source_of_Collection": "sample string 9", "Payment_Reference": "sample string 10", "Payment_Date": "2025-09-05T07:38:36.3942415+00:00", "Total_Charge_taken": 1.0, "Stripe_Fee": 1.0, "Total_amount___Stripe_fee": 1.0, "ShipperReference": "sample string 11", "CustomerName": "sample string 12", "CustomerEmail": "sample string 13", "EmailCount": 14, "CustomerNumber": "sample string 15", "Status": "sample string 16", "Import_Date": "2025-09-05T07:38:36.3942415+00:00" } ]
application/xml, text/xml
Sample:
<ArrayOfPRS.StoredProcedureRecords xmlns:i="http://www.w3.org/2001/XMLSchema-instance" xmlns="http://schemas.datacontract.org/2004/07/PortalEntities.Models"> <PRS.StoredProcedureRecords> <AWB>sample string 2</AWB> <AWBDestination>sample string 5</AWBDestination> <AWBOrigin>sample string 3</AWBOrigin> <AWBProductGroup>sample string 4</AWBProductGroup> <AdminFee>sample string 7</AdminFee> <Amount>1</Amount> <Currency>sample string 6</Currency> <CustomerEmail>sample string 13</CustomerEmail> <CustomerName>sample string 12</CustomerName> <CustomerNumber>sample string 15</CustomerNumber> <Duties>1</Duties> <EmailCount>14</EmailCount> <ID_Account>1</ID_Account> <ID_ExternalReference>1</ID_ExternalReference> <Import_Date>2025-09-05T07:38:36.3942415+00:00</Import_Date> <IsPaid>sample string 8</IsPaid> <Payment_Date>2025-09-05T07:38:36.3942415+00:00</Payment_Date> <Payment_Reference>sample string 10</Payment_Reference> <ShipperReference>sample string 11</ShipperReference> <Source_of_Collection>sample string 9</Source_of_Collection> <Status>sample string 16</Status> <Stripe_Fee>1</Stripe_Fee> <Total_Charge_taken>1</Total_Charge_taken> <Total_amount___Stripe_fee>1</Total_amount___Stripe_fee> <VAT>1</VAT> </PRS.StoredProcedureRecords> <PRS.StoredProcedureRecords> <AWB>sample string 2</AWB> <AWBDestination>sample string 5</AWBDestination> <AWBOrigin>sample string 3</AWBOrigin> <AWBProductGroup>sample string 4</AWBProductGroup> <AdminFee>sample string 7</AdminFee> <Amount>1</Amount> <Currency>sample string 6</Currency> <CustomerEmail>sample string 13</CustomerEmail> <CustomerName>sample string 12</CustomerName> <CustomerNumber>sample string 15</CustomerNumber> <Duties>1</Duties> <EmailCount>14</EmailCount> <ID_Account>1</ID_Account> <ID_ExternalReference>1</ID_ExternalReference> <Import_Date>2025-09-05T07:38:36.3942415+00:00</Import_Date> <IsPaid>sample string 8</IsPaid> <Payment_Date>2025-09-05T07:38:36.3942415+00:00</Payment_Date> <Payment_Reference>sample string 10</Payment_Reference> <ShipperReference>sample string 11</ShipperReference> <Source_of_Collection>sample string 9</Source_of_Collection> <Status>sample string 16</Status> <Stripe_Fee>1</Stripe_Fee> <Total_Charge_taken>1</Total_Charge_taken> <Total_amount___Stripe_fee>1</Total_amount___Stripe_fee> <VAT>1</VAT> </PRS.StoredProcedureRecords> </ArrayOfPRS.StoredProcedureRecords>