GET /ediBilling/search

Searches the database for EDI Bills matching the given request parameters.

Roles that can access this endpoint are Users.

Parameters

name description type default type

request

name	description	type	default	type
request	read for query parameters to be used as search criteria; use any combination of fields from tables: `edi_billing` - use `edi_billing` or no prefix `customer` - use `customer` prefix `edibilling_profile` - use `profile` prefix For example, `/ediBilling/search?edi_billing.partner_id=TESTPARTNER&customer.state_id=AL` would find EDI Bills for partner ID 'TESTPARTNER' where the customer is located in Alabama. Sorting: To sort the result set, you can provide the following reserved query parameter: `orderBy` If the orderBy parameter is not provided a default sort of `edi_billing.order_id+ASC,edi_billing.invoice_no_string+ASC` will be applied. For example, `/ediBilling/search?edi_billing.partner_id=&orderBy=customer.name+DESC` would return all edi billing records sorted descending by the customer name. Multiple sort columns can be provided in a comma delimited format. `orderBy=prefix.field+direction,prefix.field+direction` Pagination:* To page the result set, you can provide the following reserved query parameters: `recordLength and recordOffset` For example, `/ediBilling/search?edi_billing.partner_id=*&recordLength=100&recordOffset=50` would return 100 records starting at the 51st record in the return record set. If no recordLength parameter is provided the search result maximum value in the mobile service control file will be applied.	context		HttpServletRequest

read for query parameters to be used as search criteria; use any combination of fields from tables:

edi_billing - use edi_billing or no prefix
customer - use customer prefix
edibilling_profile - use profile prefix

For example, /ediBilling/search?edi_billing.partner_id=TESTPARTNER&customer.state_id=AL would find EDI Bills for partner ID 'TESTPARTNER' where the customer is located in Alabama.

Sorting: To sort the result set, you can provide the following reserved query parameter: orderBy If the orderBy parameter is not provided a default sort of edi_billing.order_id+ASC,edi_billing.invoice_no_string+ASC will be applied.

For example, /ediBilling/search?edi_billing.partner_id=*&orderBy=customer.name+DESC would return all edi billing records sorted descending by the customer name. Multiple sort columns can be provided in a comma delimited format. orderBy=prefix.field+direction,prefix.field+direction

Pagination: To page the result set, you can provide the following reserved query parameters: recordLength and recordOffset

For example, /ediBilling/search?edi_billing.partner_id=*&recordLength=100&recordOffset=50 would return 100 records starting at the 51st record in the return record set. If no recordLength parameter is provided the search result maximum value in the mobile service control file will be applied.

context

HttpServletRequest

Result

List < RowEdiBilling > of type: application/xml application/json

a list of RowEdiBilling objects

Additional attributes:

__directionDescr This value represents the bill's direction, found in the edi_billing.direction field.
__errorDescr This value represents the error description, found in the edi_billing.error field.
__readyToSendDescr This value represents the ready to send description, found in the edi_billing.ready_to_send field.
__equipmentTypeDescr This value represents the description of the equipment type, found in the edi_billing.equipment_type_id field.
__shipmentMatchingDescr This value represents the shipment matching method description, found in the edi_billing.ship_match_type field.

Child Elements:

RowEdiBillingProfile This element represents the EDI Billing Profile associated with the invoice. The element contains a __name attribute with the value profile.

GET /ediBilling/search

Parameters

Result

Try It Out

Request

Response