GET api/SqlDocument/GetSqlDocuments?docType={docType}

Request Information

URI Parameters

Name	Description	Type	Additional information
docType		DocTypes	Required

Body Parameters

None.

Response Information

Resource Description

Collection of DTOSqlDocument

Name	Type	Additional information
DocumentNumber	string	None.
DocumentType	integer	None.
DocumentDate	date	None.
CustSupplCode	string	None.
CustDelivCode	string	None.
CustSupplDesc	string	None.
SalesmanCode	string	None.
SalesmanDesc	string	None.
OrderNumber	string	None.
PriceListId	integer	None.
PriceListDesc	string	None.
DiscountPercent	decimal number	None.
Freight01	string	None.
Ship	string	None.
Contact	string	None.
Telephone	string	None.
Cell	string	None.
Fax	string	None.
DelAddress01	string	None.
DelAddress02	string	None.
DelAddress03	string	None.
DelAddress04	string	None.
DelAddress05	string	None.
PostAddress01	string	None.
PostAddress02	string	None.
PostAddress03	string	None.
PostAddress04	string	None.
PostAddress05	string	None.
Message01	string	None.
Message02	string	None.
Message03	string	None.
PastelUserId	integer	None.
AppUserId	string	None.
UserName	string	None.
OrderId	string	None.
DocStatus	integer	None.
DocumentLines	Collection of DTOSqlDocumentLine	None.

Response Formats

application/json, text/json

Sample:

