POST Inventory/ExcelInsertUpdateJewellerySilverWatch

Request Information

URI Parameters

None.

Body Parameters

ExcelFiles
NameDescriptionTypeAdditional information
ItemName

string

None.

Category

string

None.

SoldReturnDate

string

None.

Price

decimal number

None.

Location

string

None.

Status

string

None.

Description

string

None.

Remark

string

None.

EType

string

None.

WithoutFrame

boolean

None.

ModelNumber

string

None.

Edition

string

None.

Weight

string

None.

Origin

string

None.

IsBoxPresent

integer

None.

IsPaperWork

integer

None.

IsCertification

integer

None.

YearOfManufacturing

string

None.

Condition

string

None.

Circa

string

None.

GrossWeight

string

None.

SubType

string

None.

JewelleryAndSilverID

string

None.

WeightID

string

None.

TypeID

string

None.

SubTypeID

string

None.

TimePeicesAndClockID

string

None.

TimepeicesAndClocksMovementID

string

None.

TimepeicesAndClocksWatchTypeID

string

None.

BrandName

string

None.

WatchDescription

string

None.

Region

string

None.

FurnitureID

string

None.

SizeID

string

None.

FurnitureType

string

None.

FurnitureTypeID

string

None.

Breadth

string

None.

Diameter

string

None.

LogisticLogo

string

None.

TrackingLink

string

None.

WithFrameLength

string

None.

WithFrameBreadth

string

None.

WithFrameHeight

string

None.

WithFrameDiameter

string

None.

IsWithoutFrame

string

None.

SignatureRemarks

string

None.

Series

string

None.

ExcelData

string

None.

InventoryID

string

None.

CategoryID

string

None.

ProductCode

string

None.

ItemImagesURL

string

None.

CertificatesURL

string

None.

Value

string

None.

CurrencyID

string

None.

TagID

string

None.

Title

string

None.

DocumentsURL

string

None.

IsIndividual

integer

None.

DeliveryChallan

string

None.

ClientID

string

None.

EwayNo

string

None.

EwayDate

string

None.

DeliveryChallanDate

string

None.

ConsignmentName

string

None.

ConsignmentAddress

string

None.

ContactNumber

string

None.

DeliveryCompanyID

string

None.

TrackingRemark

string

None.

AttachmentURL

string

None.

LocationID

string

None.

LocationName

string

None.

CategoryName

string

None.

DeliveryCompanyName

string

None.

CurrencyName

string

None.

TagName

string

None.

UserID

string

None.

IsSold

integer

None.

IsActive

integer

None.

ArrImageFilePath

Object

None.

DocumentsURLList

Object

None.

AttachmentURLList

Object

None.

CertificationNumberList

Object

None.

CertificatesURLList

Object

None.

CertificationNumber

string

None.

Year

string

None.

Medium

string

None.

Pan

string

None.

Gst

string

None.

HSN

string

None.

UserTypeID

string

None.

HSNCodeNew

string

None.

QRCodeUrl

string

None.

ConsignorID

string

None.

DealerID

string

None.

DealerName

string

None.

Size

string

None.

SoldPrice

string

None.

SoldOrReturn

string

None.

ClientName

string

None.

CurrencyRate

string

None.

ReturnedPrice

string

None.

ReturnedCurrencyRate

string

None.

ReturnedConvertedPrice

string

None.

InOutStockStatusID

string

None.

Date

date

None.

IsAddItemToProspect

integer

None.

IsInProspect

integer

None.

ArtistName

string

None.

SubCategory

string

None.

SoldDate

date

None.

StyleOfPainting

string

None.

IsWithFrame

boolean

None.

Length

decimal number

None.

Height

decimal number

None.

UniqueId

string

None.

LotNo

string

None.

CompletedStage

string

None.

InCompletedStage

string

None.

BillingAddressLine1

string

None.

BillingAddressLine2

string

None.

BillingCountry

string

None.

BillingState

string

None.

BillingLandMark

string

None.

BillingPinCode

integer

None.

BillingCity

string

None.

