GET api/projects/{projectId}/worksheets

Get project worksheets

Request Information

URI Parameters

NameDescriptionTypeAdditional information
projectId

Project ID

 string

Required

Body Parameters

None.

Response Information

Resource Description

the worksheets

Collection of CloudWorksheet
NameDescriptionTypeAdditional information
Name

Name

 string

None.
Type

Type

 string

None.
TaxName

Tax Name

 string

None.
TaxRate

Tax Rate

 string

None.
TotalSalesAmount

Total Sales Amount

 string

None.
TotalCostAmount

Total Cost Amount

 string

None.
TotalTaxAmount

Total Tax Amount

 string

None.
TotalSalesTaxAmount

Total Sales Tax Amount

 string

None.
BillTo

Bill To

 string

None.
ShipTo

Ship To

 string

None.
CurrencySymbol

Currency

 string

None.
CurrencySymbolOnLeft

Currency On Left

 boolean

None.
IsUseTax

Use Tax

 boolean

None.
FreightAmount

Freight Amount

 string

None.
DiscountAmount

Discount Amount

 string

None.
DepositAmount

Deposit Amount

 string

None.
Instruction

Instruction

 string

None.
Items

Worksheet Items

 Collection of CloudWorksheetItem

None.

Response Formats

application/json, text/json

