ZEDAL SOAP Webservice: Overview table queries via ListTransportDocuments() / ListFileAreaDocuments() / ListInboxDocuments()¶
<ListTransportDocuments>
<sessionid>...</sessionid>
<qpar>
<fieldmask>
<!-- Zero or more repetitions: -->
<item>...</item>
</fieldmask>
<!-- Zero or more repetitions: -->
<filter>
<path>...</path>
<op>
<!-- Choice from: -->
equal
not_equal
null
not_null
contains
begins_with
ends_with
less
greater
less_or_equal
greater_or_equal
between
in_list
</op>
<!-- Zero or more repetitions: -->
<operands>
<!-- Choice from: -->
<s>...</s>
<i>...</i>
<n>...</n>
<d>...</d>
<utc>...</utc>
<dt>...</dt>
</operands>
</filter>
<!-- Zero or more repetitions: -->
<sort>
<path>...</path>
<direction>
<!-- Choice from: -->
asc
desc
</direction>
</sort>
<!-- Optional: -->
<page_start>...</page_start>
<!-- Optional: -->
<page_size>...</page_size>
</qpar>
<!-- Optional: -->
<speedup-preselection>...</speedup-preselection>
</ListTransportDocuments>
<ListFileAreaDocuments>
<sessionid>...</sessionid>
<qpar>
<fieldmask>
<!-- Zero or more repetitions: -->
<item>...</item>
</fieldmask>
<!-- Zero or more repetitions: -->
<filter>
<path>...</path>
<op>
<!-- Choice from: -->
equal
not_equal
null
not_null
contains
begins_with
ends_with
less
greater
less_or_equal
greater_or_equal
between
in_list
</op>
<!-- Zero or more repetitions: -->
<operands>
<!-- Choice from: -->
<s>...</s>
<i>...</i>
<n>...</n>
<d>...</d>
<utc>...</utc>
<dt>...</dt>
</operands>
</filter>
<!-- Zero or more repetitions: -->
<sort>
<path>...</path>
<direction>
<!-- Choice from: -->
asc
desc
</direction>
</sort>
<!-- Optional: -->
<page_start>...</page_start>
<!-- Optional: -->
<page_size>...</page_size>
</qpar>
<!-- Optional: -->
<speedup-preselection>...</speedup-preselection>
</ListFileAreaDocuments>
<ListInboxDocuments>
<sessionid>...</sessionid>
<qpar>
<fieldmask>
<!-- Zero or more repetitions: -->
<item>...</item>
</fieldmask>
<!-- Zero or more repetitions: -->
<filter>
<path>...</path>
<op>
<!-- Choice from: -->
equal
not_equal
null
not_null
contains
begins_with
ends_with
less
greater
less_or_equal
greater_or_equal
between
in_list
</op>
<!-- Zero or more repetitions: -->
<operands>
<!-- Choice from: -->
<s>...</s>
<i>...</i>
<n>...</n>
<d>...</d>
<utc>...</utc>
<dt>...</dt>
</operands>
</filter>
<!-- Zero or more repetitions: -->
<sort>
<path>...</path>
<direction>
<!-- Choice from: -->
asc
desc
</direction>
</sort>
<!-- Optional: -->
<page_start>...</page_start>
<!-- Optional: -->
<page_size>...</page_size>
</qpar>
<!-- Optional: -->
<speedup-preselection>...</speedup-preselection>
</ListInboxDocuments>
Description¶
The calls provide overview data for documents stored in the ZEDAL document database. One function per main area (Transport Documents / File Area / Inbox) is available. The functions offer an optional parameter speedup-preselection to limit the amount of documents to the timespan provided, resulting in a speed up of the query.
Available Fields (<fieldmask> / <path>):¶
- doc.document_id
- doc.last_changed
- doc.cancelled
- doc.document_type
- doc.current_layer
- doc.sequence_number
- doc.notification_id
- doc.transport_weight
- doc.transport_volume
- doc.waste_type_code
- doc.notes
- doc.handover_date
- doc.internal_name
- doc.waste_producer_number
- doc.waste_producer_name1
- doc.waste_producer_name2
- doc.waste_producer_city1
- doc.waste_producer_street1
- doc.waste_producer_internal_name
- doc.waste_producer_site_number
- doc.waste_producer_code
- doc.waste_producer_sig1_name
- doc.waste_producer_sig1_time
- doc.waste_producer_sig1_cstat
- doc.waste_producer_sig2_name
- doc.waste_producer_sig2_time
- doc.waste_producer_sig2_cstat
- doc.takeover_date
- doc.carrier1_number
- doc.carrier1_name1
- doc.carrier1_name2
- doc.carrier1_city1
- doc.carrier1_street1
- doc.carrier1_truck
- doc.carrier1_trailer
- doc.carrier1_internal_name
- doc.carrier1_code
- doc.carrier1_site_number
- doc.carrier1_sig1_name
- doc.carrier1_sig1_time
- doc.carrier1_sig1_cstat
- doc.carrier1_sig2_name
- doc.carrier1_sig2_time
- doc.carrier1_sig2_cstat
- doc.acceptance_date
- doc.recovery_disposal_facility_number
- doc.recovery_disposal_facility_name1
- doc.recovery_disposal_facility_name2
- doc.recovery_disposal_facility_city1
- doc.recovery_disposal_facility_street1
- doc.recovery_disposal_facility_acceptance_refused
- doc.recovery_disposal_facility_internal_name
- doc.recovery_disposal_facility_site_number
- doc.recovery_disposal_facility_code
- doc.recovery_disposal_facility_sig1_name
- doc.recovery_disposal_facility_sig1_time
- doc.recovery_disposal_facility_sig1_cstat
- doc.recovery_disposal_facility_sig2_name
- doc.recovery_disposal_facility_sig2_time
- doc.recovery_disposal_facility_sig2_cstat
- doc.carrier2_number
- doc.carrier2_name1
- doc.carrier2_name2
- doc.carrier2_city1
- doc.carrier2_street1
- doc.carrier2_truck
- doc.carrier2_trailer
- doc.carrier2_site_number
- doc.carrier2_sig1_name
- doc.carrier2_sig1_time
- doc.carrier2_sig1_cstat
- doc.carrier2_sig2_name
- doc.carrier2_sig2_time
- doc.carrier2_sig2_cstat
- doc.carrier3_number
- doc.carrier3_name1
- doc.carrier3_name2
- doc.carrier3_city1
- doc.carrier3_street1
- doc.carrier3_truck
- doc.carrier3_trailer
- doc.carrier3_site_number
- doc.carrier3_sig1_name
- doc.carrier3_sig1_time
- doc.carrier3_sig1_cstat
- doc.carrier3_sig2_name
- doc.carrier3_sig2_time
- doc.carrier3_sig2_cstat
- doc.temporary_storage_number
- doc.temporary_storage_name1
- doc.temporary_storage_name2
- doc.temporary_storage_city1
- doc.temporary_storage_street1
- doc.temporary_storage_site_number
- doc.temporary_storage_sig1_name
- doc.temporary_storage_sig1_time
- doc.temporary_storage_sig1_cstat
- doc.temporary_storage_sig2_name
- doc.temporary_storage_sig2_time
- doc.temporary_storage_sig2_cstat
doc.document_id contains the ZEDAL-internal and network-wide unique document number (“docID” - e.g. “12345-6”), doc.sequence_number the official BMU transport document number.
The document type in field doc.document_type correponds to the BMU document type (“BGS”, “UNS”, etc.).
The current layer in doc.current_layer corresponds to the official BMU layer names (e.g. “BGSERZLayer”).
Cancelled documents are markde with the value “true” in the field doc.cancelled.
The field doc.notes may contain multi-line contents.
The signature status fields (..._cstat) carry the following codes:
- 2 -> valid
- 5 -> questionable, e.g. OCSP “unknown” or without answer
- 8 -> invalid
Date fields have the format YYYY-MM-DD (e.g.: “2022-08-31”).
Timestamp fields have the Format YYYY-MM-DDTHH24:Mi:SSZ - e.g.: “2022-08-31T16:48:23Z”. All times are noted in UTC.
Optional: Filter (<filter>):¶
- path -> Field name (s. above)
- op -> Operator (“
equal” / “not_equal” / “null” / “not_null” / “contains” / “begins_with” / “ends_with” / “less” / “greater” / “less_or_equal” / “greater_or_equal” / “between” / “in_list”) - operands -> Operand(s)
If multiple filters are declared, they are always AND-linked (meaning all given conditions have to match). Other logical links can be modeled by performing queries sequentially and combining the results accordingly.
Data types (in <operands>):¶
- s -> string, e.g.: “
Berlin“ - i -> int, e.g.: “
12“ - n -> double, e.g.: “
1.23“ - d -> date, YYYY-MM-DD - e.g.: “
2022-08-31“ - utc -> dateTime (in UTC), YYYY-MM-DD HH24:Mi:SS - e.g.: “
2022-08-31 16:48:23“ - (- not used - dt -> dateTime, YYYY-MM-DD HH24:Mi:SS - e.g.: “
2022-08-31 16:48:23”)
The number of needed operands (by repetition of the <operands> element) depends on the used operator:
- null / not_null: No operand
- equal / not_equal / contains / begins_with / ends_with / less / greater / less_or_equal / greater_or_equal: Exactly one operand
- between: Exactly two operands
- in_list: One or more operands
Optional: Sort (<sort>):¶
Without further specification, the data sets are returned in no particular order.
- path -> Field name (s. above)
- direction -> Direction (“
asc” / “desc”)
Optional: Pagination:¶
Without further specification, a maximum of the first 20 data sets will be returned.
- page_start -> First data set to be returned (>= 1)
- page_size -> Count of data sets to be returned
Optional: Speedup-Preselection (<speedup-preselection>):¶
Takes a date (format YYYY-MM-DD - e.g.: “2022-08-31”). The base amount of documents is pre-limited to those relevant until up to this date, resulting in a speed-up of the query. When not provided, all available data is taken into account.