DeliveryAddressLine1

string

None.

DeliveryAddressLine2

string

None.

DeliveryCountry

string

None.

DeliveryState

string

None.

DeliveryLandMark

string

None.

DeliveryPinCode

integer

None.

DeliveryCity

string

None.

InvoiceNo

string

None.

Buyer_Pkey_ID

integer

None.

Buyer_InvoiceNo

string

None.

Buyer_Inventory_Id

string

None.

Buyer_LotNo

string

None.

Buyer_CustomerId

integer

None.

Buyer_Name

string

None.

Buyer_Invoice_Date

date

None.

Buyer_Invoice_PaymentStatus

boolean

None.

Buyer_Invoice_ItemName

string

None.

Buyer_HSN_Code

string

None.

Buyer_Invoice_Qty

integer

None.

Buyer_Invoice_Amount

decimal number

None.

Buyer_Invoice_CGST

decimal number

None.

Buyer_Invoice_SGST

decimal number

None.

Buyer_Invoice_IGST

decimal number

None.

Buyer_Invoice_CGST_Per

integer

None.

Buyer_Invoice_SGST_Per

integer

None.

Buyer_Invoice_IGST_Per

integer

None.

Buyer_Invoice_TotalAmount

decimal number

None.

Buyer_Invoice_TaxableAount

decimal number

None.

Buyer_Invoice_TcsAplicable

boolean

None.

Buyer_Invoice_TcsAplicable_Per

integer

None.

Buyer_Invoice_TcsAplicable_Value

decimal number

None.

Buyer_Invoice_PaymentTerms

string

None.

Buyer_BankDetails

string

None.

PaymentDate

date

None.

AucCondReports

Object

None.

PvtRestorationCondReports

Object

None.

InventoryConReports

Object

None.

RFIDTag

string

None.

RackNumber

string

None.

RFIDWriteFlag

string

None.

StatusId

string

None.

TotalCount

integer

None.

Request Formats

application/json, text/json