Sample: 
[
  {
    "Name": "sample string 1",
    "Type": "sample string 2",
    "TaxName": "sample string 3",
    "TaxRate": "sample string 4",
    "TotalSalesAmount": "sample string 5",
    "TotalCostAmount": "sample string 6",
    "TotalTaxAmount": "sample string 7",
    "TotalSalesTaxAmount": "sample string 8",
    "BillTo": "sample string 9",
    "ShipTo": "sample string 10",
    "CurrencySymbol": "sample string 11",
    "CurrencySymbolOnLeft": true,
    "IsUseTax": true,
    "FreightAmount": "sample string 14",
    "DiscountAmount": "sample string 15",
    "DepositAmount": "sample string 16",
    "Instruction": "sample string 17",
    "Items": [
      {
        "ProdCategory": "sample string 25",
        "FloorName": "sample string 1",
        "RoomName": "sample string 2",
        "ItemName": "sample string 3",
        "TradeType": "sample string 26",
        "Description": "sample string 4",
        "SourceShapes": "sample string 7",
        "Vendor": "sample string 5",
        "VendorSku": "sample string 6",
        "Unit": "sample string 8",
        "OriginalUnit": "sample string 27",
        "Qty": "sample string 9",
        "OriginalQty": "sample string 28",
        "ExtraQty": "sample string 10",
        "CostPrice": "sample string 11",
        "SalesPrice": "sample string 12",
        "Markup": "sample string 13",
        "ProfitMargin": "sample string 14",
        "CostAmount": "sample string 15",
        "SalesAmount": "sample string 16",
        "IsLabor": true,
        "Taxable": true,
        "TaxAmount": "sample string 19",
        "SalesTaxAmount": "sample string 20",
        "AssignUnitQty": "sample string 21",
        "WasteRatio": "sample string 22",
        "WasteAddon": "sample string 23",
        "BasePerimeter": "sample string 24"
      },
      {
        "ProdCategory": "sample string 25",
        "FloorName": "sample string 1",
        "RoomName": "sample string 2",
        "ItemName": "sample string 3",
        "TradeType": "sample string 26",
        "Description": "sample string 4",
        "SourceShapes": "sample string 7",
        "Vendor": "sample string 5",
        "VendorSku": "sample string 6",
        "Unit": "sample string 8",
        "OriginalUnit": "sample string 27",
        "Qty": "sample string 9",
        "OriginalQty": "sample string 28",
        "ExtraQty": "sample string 10",
        "CostPrice": "sample string 11",
        "SalesPrice": "sample string 12",
        "Markup": "sample string 13",
        "ProfitMargin": "sample string 14",
        "CostAmount": "sample string 15",
        "SalesAmount": "sample string 16",
        "IsLabor": true,
        "Taxable": true,
        "TaxAmount": "sample string 19",
        "SalesTaxAmount": "sample string 20",
        "AssignUnitQty": "sample string 21",
        "WasteRatio": "sample string 22",
        "WasteAddon": "sample string 23",
        "BasePerimeter": "sample string 24"
      }
    ]
  },
  {
    "Name": "sample string 1",
    "Type": "sample string 2",
    "TaxName": "sample string 3",
    "TaxRate": "sample string 4",
    "TotalSalesAmount": "sample string 5",
    "TotalCostAmount": "sample string 6",
    "TotalTaxAmount": "sample string 7",
    "TotalSalesTaxAmount": "sample string 8",
    "BillTo": "sample string 9",
    "ShipTo": "sample string 10",
    "CurrencySymbol": "sample string 11",
    "CurrencySymbolOnLeft": true,
    "IsUseTax": true,
    "FreightAmount": "sample string 14",
    "DiscountAmount": "sample string 15",
    "DepositAmount": "sample string 16",
    "Instruction": "sample string 17",
    "Items": [
      {
        "ProdCategory": "sample string 25",
        "FloorName": "sample string 1",
        "RoomName": "sample string 2",
        "ItemName": "sample string 3",
        "TradeType": "sample string 26",
        "Description": "sample string 4",
        "SourceShapes": "sample string 7",
        "Vendor": "sample string 5",
        "VendorSku": "sample string 6",
        "Unit": "sample string 8",
        "OriginalUnit": "sample string 27",
        "Qty": "sample string 9",
        "OriginalQty": "sample string 28",
        "ExtraQty": "sample string 10",
        "CostPrice": "sample string 11",
        "SalesPrice": "sample string 12",
        "Markup": "sample string 13",
        "ProfitMargin": "sample string 14",
        "CostAmount": "sample string 15",
        "SalesAmount": "sample string 16",
        "IsLabor": true,
        "Taxable": true,
        "TaxAmount": "sample string 19",
        "SalesTaxAmount": "sample string 20",
        "AssignUnitQty": "sample string 21",
        "WasteRatio": "sample string 22",
        "WasteAddon": "sample string 23",
        "BasePerimeter": "sample string 24"
      },
      {
        "ProdCategory": "sample string 25",
        "FloorName": "sample string 1",
        "RoomName": "sample string 2",
        "ItemName": "sample string 3",
        "TradeType": "sample string 26",
        "Description": "sample string 4",
        "SourceShapes": "sample string 7",
        "Vendor": "sample string 5",
        "VendorSku": "sample string 6",
        "Unit": "sample string 8",
        "OriginalUnit": "sample string 27",
        "Qty": "sample string 9",
        "OriginalQty": "sample string 28",
        "ExtraQty": "sample string 10",
        "CostPrice": "sample string 11",
        "SalesPrice": "sample string 12",
        "Markup": "sample string 13",
        "ProfitMargin": "sample string 14",
        "CostAmount": "sample string 15",
        "SalesAmount": "sample string 16",
        "IsLabor": true,
        "Taxable": true,
        "TaxAmount": "sample string 19",
        "SalesTaxAmount": "sample string 20",
        "AssignUnitQty": "sample string 21",
        "WasteRatio": "sample string 22",
        "WasteAddon": "sample string 23",
        "BasePerimeter": "sample string 24"
      }
    ]
  }
]

application/xml, text/xml

