EMUN1 ASP.NET

<back to all web services

QueryInvoiceLineRDB

Requires Authentication
Required role:Administrator
The following routes are available for this service:
All Verbs/service/QueryInvoiceLineRDB
QueryInvoiceLineRDB Parameters:
NameParameterData TypeRequiredDescription
Skipqueryint?No
Takequeryint?No
OrderByquerystringNo
OrderByDescquerystringNo
IncludequerystringNo
FieldsquerystringNo
MetaqueryDictionary<string, string>No
InvoiceNumberquerystringNo
InvoiceNumberStartsWithquerystringNo
InvoiceNumberEndsWithquerystringNo
InvoiceNumberContainsquerystringNo
InvoiceNumberLikequerystringNo
InvoiceNumberBetweenquerystring[]No
InvoiceNumberInquerystring[]No
Positionqueryint?No
PositionGreaterThanOrEqualToqueryint?No
PositionGreaterThanqueryint?No
PositionLessThanqueryint?No
PositionLessThanOrEqualToqueryint?No
PositionNotEqualToqueryint?No
PositionBetweenqueryint[]No
PositionInqueryint[]No
ProductIdquerystringNo
ProductIdStartsWithquerystringNo
ProductIdEndsWithquerystringNo
ProductIdContainsquerystringNo
ProductIdLikequerystringNo
ProductIdBetweenquerystring[]No
ProductIdInquerystring[]No
DescriptionquerystringNo
DescriptionStartsWithquerystringNo
DescriptionEndsWithquerystringNo
DescriptionContainsquerystringNo
DescriptionLikequerystringNo
DescriptionBetweenquerystring[]No
DescriptionInquerystring[]No
QtyOrderedquerydouble?No
QtyOrderedGreaterThanOrEqualToquerydouble?No
QtyOrderedGreaterThanquerydouble?No
QtyOrderedLessThanquerydouble?No
QtyOrderedLessThanOrEqualToquerydouble?No
QtyOrderedNotEqualToquerydouble?No
QtyOrderedBetweenquerydouble[]No
QtyOrderedInquerydouble[]No
QtyShippedquerydouble?No
QtyShippedGreaterThanOrEqualToquerydouble?No
QtyShippedGreaterThanquerydouble?No
QtyShippedLessThanquerydouble?No
QtyShippedLessThanOrEqualToquerydouble?No
QtyShippedNotEqualToquerydouble?No
QtyShippedBetweenquerydouble[]No
QtyShippedInquerydouble[]No
QtyBackorderedquerydouble?No
QtyBackorderedGreaterThanOrEqualToquerydouble?No
QtyBackorderedGreaterThanquerydouble?No
QtyBackorderedLessThanquerydouble?No
QtyBackorderedLessThanOrEqualToquerydouble?No
QtyBackorderedNotEqualToquerydouble?No
QtyBackorderedBetweenquerydouble[]No
QtyBackorderedInquerydouble[]No
PricePaidquerydouble?No
PricePaidGreaterThanOrEqualToquerydouble?No
PricePaidGreaterThanquerydouble?No
PricePaidLessThanquerydouble?No
PricePaidLessThanOrEqualToquerydouble?No
PricePaidNotEqualToquerydouble?No
PricePaidBetweenquerydouble[]No
PricePaidInquerydouble[]No
SalesRepquerystringNo
SalesRepStartsWithquerystringNo
SalesRepEndsWithquerystringNo
SalesRepContainsquerystringNo
SalesRepLikequerystringNo
SalesRepBetweenquerystring[]No
SalesRepInquerystring[]No
BrandIdquerystringNo
BrandIdStartsWithquerystringNo
BrandIdEndsWithquerystringNo
BrandIdContainsquerystringNo
BrandIdLikequerystringNo
BrandIdBetweenquerystring[]No
BrandIdInquerystring[]No
ListPricequerydouble?No
ListPriceGreaterThanOrEqualToquerydouble?No
ListPriceGreaterThanquerydouble?No
ListPriceLessThanquerydouble?No
ListPriceLessThanOrEqualToquerydouble?No
ListPriceNotEqualToquerydouble?No
ListPriceBetweenquerydouble[]No
ListPriceInquerydouble[]No
UnitOfMeasurequerystringNo
UnitOfMeasureStartsWithquerystringNo
UnitOfMeasureEndsWithquerystringNo
UnitOfMeasureContainsquerystringNo
UnitOfMeasureLikequerystringNo
UnitOfMeasureBetweenquerystring[]No
UnitOfMeasureInquerystring[]No
BasePricequerydouble?No
BasePriceGreaterThanOrEqualToquerydouble?No
BasePriceGreaterThanquerydouble?No
BasePriceLessThanquerydouble?No
BasePriceLessThanOrEqualToquerydouble?No
BasePriceNotEqualToquerydouble?No
BasePriceBetweenquerydouble[]No
BasePriceInquerydouble[]No
SuperCategoryquerystringNo
SuperCategoryStartsWithquerystringNo
SuperCategoryEndsWithquerystringNo
SuperCategoryContainsquerystringNo
SuperCategoryLikequerystringNo
SuperCategoryBetweenquerystring[]No
SuperCategoryInquerystring[]No
ManufacturerIdquerystringNo
ManufacturerIdStartsWithquerystringNo
ManufacturerIdEndsWithquerystringNo
ManufacturerIdContainsquerystringNo
ManufacturerIdLikequerystringNo
ManufacturerIdBetweenquerystring[]No
ManufacturerIdInquerystring[]No
TrackingNumberquerystringNo
TrackingNumberStartsWithquerystringNo
TrackingNumberEndsWithquerystringNo
TrackingNumberContainsquerystringNo
TrackingNumberLikequerystringNo
TrackingNumberBetweenquerystring[]No
TrackingNumberInquerystring[]No
Custom1STRquerystringNo
Custom1STRStartsWithquerystringNo
Custom1STREndsWithquerystringNo
Custom1STRContainsquerystringNo
Custom1STRLikequerystringNo
Custom1STRBetweenquerystring[]No
Custom1STRInquerystring[]No
Custom2STRquerystringNo
Custom2STRStartsWithquerystringNo
Custom2STREndsWithquerystringNo
Custom2STRContainsquerystringNo
Custom2STRLikequerystringNo
Custom2STRBetweenquerystring[]No
Custom2STRInquerystring[]No
Custom3STRquerystringNo
Custom3STRStartsWithquerystringNo
Custom3STREndsWithquerystringNo
Custom3STRContainsquerystringNo
Custom3STRLikequerystringNo
Custom3STRBetweenquerystring[]No
Custom3STRInquerystring[]No
Custom4STRquerystringNo
Custom4STRStartsWithquerystringNo
Custom4STREndsWithquerystringNo
Custom4STRContainsquerystringNo
Custom4STRLikequerystringNo
Custom4STRBetweenquerystring[]No
Custom4STRInquerystring[]No
Custom5STRquerystringNo
Custom5STRStartsWithquerystringNo
Custom5STREndsWithquerystringNo
Custom5STRContainsquerystringNo
Custom5STRLikequerystringNo
Custom5STRBetweenquerystring[]No
Custom5STRInquerystring[]No
NotesquerystringNo
NotesStartsWithquerystringNo
NotesEndsWithquerystringNo
NotesContainsquerystringNo
NotesLikequerystringNo
NotesBetweenquerystring[]No
NotesInquerystring[]No
CountNamequerystringNo
CountNameStartsWithquerystringNo
CountNameEndsWithquerystringNo
CountNameContainsquerystringNo
CountNameLikequerystringNo
CountNameBetweenquerystring[]No
CountNameInquerystring[]No
ListIdquerystringNo
ListIdStartsWithquerystringNo
ListIdEndsWithquerystringNo
ListIdContainsquerystringNo
ListIdLikequerystringNo
ListIdBetweenquerystring[]No
ListIdInquerystring[]No
Sentquerybool?No
DateSentqueryDateTime?No
DateSentGreaterThanOrEqualToqueryDateTime?No
DateSentGreaterThanqueryDateTime?No
DateSentLessThanqueryDateTime?No
DateSentLessThanOrEqualToqueryDateTime?No
DateSentNotEqualToqueryDateTime?No
DateSentBetweenqueryDateTime[]No
DateSentInqueryDateTime[]No