Sample:
{
  "ItemName": "sample string 1",
  "Category": "sample string 2",
  "SoldReturnDate": "sample string 3",
  "Price": 4.0,
  "Location": "sample string 5",
  "Status": "sample string 6",
  "Description": "sample string 7",
  "Remark": "sample string 8",
  "EType": "sample string 9",
  "WithoutFrame": true,
  "ModelNumber": "sample string 11",
  "Edition": "sample string 12",
  "Weight": "sample string 13",
  "Origin": "sample string 14",
  "IsBoxPresent": 15,
  "IsPaperWork": 16,
  "IsCertification": 17,
  "YearOfManufacturing": "sample string 18",
  "Condition": "sample string 19",
  "Circa": "sample string 20",
  "GrossWeight": "sample string 21",
  "SubType": "sample string 22",
  "JewelleryAndSilverID": "sample string 23",
  "WeightID": "sample string 24",
  "TypeID": "sample string 25",
  "SubTypeID": "sample string 26",
  "TimePeicesAndClockID": "sample string 27",
  "TimepeicesAndClocksMovementID": "sample string 28",
  "TimepeicesAndClocksWatchTypeID": "sample string 29",
  "BrandName": "sample string 30",
  "WatchDescription": "sample string 31",
  "Region": "sample string 32",
  "FurnitureID": "sample string 33",
  "SizeID": "sample string 34",
  "FurnitureType": "sample string 35",
  "FurnitureTypeID": "sample string 36",
  "Breadth": "sample string 37",
  "Diameter": "sample string 38",
  "LogisticLogo": "sample string 39",
  "TrackingLink": "sample string 40",
  "WithFrameLength": "sample string 41",
  "WithFrameBreadth": "sample string 42",
  "WithFrameHeight": "sample string 43",
  "WithFrameDiameter": "sample string 44",
  "IsWithoutFrame": "sample string 45",
  "SignatureRemarks": "sample string 46",
  "Series": "sample string 47",
  "ExcelData": "sample string 48",
  "InventoryID": "sample string 49",
  "CategoryID": "sample string 50",
  "ProductCode": "sample string 51",
  "ItemImagesURL": "sample string 52",
  "CertificatesURL": "sample string 53",
  "Value": "sample string 54",
  "CurrencyID": "sample string 55",
  "TagID": "sample string 56",
  "Title": "sample string 57",
  "DocumentsURL": "sample string 58",
  "IsIndividual": 59,
  "DeliveryChallan": "sample string 60",
  "ClientID": "sample string 61",
  "EwayNo": "sample string 62",
  "EwayDate": "sample string 63",
  "DeliveryChallanDate": "sample string 64",
  "ConsignmentName": "sample string 65",
  "ConsignmentAddress": "sample string 66",
  "ContactNumber": "sample string 67",
  "DeliveryCompanyID": "sample string 68",
  "TrackingRemark": "sample string 69",
  "AttachmentURL": "sample string 70",
  "LocationID": "sample string 71",
  "LocationName": "sample string 72",
  "CategoryName": "sample string 73",
  "DeliveryCompanyName": "sample string 74",
  "CurrencyName": "sample string 75",
  "TagName": "sample string 76",
  "UserID": "sample string 77",
  "IsSold": 78,
  "IsActive": 79,
  "ArrImageFilePath": {},
  "DocumentsURLList": {},
  "AttachmentURLList": {},
  "CertificationNumberList": {},
  "CertificatesURLList": {},
  "CertificationNumber": "sample string 85",
  "Year": "sample string 86",
  "Medium": "sample string 87",
  "Pan": "sample string 88",
  "Gst": "sample string 89",
  "HSN": "sample string 90",
  "UserTypeID": "sample string 91",
  "HSNCodeNew": "sample string 92",
  "QRCodeUrl": "sample string 93",
  "ConsignorID": "sample string 94",
  "DealerID": "sample string 95",
  "DealerName": "sample string 96",
  "Size": "sample string 97",
  "SoldPrice": "sample string 98",
  "SoldOrReturn": "sample string 99",
  "ClientName": "sample string 100",
  "CurrencyRate": "sample string 101",
  "ReturnedPrice": "sample string 102",
  "ReturnedCurrencyRate": "sample string 103",
  "ReturnedConvertedPrice": "sample string 104",
  "InOutStockStatusID": "sample string 105",
  "Date": "2025-01-10T20:37:35.7437229+05:30",
  "IsAddItemToProspect": 106,
  "IsInProspect": 107,
  "ArtistName": "sample string 108",
  "SubCategory": "sample string 109",
  "SoldDate": "2025-01-10T20:37:35.7437229+05:30",
  "StyleOfPainting": "sample string 110",
  "IsWithFrame": true,
  "Length": 112.0,
  "Height": 113.0,
  "UniqueId": "sample string 114",
  "LotNo": "sample string 115",
  "CompletedStage": "sample string 116",
  "InCompletedStage": "sample string 117",
  "BillingAddressLine1": "sample string 118",
  "BillingAddressLine2": "sample string 119",
  "BillingCountry": "sample string 120",
  "BillingState": "sample string 121",
  "BillingLandMark": "sample string 122",
  "BillingPinCode": 1,
  "BillingCity": "sample string 123",
  "DeliveryAddressLine1": "sample string 124",
  "DeliveryAddressLine2": "sample string 125",
  "DeliveryCountry": "sample string 126",
  "DeliveryState": "sample string 127",
  "DeliveryLandMark": "sample string 128",
  "DeliveryPinCode": 1,
  "DeliveryCity": "sample string 129",
  "InvoiceNo": "sample string 130",
  "Buyer_Pkey_ID": 131,
  "Buyer_InvoiceNo": "sample string 132",
  "Buyer_Inventory_Id": "sample string 133",
  "Buyer_LotNo": "sample string 134",
  "Buyer_CustomerId": 1,
  "Buyer_Name": "sample string 135",
  "Buyer_Invoice_Date": "2025-01-10T20:37:35.7437229+05:30",
  "Buyer_Invoice_PaymentStatus": true,
  "Buyer_Invoice_ItemName": "sample string 136",
  "Buyer_HSN_Code": "sample string 137",
  "Buyer_Invoice_Qty": 1,
  "Buyer_Invoice_Amount": 1.0,
  "Buyer_Invoice_CGST": 1.0,
  "Buyer_Invoice_SGST": 1.0,
  "Buyer_Invoice_IGST": 1.0,
  "Buyer_Invoice_CGST_Per": 1,
  "Buyer_Invoice_SGST_Per": 1,
  "Buyer_Invoice_IGST_Per": 1,
  "Buyer_Invoice_TotalAmount": 1.0,
  "Buyer_Invoice_TaxableAount": 1.0,
  "Buyer_Invoice_TcsAplicable": true,
  "Buyer_Invoice_TcsAplicable_Per": 1,
  "Buyer_Invoice_TcsAplicable_Value": 1.0,
  "Buyer_Invoice_PaymentTerms": "sample string 138",
  "Buyer_BankDetails": "sample string 139",
  "PaymentDate": "2025-01-10T20:37:35.7437229+05:30",
  "AucCondReports": {},
  "PvtRestorationCondReports": {},
  "InventoryConReports": {},
  "RFIDTag": "sample string 143",
  "RackNumber": "sample string 144",
  "RFIDWriteFlag": "sample string 145",
  "StatusId": "sample string 146",
  "TotalCount": 147
}