Sample: 
<ArrayOfCloudWorksheet>
  <CloudWorksheet>
    <Name>sample string 1</Name>
    <Type>sample string 2</Type>
    <TaxName>sample string 3</TaxName>
    <TaxRate>sample string 4</TaxRate>
    <TotalSalesAmount>sample string 5</TotalSalesAmount>
    <TotalCostAmount>sample string 6</TotalCostAmount>
    <TotalTaxAmount>sample string 7</TotalTaxAmount>
    <TotalSalesTaxAmount>sample string 8</TotalSalesTaxAmount>
    <BillTo>sample string 9</BillTo>
    <ShipTo>sample string 10</ShipTo>
    <CurrencySymbol>sample string 11</CurrencySymbol>
    <CurrencySymbolOnLeft>true</CurrencySymbolOnLeft>
    <IsUseTax>true</IsUseTax>
    <FreightAmount>sample string 14</FreightAmount>
    <DiscountAmount>sample string 15</DiscountAmount>
    <DepositAmount>sample string 16</DepositAmount>
    <Instruction>sample string 17</Instruction>
    <Items>
      <CloudWorksheetItem>
        <FloorName>sample string 1</FloorName>
        <RoomName>sample string 2</RoomName>
        <ItemName>sample string 3</ItemName>
        <Description>sample string 4</Description>
        <Vendor>sample string 5</Vendor>
        <VendorSku>sample string 6</VendorSku>
        <SourceShapes>sample string 7</SourceShapes>
        <Unit>sample string 8</Unit>
        <Qty>sample string 9</Qty>
        <ExtraQty>sample string 10</ExtraQty>
        <CostPrice>sample string 11</CostPrice>
        <SalesPrice>sample string 12</SalesPrice>
        <Markup>sample string 13</Markup>
        <ProfitMargin>sample string 14</ProfitMargin>
        <CostAmount>sample string 15</CostAmount>
        <SalesAmount>sample string 16</SalesAmount>
        <IsLabor>true</IsLabor>
        <Taxable>true</Taxable>
        <TaxAmount>sample string 19</TaxAmount>
        <SalesTaxAmount>sample string 20</SalesTaxAmount>
        <AssignUnitQty>sample string 21</AssignUnitQty>
        <WasteRatio>sample string 22</WasteRatio>
        <WasteAddon>sample string 23</WasteAddon>
        <BasePerimeter>sample string 24</BasePerimeter>
        <ProdCategory>sample string 25</ProdCategory>
        <TradeType>sample string 26</TradeType>
        <OriginalUnit>sample string 27</OriginalUnit>
        <OriginalQty>sample string 28</OriginalQty>
      </CloudWorksheetItem>
      <CloudWorksheetItem>
        <FloorName>sample string 1</FloorName>
        <RoomName>sample string 2</RoomName>
        <ItemName>sample string 3</ItemName>
        <Description>sample string 4</Description>
        <Vendor>sample string 5</Vendor>
        <VendorSku>sample string 6</VendorSku>
        <SourceShapes>sample string 7</SourceShapes>
        <Unit>sample string 8</Unit>
        <Qty>sample string 9</Qty>
        <ExtraQty>sample string 10</ExtraQty>
        <CostPrice>sample string 11</CostPrice>
        <SalesPrice>sample string 12</SalesPrice>
        <Markup>sample string 13</Markup>
        <ProfitMargin>sample string 14</ProfitMargin>
        <CostAmount>sample string 15</CostAmount>
        <SalesAmount>sample string 16</SalesAmount>
        <IsLabor>true</IsLabor>
        <Taxable>true</Taxable>
        <TaxAmount>sample string 19</TaxAmount>
        <SalesTaxAmount>sample string 20</SalesTaxAmount>
        <AssignUnitQty>sample string 21</AssignUnitQty>
        <WasteRatio>sample string 22</WasteRatio>
        <WasteAddon>sample string 23</WasteAddon>
        <BasePerimeter>sample string 24</BasePerimeter>
        <ProdCategory>sample string 25</ProdCategory>
        <TradeType>sample string 26</TradeType>
        <OriginalUnit>sample string 27</OriginalUnit>
        <OriginalQty>sample string 28</OriginalQty>
      </CloudWorksheetItem>
    </Items>
  </CloudWorksheet>
  <CloudWorksheet>
    <Name>sample string 1</Name>
    <Type>sample string 2</Type>
    <TaxName>sample string 3</TaxName>
    <TaxRate>sample string 4</TaxRate>
    <TotalSalesAmount>sample string 5</TotalSalesAmount>
    <TotalCostAmount>sample string 6</TotalCostAmount>
    <TotalTaxAmount>sample string 7</TotalTaxAmount>
    <TotalSalesTaxAmount>sample string 8</TotalSalesTaxAmount>
    <BillTo>sample string 9</BillTo>
    <ShipTo>sample string 10</ShipTo>
    <CurrencySymbol>sample string 11</CurrencySymbol>
    <CurrencySymbolOnLeft>true</CurrencySymbolOnLeft>
    <IsUseTax>true</IsUseTax>
    <FreightAmount>sample string 14</FreightAmount>
    <DiscountAmount>sample string 15</DiscountAmount>
    <DepositAmount>sample string 16</DepositAmount>
    <Instruction>sample string 17</Instruction>
    <Items>
      <CloudWorksheetItem>
        <FloorName>sample string 1</FloorName>
        <RoomName>sample string 2</RoomName>
        <ItemName>sample string 3</ItemName>
        <Description>sample string 4</Description>
        <Vendor>sample string 5</Vendor>
        <VendorSku>sample string 6</VendorSku>
        <SourceShapes>sample string 7</SourceShapes>
        <Unit>sample string 8</Unit>
        <Qty>sample string 9</Qty>
        <ExtraQty>sample string 10</ExtraQty>
        <CostPrice>sample string 11</CostPrice>
        <SalesPrice>sample string 12</SalesPrice>
        <Markup>sample string 13</Markup>
        <ProfitMargin>sample string 14</ProfitMargin>
        <CostAmount>sample string 15</CostAmount>
        <SalesAmount>sample string 16</SalesAmount>
        <IsLabor>true</IsLabor>
        <Taxable>true</Taxable>
        <TaxAmount>sample string 19</TaxAmount>
        <SalesTaxAmount>sample string 20</SalesTaxAmount>
        <AssignUnitQty>sample string 21</AssignUnitQty>
        <WasteRatio>sample string 22</WasteRatio>
        <WasteAddon>sample string 23</WasteAddon>
        <BasePerimeter>sample string 24</BasePerimeter>
        <ProdCategory>sample string 25</ProdCategory>
        <TradeType>sample string 26</TradeType>
        <OriginalUnit>sample string 27</OriginalUnit>
        <OriginalQty>sample string 28</OriginalQty>
      </CloudWorksheetItem>
      <CloudWorksheetItem>
        <FloorName>sample string 1</FloorName>
        <RoomName>sample string 2</RoomName>
        <ItemName>sample string 3</ItemName>
        <Description>sample string 4</Description>
        <Vendor>sample string 5</Vendor>
        <VendorSku>sample string 6</VendorSku>
        <SourceShapes>sample string 7</SourceShapes>
        <Unit>sample string 8</Unit>
        <Qty>sample string 9</Qty>
        <ExtraQty>sample string 10</ExtraQty>
        <CostPrice>sample string 11</CostPrice>
        <SalesPrice>sample string 12</SalesPrice>
        <Markup>sample string 13</Markup>
        <ProfitMargin>sample string 14</ProfitMargin>
        <CostAmount>sample string 15</CostAmount>
        <SalesAmount>sample string 16</SalesAmount>
        <IsLabor>true</IsLabor>
        <Taxable>true</Taxable>
        <TaxAmount>sample string 19</TaxAmount>
        <SalesTaxAmount>sample string 20</SalesTaxAmount>
        <AssignUnitQty>sample string 21</AssignUnitQty>
        <WasteRatio>sample string 22</WasteRatio>
        <WasteAddon>sample string 23</WasteAddon>
        <BasePerimeter>sample string 24</BasePerimeter>
        <ProdCategory>sample string 25</ProdCategory>
        <TradeType>sample string 26</TradeType>
        <OriginalUnit>sample string 27</OriginalUnit>
        <OriginalQty>sample string 28</OriginalQty>
      </CloudWorksheetItem>
    </Items>
  </CloudWorksheet>
</ArrayOfCloudWorksheet>