Query Structures Web Service
Contents
Overview
Fusion Metadata Registry provides a web service for querying structural metadata which conforms to the SDMX specification.
Some additional Accept header values and query parameters are also supported both of which are explained in this guide.
| Entry Point | /ws/public/sdmxapi/rest/ |
| Access | Public |
| Authentication | None |
| Http Method | GET |
| Response Format | Multiple SDMX formats supported which can be specified wither using the HTTP Accept header or the 'format' URL parameter |
| Response Statuses | 200 - Success 404 - Structure not found 500 - Server Error |
| Error Response | SDMX-ML 2.1 Error Response Document |
Headers
| HTTP Header | Purpose | Allowed Values |
|---|---|---|
| Accept | To define the response format |
|
| Accept-Language |
This optional header can be used to set the locale to return any multilingual text in (names and descriptions). If the text does not exist in the specified locale, then the default rules will be applied to find the next best appropriate locale. |
Examples: |
| If-Modified-Since | The server sends back the requested resource, with a 200 status, only if it has been last modified after the specified date. If the resource has not been modified since, the response is a 304 without any body. Note: The current implementation has a limitiation in that any deletion of structural metadata will reset all datetimes of existing structures to the current time. This is to avoid the "false negative" scenario whereby querying for all structures would not return a 200 response if a structure had been deleted. The current implementation does give "false positives" - i.e. a structure has changed when it has not. |
A date in the expected format of: <Day-Name>, <Day> <Month-Name> <Year> <Hour>:<Minute>:<Second> GMT Examples: Fri, 31 Dec 2023 23:59:59 GMT |
Resources
The following resources are defined:
- datastructure (This has been shortened from DataStructureDefinition to allow for shorter URLs)
- metadatastructure (This has been shortened from MetadataStructureDefinition to allow for shorter URLs)
- categoryscheme
- conceptscheme
- codelist
- hierarchicalcodelist
- organisationscheme (The organisationscheme resource can be used whenever the role played by the organisation schemes is not known/relevant)
- agencyscheme (For 3 of the subtypes of OrganisationScheme, the id and version parameters have fixed values. See Section 03 of the SDMX information model document for additional information)
- dataproviderscheme
- dataconsumerscheme
- organisationunitscheme
- dataflow
- metadataflow
- reportingtaxonomy
- provisionagreement
- structureset
- process
- categorisation
- contentconstraint
- actualconstraint (a type of contentconstraint stating what data are actually present)
- allowedconstraint (a type of contentconstraint defining what data are allowed)
- attachmentconstraint
- transformationscheme
- rulesetscheme
- userdefinedoperatorscheme
- customtypescheme
- namepersonalisationscheme
- vtlmappingscheme
- structure (This type can be used to retrieve any type of structural metadata matching the supplied parameters)
Parameters
The following parameters are used for identifying resources:
| Parameter | Type | Description |
|---|---|---|
| agencyID | A string compliant with the SDMX common:NCNameIDType | The agency maintaining the artefact to be returned. It is possible to set more than one agency, using + as separator (e.g. BIS+ECB).
|
| resourceID | A string compliant with the SDMX common:IDType | The id of the artefact to be returned. It is possible to set more than one id, using + as separator (e.g. CL_FREQ+CL_CONF_STATUS).
|
| version | A string compliant with the SDMX common:VersionType | The version of the artefact to be returned. It is possible to set more than one version, using + as separator (e.g. 1.0+2.1).
|
The parameters mentioned above are specified using the following syntax:
protocol://domain/ws/public/sdmxapi/rest/resource/agencyID/resourceID/version
Additional parameter used for identifying a resource, for item scheme types
SDMX uses the item scheme pattern to model SDMX collections of items. These are principally:
- categoryscheme
- conceptscheme
- codelist
... and others concerning organisation schemes and VTL transformations.
A complete list can be found in the REST API Overview.
Although it is not following the item scheme pattern, hierarchicalcodelist is also a collection, i.e. a collection of hierarchies.
For these collections (those following the item scheme pattern or the hierarchicalcodelist), it is possible to use a 4th parameter for identifying a resource. The rules for the 3 other parameters, as defined in the section above, remain valid.
| Parameter | Type | Description |
|---|---|---|
| itemID | A string compliant with the SDMX common:NestedNCNameIDType for conceptscheme and agencyscheme, SDMX common:IDType for hierarchicalcodelist or with the SDMX common:NestedIDType in all other cases | The id of the item to be returned. It is possible to set more than one id, using + as separator (e.g. A+Q+M).
|
This 4th parameter is used as follows:
protocol://domain/ws/public/sdmxapi/rest/resource/agencyID/resourceID/version/itemID
URL Request Parameters
The request parameters are all optional and can be used to define the response detail, format, and any additional structures which reference, or are referenced by those identified in the query path.
| Parameter | Purpose | Allowed Values |
|---|---|---|
| detail | To define which structures (if any) are output as stubs. |
full – default. Output full response. allstubs – Output all the structures as stubs. referencestubs – Output the full query result, and any referenced structures are returned as stubs referencepartial – Outputs the full query result and any referenced Codelists, Concept Schemes, Agency Schemes are returned as partial lists based on the Codes, Concepts, and Agencies used by the referencing Provision Agreements, Dataflows, Data Structures, Hierarchical Codelists. Partial Codelists are derived from Content Constraints used to define allowable content for data reporting. Example: detail=allstubs detail=referencepartial |
| references |
To define if additional structures are returned from the query. The structures can either be ones which reference, or are referenced by the structures in the query result. If the query result is for a specific item in an item scheme, then this parameter will identify the references for that item. |
none – default. Do not output any additional structures parents –output structures the reference the structures matching the query parentsandsiblings – same as parents, but also include all the additional structures referenced by the parents children – the structures referenced by the structures in the query result descendants – children and their children (up to any level) In addition, a concrete type of resource may be used, for example: datastructure Example: references=datastructure |
| partial |
If set to true creates partial Codelists in the response based on the Fusion Metadata Registry Content Constraints defining allowable content. The pre-requisite is that the query must be for a single constrainable structure (Provision Agreements, Dataflow, or Data Structure) and include references. |
true/false Note: This is deprecated as of v9.2.23, use detail=referencepartial instead |
| format | Can be used to define the response format (as an alternative to the HTTP Accept Header). |
sdmx (latest version) sdmx-1.0 sdmx-2.0 sdmx-2.1 sdmx-edi sdmx-edi-lenient sdmx-json rdf-turtle rdf-json rdf-xml xlsx Example: format=sdmx-edi |
| includeMetadata |
If set to true, then the response structures will contain additional Annotations if there are reference metadata attached. The annotation will have the AnnotationType of ‘METADATA’ and the AnnotationURI will provide a URl to the MetadataSet. |
true/false Example: includeMetadata=true |
| locale |
This optional parameter can be used to set the locale to return any multilingual text in (names and descriptions). If the text does not exist in the specified locale, then the default rules will be applied to find the next best appropriate locale. This takes priority over the Accept-Language HTTP header |
Any locale Example: locale=fr |
| includeMetrics | Enriches structures with information about data that is available. See Annex 3 – Metrics and Data Availability |
true/false/only IncludeMetrics=only is used to indicate that only maintainable structures with metrics should be returned, and maintainables which have no metrics are removed from the query response. Example: includeMetrics=true includeMetrics=only |
| saveAs |
If provided the HTTP Header ‘Content-Disposition’ will be set to attachment with the filename being set to the value provided. This will result in the response being saved to a file. The file extension is not required as the Registry will determine the extension based on the response format. |
String Example: saveAs=myDownload |
| prettyPrint | If the you are requesting XML, and you would like the response XML to be formatted, then you can pass true |
String prettyPrint=true |
| validFrom | For structures with a defined validFrom or validTo value, returns only those structures which have a validFrom value before the specified date |
Single time period. Conforms to the ISO-8601 standard but SDMX date time formats may also be used Example: validFrom=1960-12-31 |
| validTo | For structures with a defined validFrom or validTo value, returns only those structures which have a validTo value after the specified date |
Single time period. Conforms to the ISO-8601 standard but SDMX date time formats may also be used Example: validTo=1960-12-31 |
| validOn | Returns structures where the items listed are applicable for the specified date. This parameter is only applicable for those structures which support Item Validity. |
Single time period. Conforms to the ISO-8601 standard but SDMX date time formats may also be used Example: validOn=1960-12-31 |
| labels |
For sdmx-csv format only For each element of the CSV, will return either the ID only or the ID and Name separated by a colon |
Id – default both Example: labels=both |
| timeFormat |
For sdmx-csv format only Normalized TIME_PERIOD values are converted to the most granular ISO 8601 representation taking into account the highest frequency of the data in the message |
original – default normalized Example: timeFormat=normalized |