application/xml, text/xml

Sample:
<ExcelFiles xmlns:i="http://www.w3.org/2001/XMLSchema-instance" xmlns="http://schemas.datacontract.org/2004/07/AstaGuru.Models">
  <ArrImageFilePath />
  <ArtistName>sample string 108</ArtistName>
  <AttachmentURL>sample string 70</AttachmentURL>
  <AttachmentURLList />
  <AucCondReports />
  <BillingAddressLine1>sample string 118</BillingAddressLine1>
  <BillingAddressLine2>sample string 119</BillingAddressLine2>
  <BillingCity>sample string 123</BillingCity>
  <BillingCountry>sample string 120</BillingCountry>
  <BillingLandMark>sample string 122</BillingLandMark>
  <BillingPinCode>1</BillingPinCode>
  <BillingState>sample string 121</BillingState>
  <Buyer_BankDetails>sample string 139</Buyer_BankDetails>
  <Buyer_CustomerId>1</Buyer_CustomerId>
  <Buyer_HSN_Code>sample string 137</Buyer_HSN_Code>
  <Buyer_Inventory_Id>sample string 133</Buyer_Inventory_Id>
  <Buyer_InvoiceNo>sample string 132</Buyer_InvoiceNo>
  <Buyer_Invoice_Amount>1</Buyer_Invoice_Amount>
  <Buyer_Invoice_CGST>1</Buyer_Invoice_CGST>
  <Buyer_Invoice_CGST_Per>1</Buyer_Invoice_CGST_Per>
  <Buyer_Invoice_Date>2025-01-10T20:37:35.7437229+05:30</Buyer_Invoice_Date>
  <Buyer_Invoice_IGST>1</Buyer_Invoice_IGST>
  <Buyer_Invoice_IGST_Per>1</Buyer_Invoice_IGST_Per>
  <Buyer_Invoice_ItemName>sample string 136</Buyer_Invoice_ItemName>
  <Buyer_Invoice_PaymentStatus>true</Buyer_Invoice_PaymentStatus>
  <Buyer_Invoice_PaymentTerms>sample string 138</Buyer_Invoice_PaymentTerms>
  <Buyer_Invoice_Qty>1</Buyer_Invoice_Qty>
  <Buyer_Invoice_SGST>1</Buyer_Invoice_SGST>
  <Buyer_Invoice_SGST_Per>1</Buyer_Invoice_SGST_Per>
  <Buyer_Invoice_TaxableAount>1</Buyer_Invoice_TaxableAount>
  <Buyer_Invoice_TcsAplicable>true</Buyer_Invoice_TcsAplicable>
  <Buyer_Invoice_TcsAplicable_Per>1</Buyer_Invoice_TcsAplicable_Per>
  <Buyer_Invoice_TcsAplicable_Value>1</Buyer_Invoice_TcsAplicable_Value>
  <Buyer_Invoice_TotalAmount>1</Buyer_Invoice_TotalAmount>
  <Buyer_LotNo>sample string 134</Buyer_LotNo>
  <Buyer_Name>sample string 135</Buyer_Name>
  <Buyer_Pkey_ID>131</Buyer_Pkey_ID>
  <CategoryID>sample string 50</CategoryID>
  <CategoryName>sample string 73</CategoryName>
  <CertificatesURL>sample string 53</CertificatesURL>
  <CertificatesURLList />
  <CertificationNumber>sample string 85</CertificationNumber>
  <CertificationNumberList />
  <ClientID>sample string 61</ClientID>
  <ClientName>sample string 100</ClientName>
  <CompletedStage>sample string 116</CompletedStage>
  <ConsignmentAddress>sample string 66</ConsignmentAddress>
  <ConsignmentName>sample string 65</ConsignmentName>
  <ConsignorID>sample string 94</ConsignorID>
  <ContactNumber>sample string 67</ContactNumber>
  <CurrencyID>sample string 55</CurrencyID>
  <CurrencyName>sample string 75</CurrencyName>
  <CurrencyRate>sample string 101</CurrencyRate>
  <Date>2025-01-10T20:37:35.7437229+05:30</Date>
  <DealerID>sample string 95</DealerID>
  <DealerName>sample string 96</DealerName>
  <DeliveryAddressLine1>sample string 124</DeliveryAddressLine1>
  <DeliveryAddressLine2>sample string 125</DeliveryAddressLine2>
  <DeliveryChallan>sample string 60</DeliveryChallan>
  <DeliveryChallanDate>sample string 64</DeliveryChallanDate>
  <DeliveryCity>sample string 129</DeliveryCity>
  <DeliveryCompanyID>sample string 68</DeliveryCompanyID>
  <DeliveryCompanyName>sample string 74</DeliveryCompanyName>
  <DeliveryCountry>sample string 126</DeliveryCountry>
  <DeliveryLandMark>sample string 128</DeliveryLandMark>
  <DeliveryPinCode>1</DeliveryPinCode>
  <DeliveryState>sample string 127</DeliveryState>
  <DocumentsURL>sample string 58</DocumentsURL>
  <DocumentsURLList />
  <EwayDate>sample string 63</EwayDate>
  <EwayNo>sample string 62</EwayNo>
  <Gst>sample string 89</Gst>
  <HSN>sample string 90</HSN>
  <HSNCodeNew>sample string 92</HSNCodeNew>
  <Height>113</Height>
  <InCompletedStage>sample string 117</InCompletedStage>
  <InOutStockStatusID>sample string 105</InOutStockStatusID>
  <InventoryConReports />
  <InventoryID>sample string 49</InventoryID>
  <InvoiceNo>sample string 130</InvoiceNo>
  <IsActive>79</IsActive>
  <IsAddItemToProspect>106</IsAddItemToProspect>
  <IsInProspect>107</IsInProspect>
  <IsIndividual>59</IsIndividual>
  <IsSold>78</IsSold>
  <IsWithFrame>true</IsWithFrame>
  <ItemImagesURL>sample string 52</ItemImagesURL>
  <Length>112</Length>
  <LocationID>sample string 71</LocationID>
  <LocationName>sample string 72</LocationName>
  <LotNo>sample string 115</LotNo>
  <Medium>sample string 87</Medium>
  <Pan>sample string 88</Pan>
  <PaymentDate>2025-01-10T20:37:35.7437229+05:30</PaymentDate>
  <ProductCode>sample string 51</ProductCode>
  <PvtRestorationCondReports />
  <QRCodeUrl>sample string 93</QRCodeUrl>
  <RFIDTag>sample string 143</RFIDTag>
  <RFIDWriteFlag>sample string 145</RFIDWriteFlag>
  <RackNumber>sample string 144</RackNumber>
  <ReturnedConvertedPrice>sample string 104</ReturnedConvertedPrice>
  <ReturnedCurrencyRate>sample string 103</ReturnedCurrencyRate>
  <ReturnedPrice>sample string 102</ReturnedPrice>
  <Size>sample string 97</Size>
  <SoldDate>2025-01-10T20:37:35.7437229+05:30</SoldDate>
  <SoldOrReturn>sample string 99</SoldOrReturn>
  <SoldPrice>sample string 98</SoldPrice>
  <StatusId>sample string 146</StatusId>
  <StyleOfPainting>sample string 110</StyleOfPainting>
  <SubCategory>sample string 109</SubCategory>
  <TagID>sample string 56</TagID>
  <TagName>sample string 76</TagName>
  <Title>sample string 57</Title>
  <TotalCount>147</TotalCount>
  <TrackingRemark>sample string 69</TrackingRemark>
  <UniqueId>sample string 114</UniqueId>
  <UserID>sample string 77</UserID>
  <UserTypeID>sample string 91</UserTypeID>
  <Value>sample string 54</Value>
  <Year>sample string 86</Year>
  <BrandName>sample string 30</BrandName>
  <Breadth>sample string 37</Breadth>
  <Category>sample string 2</Category>
  <Circa>sample string 20</Circa>
  <Condition>sample string 19</Condition>
  <Description>sample string 7</Description>
  <Diameter>sample string 38</Diameter>
  <EType>sample string 9</EType>
  <Edition>sample string 12</Edition>
  <ExcelData>sample string 48</ExcelData>
  <FurnitureID>sample string 33</FurnitureID>
  <FurnitureType>sample string 35</FurnitureType>
  <FurnitureTypeID>sample string 36</FurnitureTypeID>
  <GrossWeight>sample string 21</GrossWeight>
  <IsBoxPresent>15</IsBoxPresent>
  <IsCertification>17</IsCertification>
  <IsPaperWork>16</IsPaperWork>
  <IsWithoutFrame>sample string 45</IsWithoutFrame>
  <ItemName>sample string 1</ItemName>
  <JewelleryAndSilverID>sample string 23</JewelleryAndSilverID>
  <Location>sample string 5</Location>
  <LogisticLogo>sample string 39</LogisticLogo>
  <ModelNumber>sample string 11</ModelNumber>
  <Origin>sample string 14</Origin>
  <Price>4</Price>
  <Region>sample string 32</Region>
  <Remark>sample string 8</Remark>
  <Series>sample string 47</Series>
  <SignatureRemarks>sample string 46</SignatureRemarks>
  <SizeID>sample string 34</SizeID>
  <SoldReturnDate>sample string 3</SoldReturnDate>
  <Status>sample string 6</Status>
  <SubType>sample string 22</SubType>
  <SubTypeID>sample string 26</SubTypeID>
  <TimePeicesAndClockID>sample string 27</TimePeicesAndClockID>
  <TimepeicesAndClocksMovementID>sample string 28</TimepeicesAndClocksMovementID>
  <TimepeicesAndClocksWatchTypeID>sample string 29</TimepeicesAndClocksWatchTypeID>
  <TrackingLink>sample string 40</TrackingLink>
  <TypeID>sample string 25</TypeID>
  <WatchDescription>sample string 31</WatchDescription>
  <Weight>sample string 13</Weight>
  <WeightID>sample string 24</WeightID>
  <WithFrameBreadth>sample string 42</WithFrameBreadth>
  <WithFrameDiameter>sample string 44</WithFrameDiameter>
  <WithFrameHeight>sample string 43</WithFrameHeight>
  <WithFrameLength>sample string 41</WithFrameLength>
  <WithoutFrame>true</WithoutFrame>
  <YearOfManufacturing>sample string 18</YearOfManufacturing>
</ExcelFiles>

application/x-www-form-urlencoded

Sample:

Sample not available.

Response Information

Resource Description

IHttpActionResult

None.

Response Formats

application/json, text/json, application/xml, text/xml

Sample:

Sample not available.