ExportDataSheets

Export Data Sheets.

Overview

Url	api/public/FluentisErp/QY/DataSheet/ExportDataSheets
HTTP Method	POST
Method Type	Export
Fluentis Object	Fluentis.FluentisErp.Core.QY.DataSheet.FSDataSheet

Request parameters

Parameter	Type	Is Required	Description
DataSheetTypeCode	string	No	If present, filter data sheets by the specified data sheet type code.
Code	string	No	If present, filter data sheets by the specified code.
Revision	integer	No	If present, filter data sheets by the specified revision number.
Description	string	No	If present, filter data sheets by the specified description.
TradeName	string	No	If present, filter data sheets by the specified trade name.
AccountCode	string	No	If present, filter data sheets by the specified account code.
AccountDetailCode	string	No	If present, filter data sheets by the specified account detail code.
AccountDescription	string	No	If present, filter data sheets by the specified account description.
EmployeeCode	string	No	If present, filter data sheets by the specified employee code.
EmployeeName	string	No	If present, filter data sheets by the specified employee name.
EmployeeSurname	string	No	If present, filter data sheets by the specified employee surname.
IsValid	boolean	No	If present, filter data sheets by whether they are valid.
IsNotValid	boolean	No	If present, filter data sheets by whether they are
FromStartDate	date	No	If present, filter data sheets with start dates greater than or equal to the specified date.
ToStartDate	date	No	If present, filter data sheets with start dates less than or equal to the specified date.
FromEndDate	date	No	If present, filter data sheets with end dates greater than or equal to the specified date.
ToEndDate	date	No	If present, filter data sheets with end dates less than or equal to the specified date.
FromRequiredDate	date	No	If present, filter data sheets with required dates greater than or equal to the specified date.
ToRequiredDate	date	No	If present, filter data sheets with required dates less than or equal to the specified date.
OrigDataSheetDataSheetTypeCode	string	No	If present, filter data sheets by the specified original data sheet type code.
OrigDataSheetCode	string	No	If present, filter data sheets by the specified original data sheet code.
OrigDataSheetRevision	integer	No	If present, filter data sheets by the specified original data sheet revision number.
OrigDataSheetDescription	string	No	If present, filter data sheets by the specified original data sheet description.
DataSheetCustomerFilter	DataSheetCustomerFilter	No	If present, filter data sheets by customer-related criteria.
DataSheetItemFilter	DataSheetItemFilter	No	If present, filter data sheets by item-related criteria.
DataSheetPropertyFilter	DataSheetPropertyFilter	No	If present, filter data sheets by property-related criteria.

DataSheetCustomerFilter properties

Parameter	Type	Is Required	Description
ExportFilters	string	No	Generic string filter expression for filtering customer data.
AccountCode	string	No	If present, filter customer data by the specified account code.
AccountDetailCode	string	No	If present, filter customer data by the specified account detail code.
AccountDescription	string	No	If present, filter customer data by the specified account description.

DataSheetItemFilter properties

Parameter	Type	Is Required	Description
ExportFilters	string	No	Generic string filter expression for filtering item data.
ItemClassCode	string	No	If present, filter item data by the specified item class code.
ItemCode	string	No	If present, filter item data by the specified item code.
ItemDescription	string	No	If present, filter item data by the specified item description.
ItemVariantCode	string	No	If present, filter item data by the specified item variant code.
ItemVariantDescription	string	No	If present, filter item data by the specified item variant description.

DataSheetPropertyFilter properties

Parameter	Type	Is Required	Description
ExportFilters	string	No	Generic string filter expression for filtering property data.
TestTypeCode	string	No	If present, filter property data by the specified test type code.
TestTypeDescription	string	No	If present, filter property data by the specified test type description.