To override the Content-type in your clients, use the HTTP Accept Header, append the .jsv suffix or ?format=jsv

HTTP + JSV

The following are sample HTTP requests and responses. The placeholders shown need to be replaced with actual values.

POST /service/QueryInvoiceLineRDB HTTP/1.1 
Host: www.bernhardthospitality.com 
Accept: text/jsv
Content-Type: text/jsv
Content-Length: length

{
	skip: 0,
	take: 0,
	orderBy: String,
	orderByDesc: String,
	include: String,
	fields: String,
	meta: 
	{
		String: String
	},
	invoiceNumber: String,
	invoiceNumberStartsWith: String,
	invoiceNumberEndsWith: String,
	invoiceNumberContains: String,
	invoiceNumberLike: String,
	invoiceNumberBetween: 
	[
		String
	],
	invoiceNumberIn: 
	[
		String
	],
	position: 0,
	positionGreaterThanOrEqualTo: 0,
	positionGreaterThan: 0,
	positionLessThan: 0,
	positionLessThanOrEqualTo: 0,
	positionNotEqualTo: 0,
	positionBetween: 
	[
		0
	],
	positionIn: 
	[
		0
	],
	productId: String,
	productIdStartsWith: String,
	productIdEndsWith: String,
	productIdContains: String,
	productIdLike: String,
	productIdBetween: 
	[
		String
	],
	productIdIn: 
	[
		String
	],
	description: String,
	descriptionStartsWith: String,
	descriptionEndsWith: String,
	descriptionContains: String,
	descriptionLike: String,
	descriptionBetween: 
	[
		String
	],
	descriptionIn: 
	[
		String
	],
	qtyOrdered: 0,
	qtyOrderedGreaterThanOrEqualTo: 0,
	qtyOrderedGreaterThan: 0,
	qtyOrderedLessThan: 0,
	qtyOrderedLessThanOrEqualTo: 0,
	qtyOrderedNotEqualTo: 0,
	qtyOrderedBetween: 
	[
		0
	],
	qtyOrderedIn: 
	[
		0
	],
	qtyShipped: 0,
	qtyShippedGreaterThanOrEqualTo: 0,
	qtyShippedGreaterThan: 0,
	qtyShippedLessThan: 0,
	qtyShippedLessThanOrEqualTo: 0,
	qtyShippedNotEqualTo: 0,
	qtyShippedBetween: 
	[
		0
	],
	qtyShippedIn: 
	[
		0
	],
	qtyBackordered: 0,
	qtyBackorderedGreaterThanOrEqualTo: 0,
	qtyBackorderedGreaterThan: 0,
	qtyBackorderedLessThan: 0,
	qtyBackorderedLessThanOrEqualTo: 0,
	qtyBackorderedNotEqualTo: 0,
	qtyBackorderedBetween: 
	[
		0
	],
	qtyBackorderedIn: 
	[
		0
	],
	pricePaid: 0,
	pricePaidGreaterThanOrEqualTo: 0,
	pricePaidGreaterThan: 0,
	pricePaidLessThan: 0,
	pricePaidLessThanOrEqualTo: 0,
	pricePaidNotEqualTo: 0,
	pricePaidBetween: 
	[
		0
	],
	pricePaidIn: 
	[
		0
	],
	salesRep: String,
	salesRepStartsWith: String,
	salesRepEndsWith: String,
	salesRepContains: String,
	salesRepLike: String,
	salesRepBetween: 
	[
		String
	],
	salesRepIn: 
	[
		String
	],
	brandId: String,
	brandIdStartsWith: String,
	brandIdEndsWith: String,
	brandIdContains: String,
	brandIdLike: String,
	brandIdBetween: 
	[
		String
	],
	brandIdIn: 
	[
		String
	],
	listPrice: 0,
	listPriceGreaterThanOrEqualTo: 0,
	listPriceGreaterThan: 0,
	listPriceLessThan: 0,
	listPriceLessThanOrEqualTo: 0,
	listPriceNotEqualTo: 0,
	listPriceBetween: 
	[
		0
	],
	listPriceIn: 
	[
		0
	],
	unitOfMeasure: String,
	unitOfMeasureStartsWith: String,
	unitOfMeasureEndsWith: String,
	unitOfMeasureContains: String,
	unitOfMeasureLike: String,
	unitOfMeasureBetween: 
	[
		String
	],
	unitOfMeasureIn: 
	[
		String
	],
	basePrice: 0,
	basePriceGreaterThanOrEqualTo: 0,
	basePriceGreaterThan: 0,
	basePriceLessThan: 0,
	basePriceLessThanOrEqualTo: 0,
	basePriceNotEqualTo: 0,
	basePriceBetween: 
	[
		0
	],
	basePriceIn: 
	[
		0
	],
	superCategory: String,
	superCategoryStartsWith: String,
	superCategoryEndsWith: String,
	superCategoryContains: String,
	superCategoryLike: String,
	superCategoryBetween: 
	[
		String
	],
	superCategoryIn: 
	[
		String
	],
	manufacturerId: String,
	manufacturerIdStartsWith: String,
	manufacturerIdEndsWith: String,
	manufacturerIdContains: String,
	manufacturerIdLike: String,
	manufacturerIdBetween: 
	[
		String
	],
	manufacturerIdIn: 
	[
		String
	],
	trackingNumber: String,
	trackingNumberStartsWith: String,
	trackingNumberEndsWith: String,
	trackingNumberContains: String,
	trackingNumberLike: String,
	trackingNumberBetween: 
	[
		String
	],
	trackingNumberIn: 
	[
		String
	],
	custom1STR: String,
	custom1STRStartsWith: String,
	custom1STREndsWith: String,
	custom1STRContains: String,
	custom1STRLike: String,
	custom1STRBetween: 
	[
		String
	],
	custom1STRIn: 
	[
		String
	],
	custom2STR: String,
	custom2STRStartsWith: String,
	custom2STREndsWith: String,
	custom2STRContains: String,
	custom2STRLike: String,
	custom2STRBetween: 
	[
		String
	],
	custom2STRIn: 
	[
		String
	],
	custom3STR: String,
	custom3STRStartsWith: String,
	custom3STREndsWith: String,
	custom3STRContains: String,
	custom3STRLike: String,
	custom3STRBetween: 
	[
		String
	],
	custom3STRIn: 
	[
		String
	],
	custom4STR: String,
	custom4STRStartsWith: String,
	custom4STREndsWith: String,
	custom4STRContains: String,
	custom4STRLike: String,
	custom4STRBetween: 
	[
		String
	],
	custom4STRIn: 
	[
		String
	],
	custom5STR: String,
	custom5STRStartsWith: String,
	custom5STREndsWith: String,
	custom5STRContains: String,
	custom5STRLike: String,
	custom5STRBetween: 
	[
		String
	],
	custom5STRIn: 
	[
		String
	],
	notes: String,
	notesStartsWith: String,
	notesEndsWith: String,
	notesContains: String,
	notesLike: String,
	notesBetween: 
	[
		String
	],
	notesIn: 
	[
		String
	],
	countName: String,
	countNameStartsWith: String,
	countNameEndsWith: String,
	countNameContains: String,
	countNameLike: String,
	countNameBetween: 
	[
		String
	],
	countNameIn: 
	[
		String
	],
	listId: String,
	listIdStartsWith: String,
	listIdEndsWith: String,
	listIdContains: String,
	listIdLike: String,
	listIdBetween: 
	[
		String
	],
	listIdIn: 
	[
		String
	],
	sent: False,
	dateSent: 0001-01-01,
	dateSentGreaterThanOrEqualTo: 0001-01-01,
	dateSentGreaterThan: 0001-01-01,
	dateSentLessThan: 0001-01-01,
	dateSentLessThanOrEqualTo: 0001-01-01,
	dateSentNotEqualTo: 0001-01-01,
	dateSentBetween: 
	[
		0001-01-01
	],
	dateSentIn: 
	[
		0001-01-01
	]
}
HTTP/1.1 200 OK
Content-Type: text/jsv
Content-Length: length

[
	{
		invoiceNumber: String,
		position: 0,
		productId: String,
		description: String,
		qtyOrdered: 0,
		qtyShipped: 0,
		qtyBackordered: 0,
		pricePaid: 0,
		salesRep: String,
		brandId: String,
		listPrice: 0,
		unitOfMeasure: String,
		basePrice: 0,
		superCategory: String,
		manufacturerId: String,
		trackingNumber: String,
		custom1STR: String,
		custom2STR: String,
		custom3STR: String,
		custom4STR: String,
		custom5STR: String,
		notes: String,
		countName: String,
		listId: String,
		sent: False,
		dateSent: 0001-01-01
	}
]