[
  {
    "DocumentNumber": "sample string 1",
    "DocumentType": 2,
    "DocumentDate": "2026-08-26T19:28:23.3065029+02:00",
    "CustSupplCode": "sample string 4",
    "CustDelivCode": "sample string 5",
    "CustSupplDesc": "sample string 6",
    "SalesmanCode": "sample string 7",
    "SalesmanDesc": "sample string 8",
    "OrderNumber": "sample string 9",
    "PriceListId": 10,
    "PriceListDesc": "sample string 11",
    "DiscountPercent": 12.1,
    "Freight01": "sample string 13",
    "Ship": "sample string 14",
    "Contact": "sample string 15",
    "Telephone": "sample string 16",
    "Cell": "sample string 17",
    "Fax": "sample string 18",
    "DelAddress01": "sample string 19",
    "DelAddress02": "sample string 20",
    "DelAddress03": "sample string 21",
    "DelAddress04": "sample string 22",
    "DelAddress05": "sample string 23",
    "PostAddress01": "sample string 24",
    "PostAddress02": "sample string 25",
    "PostAddress03": "sample string 26",
    "PostAddress04": "sample string 27",
    "PostAddress05": "sample string 28",
    "Message01": "sample string 29",
    "Message02": "sample string 30",
    "Message03": "sample string 31",
    "PastelUserId": 1,
    "AppUserId": "sample string 32",
    "UserName": "sample string 33",
    "OrderId": "sample string 34",
    "DocStatus": 35,
    "DocumentLines": [
      {
        "LineDocNum": "sample string 1",
        "LineNum": 2,
        "SearchType": 3,
        "StoreCode": "sample string 4",
        "StoreDesc": "sample string 5",
        "ItemCode": "sample string 6",
        "ItemDesc": "sample string 7",
        "Barcode": "sample string 8",
        "Bin": "sample string 9",
        "Physical": true,
        "UnitUsed": "sample string 11",
        "ItemSize": "sample string 12",
        "PackWeight": "sample string 13",
        "PackDimension": "sample string 14",
        "PackSize": 15.1,
        "ItemWeight": 16.1,
        "ItemVolumetric": 17.1,
        "Qty": 18.1,
        "DiscountPercentage": 19,
        "UnitPriceExcl": 20.1,
        "UnitPriceIncl": 21.1,
        "PastelDocNumber": "sample string 22",
        "StockStatus": 23
      },
      {
        "LineDocNum": "sample string 1",
        "LineNum": 2,
        "SearchType": 3,
        "StoreCode": "sample string 4",
        "StoreDesc": "sample string 5",
        "ItemCode": "sample string 6",
        "ItemDesc": "sample string 7",
        "Barcode": "sample string 8",
        "Bin": "sample string 9",
        "Physical": true,
        "UnitUsed": "sample string 11",
        "ItemSize": "sample string 12",
        "PackWeight": "sample string 13",
        "PackDimension": "sample string 14",
        "PackSize": 15.1,
        "ItemWeight": 16.1,
        "ItemVolumetric": 17.1,
        "Qty": 18.1,
        "DiscountPercentage": 19,
        "UnitPriceExcl": 20.1,
        "UnitPriceIncl": 21.1,
        "PastelDocNumber": "sample string 22",
        "StockStatus": 23
      }
    ]
  },
  {
    "DocumentNumber": "sample string 1",
    "DocumentType": 2,
    "DocumentDate": "2026-08-26T19:28:23.3065029+02:00",
    "CustSupplCode": "sample string 4",
    "CustDelivCode": "sample string 5",
    "CustSupplDesc": "sample string 6",
    "SalesmanCode": "sample string 7",
    "SalesmanDesc": "sample string 8",
    "OrderNumber": "sample string 9",
    "PriceListId": 10,
    "PriceListDesc": "sample string 11",
    "DiscountPercent": 12.1,
    "Freight01": "sample string 13",
    "Ship": "sample string 14",
    "Contact": "sample string 15",
    "Telephone": "sample string 16",
    "Cell": "sample string 17",
    "Fax": "sample string 18",
    "DelAddress01": "sample string 19",
    "DelAddress02": "sample string 20",
    "DelAddress03": "sample string 21",
    "DelAddress04": "sample string 22",
    "DelAddress05": "sample string 23",
    "PostAddress01": "sample string 24",
    "PostAddress02": "sample string 25",
    "PostAddress03": "sample string 26",
    "PostAddress04": "sample string 27",
    "PostAddress05": "sample string 28",
    "Message01": "sample string 29",
    "Message02": "sample string 30",
    "Message03": "sample string 31",
    "PastelUserId": 1,
    "AppUserId": "sample string 32",
    "UserName": "sample string 33",
    "OrderId": "sample string 34",
    "DocStatus": 35,
    "DocumentLines": [
      {
        "LineDocNum": "sample string 1",
        "LineNum": 2,
        "SearchType": 3,
        "StoreCode": "sample string 4",
        "StoreDesc": "sample string 5",
        "ItemCode": "sample string 6",
        "ItemDesc": "sample string 7",
        "Barcode": "sample string 8",
        "Bin": "sample string 9",
        "Physical": true,
        "UnitUsed": "sample string 11",
        "ItemSize": "sample string 12",
        "PackWeight": "sample string 13",
        "PackDimension": "sample string 14",
        "PackSize": 15.1,
        "ItemWeight": 16.1,
        "ItemVolumetric": 17.1,
        "Qty": 18.1,
        "DiscountPercentage": 19,
        "UnitPriceExcl": 20.1,
        "UnitPriceIncl": 21.1,
        "PastelDocNumber": "sample string 22",
        "StockStatus": 23
      },
      {
        "LineDocNum": "sample string 1",
        "LineNum": 2,
        "SearchType": 3,
        "StoreCode": "sample string 4",
        "StoreDesc": "sample string 5",
        "ItemCode": "sample string 6",
        "ItemDesc": "sample string 7",
        "Barcode": "sample string 8",
        "Bin": "sample string 9",
        "Physical": true,
        "UnitUsed": "sample string 11",
        "ItemSize": "sample string 12",
        "PackWeight": "sample string 13",
        "PackDimension": "sample string 14",
        "PackSize": 15.1,
        "ItemWeight": 16.1,
        "ItemVolumetric": 17.1,
        "Qty": 18.1,
        "DiscountPercentage": 19,
        "UnitPriceExcl": 20.1,
        "UnitPriceIncl": 21.1,
        "PastelDocNumber": "sample string 22",
        "StockStatus": 23
      }
    ]
  }
]

application/xml, text/xml

Sample:

<ArrayOfDTOSqlDocument xmlns:i="http://www.w3.org/2001/XMLSchema-instance" xmlns="http://schemas.datacontract.org/2004/07/PASTEL.Api.Library.DTOs">
  <DTOSqlDocument>
    <AppUserId>sample string 32</AppUserId>
    <Cell>sample string 17</Cell>
    <Contact>sample string 15</Contact>
    <CustDelivCode>sample string 5</CustDelivCode>
    <CustSupplCode>sample string 4</CustSupplCode>
    <CustSupplDesc>sample string 6</CustSupplDesc>
    <DelAddress01>sample string 19</DelAddress01>
    <DelAddress02>sample string 20</DelAddress02>
    <DelAddress03>sample string 21</DelAddress03>
    <DelAddress04>sample string 22</DelAddress04>
    <DelAddress05>sample string 23</DelAddress05>
    <DiscountPercent>12.1</DiscountPercent>
    <DocStatus>35</DocStatus>
    <DocumentDate>2026-08-26T19:28:23.3065029+02:00</DocumentDate>
    <DocumentLines>
      <DTOSqlDocumentLine>
        <Barcode>sample string 8</Barcode>
        <Bin>sample string 9</Bin>
        <DiscountPercentage>19</DiscountPercentage>
        <ItemCode>sample string 6</ItemCode>
        <ItemDesc>sample string 7</ItemDesc>
        <LineDocNum>sample string 1</LineDocNum>
        <LineNum>2</LineNum>
        <PastelDocNumber>sample string 22</PastelDocNumber>
        <Physical>true</Physical>
        <Qty>18.1</Qty>
        <SearchType>3</SearchType>
        <StockStatus>23</StockStatus>
        <StoreCode>sample string 4</StoreCode>
        <StoreDesc>sample string 5</StoreDesc>
        <UnitPriceExcl>20.1</UnitPriceExcl>
        <UnitPriceIncl>21.1</UnitPriceIncl>
        <UnitUsed>sample string 11</UnitUsed>
        <UserDefNum01>15.1</UserDefNum01>
        <UserDefNum02>16.1</UserDefNum02>
        <UserDefNum03>17.1</UserDefNum03>
        <UserDefText01>sample string 12</UserDefText01>
        <UserDefText02>sample string 13</UserDefText02>
        <UserDefText03>sample string 14</UserDefText03>
      </DTOSqlDocumentLine>
      <DTOSqlDocumentLine>
        <Barcode>sample string 8</Barcode>
        <Bin>sample string 9</Bin>
        <DiscountPercentage>19</DiscountPercentage>
        <ItemCode>sample string 6</ItemCode>
        <ItemDesc>sample string 7</ItemDesc>
        <LineDocNum>sample string 1</LineDocNum>
        <LineNum>2</LineNum>
        <PastelDocNumber>sample string 22</PastelDocNumber>
        <Physical>true</Physical>
        <Qty>18.1</Qty>
        <SearchType>3</SearchType>
        <StockStatus>23</StockStatus>
        <StoreCode>sample string 4</StoreCode>
        <StoreDesc>sample string 5</StoreDesc>
        <UnitPriceExcl>20.1</UnitPriceExcl>
        <UnitPriceIncl>21.1</UnitPriceIncl>
        <UnitUsed>sample string 11</UnitUsed>
        <UserDefNum01>15.1</UserDefNum01>
        <UserDefNum02>16.1</UserDefNum02>
        <UserDefNum03>17.1</UserDefNum03>
        <UserDefText01>sample string 12</UserDefText01>
        <UserDefText02>sample string 13</UserDefText02>
        <UserDefText03>sample string 14</UserDefText03>
      </DTOSqlDocumentLine>
    </DocumentLines>
    <DocumentNumber>sample string 1</DocumentNumber>
    <DocumentType>2</DocumentType>
    <Fax>sample string 18</Fax>
    <Freight01>sample string 13</Freight01>
    <Message01>sample string 29</Message01>
    <Message02>sample string 30</Message02>
    <Message03>sample string 31</Message03>
    <OrderId>sample string 34</OrderId>
    <OrderNumber>sample string 9</OrderNumber>
    <PastelUserId>1</PastelUserId>
    <PostAddress01>sample string 24</PostAddress01>
    <PostAddress02>sample string 25</PostAddress02>
    <PostAddress03>sample string 26</PostAddress03>
    <PostAddress04>sample string 27</PostAddress04>
    <PostAddress05>sample string 28</PostAddress05>
    <PriceListDesc>sample string 11</PriceListDesc>
    <PriceListId>10</PriceListId>
    <SalesmanCode>sample string 7</SalesmanCode>
    <SalesmanDesc>sample string 8</SalesmanDesc>
    <Ship>sample string 14</Ship>
    <Telephone>sample string 16</Telephone>
    <UserName>sample string 33</UserName>
  </DTOSqlDocument>
  <DTOSqlDocument>
    <AppUserId>sample string 32</AppUserId>
    <Cell>sample string 17</Cell>
    <Contact>sample string 15</Contact>
    <CustDelivCode>sample string 5</CustDelivCode>
    <CustSupplCode>sample string 4</CustSupplCode>
    <CustSupplDesc>sample string 6</CustSupplDesc>
    <DelAddress01>sample string 19</DelAddress01>
    <DelAddress02>sample string 20</DelAddress02>
    <DelAddress03>sample string 21</DelAddress03>
    <DelAddress04>sample string 22</DelAddress04>
    <DelAddress05>sample string 23</DelAddress05>
    <DiscountPercent>12.1</DiscountPercent>
    <DocStatus>35</DocStatus>
    <DocumentDate>2026-08-26T19:28:23.3065029+02:00</DocumentDate>
    <DocumentLines>
      <DTOSqlDocumentLine>
        <Barcode>sample string 8</Barcode>
        <Bin>sample string 9</Bin>
        <DiscountPercentage>19</DiscountPercentage>
        <ItemCode>sample string 6</ItemCode>
        <ItemDesc>sample string 7</ItemDesc>
        <LineDocNum>sample string 1</LineDocNum>
        <LineNum>2</LineNum>
        <PastelDocNumber>sample string 22</PastelDocNumber>
        <Physical>true</Physical>
        <Qty>18.1</Qty>
        <SearchType>3</SearchType>
        <StockStatus>23</StockStatus>
        <StoreCode>sample string 4</StoreCode>
        <StoreDesc>sample string 5</StoreDesc>
        <UnitPriceExcl>20.1</UnitPriceExcl>
        <UnitPriceIncl>21.1</UnitPriceIncl>
        <UnitUsed>sample string 11</UnitUsed>
        <UserDefNum01>15.1</UserDefNum01>
        <UserDefNum02>16.1</UserDefNum02>
        <UserDefNum03>17.1</UserDefNum03>
        <UserDefText01>sample string 12</UserDefText01>
        <UserDefText02>sample string 13</UserDefText02>
        <UserDefText03>sample string 14</UserDefText03>
      </DTOSqlDocumentLine>
      <DTOSqlDocumentLine>
        <Barcode>sample string 8</Barcode>
        <Bin>sample string 9</Bin>
        <DiscountPercentage>19</DiscountPercentage>
        <ItemCode>sample string 6</ItemCode>
        <ItemDesc>sample string 7</ItemDesc>
        <LineDocNum>sample string 1</LineDocNum>
        <LineNum>2</LineNum>
        <PastelDocNumber>sample string 22</PastelDocNumber>
        <Physical>true</Physical>
        <Qty>18.1</Qty>
        <SearchType>3</SearchType>
        <StockStatus>23</StockStatus>
        <StoreCode>sample string 4</StoreCode>
        <StoreDesc>sample string 5</StoreDesc>
        <UnitPriceExcl>20.1</UnitPriceExcl>
        <UnitPriceIncl>21.1</UnitPriceIncl>
        <UnitUsed>sample string 11</UnitUsed>
        <UserDefNum01>15.1</UserDefNum01>
        <UserDefNum02>16.1</UserDefNum02>
        <UserDefNum03>17.1</UserDefNum03>
        <UserDefText01>sample string 12</UserDefText01>
        <UserDefText02>sample string 13</UserDefText02>
        <UserDefText03>sample string 14</UserDefText03>
      </DTOSqlDocumentLine>
    </DocumentLines>
    <DocumentNumber>sample string 1</DocumentNumber>
    <DocumentType>2</DocumentType>
    <Fax>sample string 18</Fax>
    <Freight01>sample string 13</Freight01>
    <Message01>sample string 29</Message01>
    <Message02>sample string 30</Message02>
    <Message03>sample string 31</Message03>
    <OrderId>sample string 34</OrderId>
    <OrderNumber>sample string 9</OrderNumber>
    <PastelUserId>1</PastelUserId>
    <PostAddress01>sample string 24</PostAddress01>
    <PostAddress02>sample string 25</PostAddress02>
    <PostAddress03>sample string 26</PostAddress03>
    <PostAddress04>sample string 27</PostAddress04>
    <PostAddress05>sample string 28</PostAddress05>
    <PriceListDesc>sample string 11</PriceListDesc>
    <PriceListId>10</PriceListId>
    <SalesmanCode>sample string 7</SalesmanCode>
    <SalesmanDesc>sample string 8</SalesmanDesc>
    <Ship>sample string 14</Ship>
    <Telephone>sample string 16</Telephone>
    <UserName>sample string 33</UserName>
  </DTOSqlDocument>
</ArrayOfDTOSqlDocument>