info@ismena.com
Ismena websiteIsmena websiteIsmena websiteIsmena website
  • Home
  • About us
  • Technologies
    • Cloud Services
      • Google Cloud Platform
        • Networking
        • Compute
        • Storage
        • SAP on GCP
        • Google Maps
        • Data Center Modernization
    • Infrastructure
      • iSolution Services
      • Unified Communication
      • Network Security
      • Access Security & Control
      • Computing Platforms
      • Structured Cabling Infrastructure
      • Datacenter Infrastructure
      • Networking Infrastructure
      • Retail Analytics
      • Cloud Infrastructure
    • Integration
      • Apigee
      • IBM
      • Custom Connectors
      • UnifAI
    • Security
      • Security Consulting Services
      • Security Solutions
    • Data & AI
      • BigQuery, Looker
      • Gemini
    • Collaboration Tools
      • Google Workspace For Enterprise
    • ERP-CRM
      • Odoo
      • Salesforce
      • SAP on GCP
    • DevOps
      • GCP
      • SonarSource
    • Managed Service Provider
      • Managed Service Provider
    • App Development
      • App Development
    • Open Banking
      • Open banking
    • Chrome Devices
  • Unplugged Podcast
  • Blog
    • Success Stories
    • News
    • Articles
  • Careers
  • Contact Us

Technologies

Integration

Custom Connectors

Explore All Connectors

Open Data City of Brussels Connector

Open Data City of Brussels Connector

Connector Details

Type

Virtual machines, Single VM , BYOL

Runs on

Google Compute Engine

Last Update

24 October, 2024

Category

Overview

Documentation

Pricing

Support

Overview

The Open Data City of Brussels Connector facilitates seamless integration with the City of Brussels open data platform, providing access to catalog datasets, records, export formats, facets, and attachments. This connector acts as a proxy to streamline data retrieval, supporting actions for querying datasets, listing export formats, exporting data, enumerating facets, and retrieving individual records or attachments. It supports JSON response formats and is optimized for deployment on Google Cloud Platform (GCP).

Integration Overview

This document provides a detailed guide for each integration point, its purpose, configuration, and workflow support using the Open Data City of Brussels Connector.

  • getDatasets: Retrieves a list of available datasets, optionally filtered or refined.
  • listExportFormats: Lists available export formats for the catalog.
  • exportDatasets: Exports the catalog in a specified format.
  • exportCatalogCSV: Exports the catalog in CSV format.
  • exportCatalogDCAT: Exports the catalog in RDF/XML (DCAT) format.
  • getDatasetsFacets: Enumerates facet values for datasets.
  • getRecords: Performs a query on dataset records.
  • listDatasetExportFormats: Lists available export formats for a specific dataset.
  • exportRecords: Exports a dataset in a specified format.
  • exportRecordsCSV: Exports a dataset in CSV format.
  • exportRecordsParquet: Exports a dataset in Parquet format.
  • exportRecordsGPX: Exports a dataset in GPX format.
  • getDataset: Retrieves information about a specific dataset.
  • getRecordsFacets: Enumerates facet values for dataset records.
  • getDatasetAttachments: Lists attachments for a specific dataset.
  • getRecord: Retrieves a single dataset record by identifier.

Detailed Integration Documentation

Catalog Datasets Retrieval

Action getDatasets
Purpose Retrieves a list of available datasets, optionally filtered by query parameters such as where clauses, refinements, or limits. This serves as the primary entry point for discovering datasets, useful for building catalog interfaces.
Parameters
  • Required: None (base query retrieves all datasets)
  • Optional:
    • select: Select expression for fields to return (string, e.g., dataset_id, metas)
    • where: Filter expression using ODSQL (string, e.g., publisher="Opendatasoft")
    • order_by: Sorting criteria (string, e.g., modified desc)
    • limit: Number of items to return (integer, default: 10, max: 100)
    • offset: Starting index (integer, default: 0)
    • refine: Facet refinement (string, e.g., refine=publisher:Opendatasoft)
    • exclude: Facet exclusion (string, e.g., exclude=language:fr)
    • lang: Language for formatting (string, enum: [en, fr, nl, pt, it, ar, de, es, ca, eu, sv], default: fr)
    • timezone: Timezone for datetime fields (string, e.g., Europe/Brussels)
    • group_by: Grouping expression (string)
    • include_links: Include navigation links (boolean)
    • include_app_metas: Include application metadata (boolean)
Configuration Ensure the connector is configured with the base URL via the CONNECTOR_ENV_OPENDATA_BRUSSELS_BASE_URL environment variable. For GCP deployment, set the apikey via query parameters or GCP Secret Manager for secure storage.
Output
  • Successful: Returns a JSON object with:
    • total_count: Total number of datasets (integer)
    • links: Array of navigation links
    • results: Array of dataset objects containing dataset_id, metas, fields, etc.
  • Failure: Returns error details (e.g., message: ODSQL query is malformed, error_code: ODSQLError)
Workflow Example Configure the connector with the base URL and apikey in GCP Secret Manager.
Execute the getDatasets action with optional where=publisher="Opendatasoft".
Process the response to populate a dataset selection list in a GCP-hosted application.

Export Formats Listing

Action listExportFormats
Purpose Lists available export formats for the catalog, useful for determining supported output types before exporting.
Parameters
  • Required: None
  • Optional: None
Configuration Ensure the connector is configured with the base URL via CONNECTOR_ENV_OPENDATA_BRUSSELS_BASE_URL environment variable. For GCP deployment, set the apikey via query parameters or GCP Secret Manager.
Output
  • Successful: Returns a JSON object with:
    • links: Array of links to export endpoints
  • Failure: Returns error details (e.g., message: Too many requests, error_code: 10002)
Workflow Example Configure the connector with the base URL and apikey in GCP Secret Manager.
Execute the listExportFormats action.
Use the response to select a format for subsequent exports in a GCP Cloud Function.

Catalog Export

Action exportDatasets
Purpose Exports the catalog in a desired format, optionally filtered, useful for bulk data retrieval.
Parameters
  • Required:
    • format: Export format (string, enum: [csv, fgb, geojson, gpx, json, jsonl, jsonld, kml, n3, ov2, parquet, rdfxml, shp, turtle, xlsx])
  • Optional:
    • select: Select expression (string)
    • where: Filter expression (string)
    • order_by: Sorting criteria (string)
    • group_by: Grouping expression (string)
    • limit: Number of items (integer)
    • offset: Starting index (integer)
    • refine: Facet refinement (string)
    • exclude: Facet exclusion (string)
    • lang: Language (string)
    • timezone: Timezone (string)
Configuration Ensure the connector is configured with the base URL via CONNECTOR_ENV_OPENDATA_BRUSSELS_BASE_URL. For GCP deployment, set the apikey via query parameters or GCP Secret Manager.
Output
  • Successful: Returns a file in the specified format
  • Failure: Returns error details (e.g., message: Bad Request)
Workflow Example Configure the connector with the base URL and apikey in GCP Secret Manager.
Execute the exportDatasets action with format=json and optional where filters.
Store the exported file in GCP Cloud Storage for further processing.

Catalog CSV Export

Action exportCatalogCSV
Purpose Exports the catalog in CSV format with customizable delimiters, useful for spreadsheet integration.
Parameters
  • Required: None (defaults to CSV)
  • Optional:
    • delimiter: Field delimiter (string, enum: [;, ,, \t, |], default: 😉
    • list_separator: Multivalued separator (string, default: ,)
    • quote_all: Force quoting all strings (boolean, default: false)
    • with_bom: Include Byte Order Mark (boolean, default: true)
Configuration Ensure the connector is configured with the base URL via CONNECTOR_ENV_OPENDATA_BRUSSELS_BASE_URL. For GCP deployment, set the apikey via query parameters or GCP Secret Manager.
Output
  • Successful: Returns a CSV file
  • Failure: Returns error details (e.g., message: Bad Request)
Workflow Example Configure the connector with the base URL and apikey in GCP Secret Manager.
Execute the exportCatalogCSV action with delimiter=;.
Import the CSV into Google BigQuery for analysis.

Catalog DCAT Export

Action exportCatalogDCAT
Purpose Exports the catalog in RDF/XML (DCAT) format, useful for metadata interoperability.
Parameters
  • Required:
    • dcat_ap_format: DCAT format specifier (string)
  • Optional:
    • include_exports: Datasets exports to expose (string, e.g., csv,json,geojson)
    • use_labels_in_exports: Use field labels (boolean, default: true)
Configuration Ensure the connector is configured with the base URL via CONNECTOR_ENV_OPENDATA_BRUSSELS_BASE_URL. For GCP deployment, set the apikey via query parameters or GCP Secret Manager.
Output
  • Successful: Returns an RDF/XML file
  • Failure: Returns error details (e.g., message: Bad Request)
Workflow Example Configure the connector with the base URL and apikey in GCP Secret Manager.
Execute the exportCatalogDCAT action.
Use the DCAT file for metadata sharing in a GCP-hosted metadata repository.

Datasets Facets Enumeration

Action getDatasetsFacets
Purpose Enumerates facet values for datasets, useful for guided navigation in large result sets.
Parameters
  • Required:
    • facet: Facet name or function (string, e.g., facet=publisher)
  • Optional:
    • refine: Facet refinement (string)
    • exclude: Facet exclusion (string)
    • where: Filter expression (string)
    • timezone: Timezone (string)
Configuration Ensure the connector is configured with the base URL via CONNECTOR_ENV_OPENDATA_BRUSSELS_BASE_URL. For GCP deployment, set the apikey via query parameters or GCP Secret Manager.
Output
  • Successful: Returns a JSON object with:
    • links: Array of links
    • facets: Array of facet enumerations with name, count, state
  • Failure: Returns error details (e.g., message: ODSQL query is malformed)
Workflow Example Configure the connector with the base URL and apikey in GCP Secret Manager.
Execute the getDatasetsFacets action with facet=publisher.
Use facets to refine dataset queries in a GCP Cloud Run application.

Dataset Records Query

Action getRecords
Purpose Performs a query on records within a specific dataset, optionally with filters or aggregations.
Parameters
  • Required:
    • dataset_id: Dataset identifier (string)
  • Optional:
    • select: Select expression (string)
    • where: Filter expression (string)
    • group_by: Grouping expression (string)
    • order_by: Sorting criteria (string)
    • limit: Number of items (integer, default: 10)
    • offset: Starting index (integer, default: 0)
    • refine: Facet refinement (string)
    • exclude: Facet exclusion (string)
    • lang: Language (string)
    • timezone: Timezone (string)
    • include_links: Include links (boolean)
    • include_app_metas: Include metadata (boolean)
Configuration Ensure the connector is configured with the base URL via CONNECTOR_ENV_OPENDATA_BRUSSELS_BASE_URL. For GCP deployment, set the apikey via query parameters or GCP Secret Manager.
Output
  • Successful: Returns a JSON object with:
    • total_count: Total records (integer)
    • links: Array of links
    • results: Array of record objects
  • Failure: Returns error details (e.g., message: Bad Request)
Workflow Example Configure the connector with the base URL and apikey in GCP Secret Manager.
Execute the getRecords action with dataset_id=world-administrative-boundaries-countries-and-territories and optional where filters.
Process records for display in a GCP-hosted dashboard.

Dataset Export Formats Listing

Action listDatasetExportFormats
Purpose Lists available export formats for a specific dataset.
Parameters
  • Required:
    • dataset_id: Dataset identifier (string)
  • Optional: None
Configuration Ensure the connector is configured with the base URL via CONNECTOR_ENV_OPENDATA_BRUSSELS_BASE_URL. For GCP deployment, set the apikey via query parameters or GCP Secret Manager.
Output
  • Successful: Returns a JSON object with links to export endpoints.
  • Failure: Returns error details (e.g., message: Bad Request)
Workflow Example Configure the connector with the base URL and apikey in GCP Secret Manager.
Execute the listDatasetExportFormats action with dataset_id.
Select a format for dataset export in a GCP Cloud Function.

Dataset Export

Action exportRecords
Purpose Exports records from a specific dataset in a desired format.
Parameters
  • Required:
    • dataset_id: Dataset identifier (string)
    • format: Export format (string, enum: [csv, fgb, geojson, gpx, json, jsonl, jsonld, kml, n3, ov2, parquet, rdfxml, shp, turtle, xlsx])
  • Optional:
    • select: Select expression (string)
    • where: Filter expression (string)
    • order_by: Sorting criteria (string)
    • group_by: Grouping expression (string)
    • limit: Number of items (integer)
    • refine: Facet refinement (string)
    • exclude: Facet exclusion (string)
    • lang: Language (string)
    • timezone: Timezone (string)
    • use_labels: Use field labels (boolean, default: false)
    • compressed: Compress output (boolean, default: false)
    • epsg: EPSG code for projections (integer, default: 4326)
Configuration Ensure the connector is configured with the base URL via CONNECTOR_ENV_OPENDATA_BRUSSELS_BASE_URL. For GCP deployment, set the apikey via query parameters or GCP Secret Manager.
Output
  • Successful: Returns a file in the specified format.
  • Failure: Returns error details (e.g., message: Bad Request)
Workflow Example Configure the connector with the base URL and apikey in GCP Secret Manager.
Execute the exportRecords action with dataset_id and format=json.
Store the exported file in GCP Cloud Storage.

Dataset CSV Export

Action exportRecordsCSV
Purpose Exports dataset records in CSV format with customization.
Parameters
  • Required:
    • dataset_id: Dataset identifier (string)
  • Optional:
    • delimiter: Field delimiter (string, enum: [;, ,, \t, |], default: 😉
    • list_separator: Multivalued separator (string, default: ,)
    • quote_all: Force quoting (boolean, default: false)
    • with_bom: Include Byte Order Mark (boolean, default: true)
Configuration Ensure the connector is configured with the base URL via CONNECTOR_ENV_OPENDATA_BRUSSELS_BASE_URL. For GCP deployment, set the apikey via query parameters or GCP Secret Manager.
Output
  • Successful: Returns a CSV file.
  • Failure: Returns error details (e.g., message: Bad Request)
Workflow Example Configure the connector with the base URL and apikey in GCP Secret Manager.
Execute the exportRecordsCSV action with dataset_id.
Import CSV into Google BigQuery for analysis.

Dataset Parquet Export

Action exportRecordsParquet
Purpose Exports dataset records in Parquet format with compression options.
Parameters
  • Required:
    • dataset_id: Dataset identifier (string)
  • Optional:
    • parquet_compression: Compression type (string, enum: [snappy, zstd], default: snappy)
Configuration Ensure the connector is configured with the base URL via CONNECTOR_ENV_OPENDATA_BRUSSELS_BASE_URL. For GCP deployment, set the apikey via query parameters or GCP Secret Manager.
Output
  • Successful: Returns a Parquet file.
  • Failure: Returns error details (e.g., message: Bad Request)
Workflow Example Configure the connector with the base URL and apikey in GCP Secret Manager.
Execute the exportRecordsParquet action with dataset_id.
Use Parquet in Google BigQuery for big data analysis.

Dataset GPX Export

Action exportRecordsGPX
Purpose Exports dataset records in GPX format for geospatial applications.
Parameters
  • Required:
    • dataset_id: Dataset identifier (string)
  • Optional:
    • name_field: Field for name attribute (string)
    • description_field_list: Fields for description (string)
    • use_extension: Use extension tag (boolean, default: true)
Configuration Ensure the connector is configured with the base URL via CONNECTOR_ENV_OPENDATA_BRUSSELS_BASE_URL. For GCP deployment, set the apikey via query parameters or GCP Secret Manager.
Output
  • Successful: Returns a GPX file.
  • Failure: Returns error details (e.g., message: Bad Request)
Workflow Example Configure the connector with the base URL and apikey in GCP Secret Manager.
Execute the exportRecordsGPX action with dataset_id.
Load GPX into Google Maps API for visualization.

Dataset Information Retrieval

Action getDataset
Purpose Retrieves metadata and endpoints for a specific dataset.
Parameters
  • Required:
    • dataset_id: Dataset identifier (string)
  • Optional:
    • select: Select expression (string)
    • lang: Language (string)
    • timezone: Timezone (string)
    • include_links: Include links (boolean)
    • include_app_metas: Include metadata (boolean)
Configuration Ensure the connector is configured with the base URL via CONNECTOR_ENV_OPENDATA_BRUSSELS_BASE_URL. For GCP deployment, set the apikey via query parameters or GCP Secret Manager.
Output
  • Successful: Returns a JSON object with dataset_id, metas, fields, links, and features.
  • Failure: Returns error details (e.g., message: Bad Request)
Workflow Example Configure the connector with the base URL and apikey in GCP Secret Manager.
Execute the getDataset action with dataset_id=geonames-all-cities-with-a-population-1000.
Use metadata to configure a GCP-hosted application interface.

Dataset Records Facets Enumeration

Action getRecordsFacets
Purpose Enumerates facet values for records in a specific dataset, useful for guided navigation.
Parameters
  • Required:
    • dataset_id: Dataset identifier (string)
    • facet: Facet name or function (string)
  • Optional:
    • where: Filter expression (string)
    • refine: Facet refinement (string)
    • exclude: Facet exclusion (string)
    • lang: Language (string)
    • timezone: Timezone (string)
Configuration Ensure the connector is configured with the base URL via CONNECTOR_ENV_OPENDATA_BRUSSELS_BASE_URL. For GCP deployment, set the apikey via query parameters or GCP Secret Manager.
Output
  • Successful: Returns a JSON object with links and facets (name, count, state).
  • Failure: Returns error details (e.g., message: Bad Request)
Workflow Example Configure the connector with the base URL and apikey in GCP Secret Manager.
Execute the getRecordsFacets action with dataset_id and facet=timezone.
Use facets to refine record queries in a GCP Cloud Run application.

Dataset Attachments Listing

Action getDatasetAttachments
Purpose Lists all available attachments for a specific dataset.
Parameters
  • Required:
    • dataset_id: Dataset identifier (string)
  • Optional: None
Configuration Ensure the connector is configured with the base URL via CONNECTOR_ENV_OPENDATA_BRUSSELS_BASE_URL. For GCP deployment, set the apikey via query parameters or GCP Secret Manager.
Output
  • Successful: Returns a JSON object with links and attachments (href, mime-type, title).
  • Failure: Returns error details (e.g., message: Bad Request)
Workflow Example Configure the connector with the base URL and apikey in GCP Secret Manager.
Execute the getDatasetAttachments action with dataset_id.
Download attachments to GCP Cloud Storage.

Single Record Retrieval

Action getRecord
Purpose Retrieves a single dataset record by its identifier.
Parameters
  • Required:
    • dataset_id: Dataset identifier (string)
    • record_id: Record identifier (string)
  • Optional:
    • select: Select expression (string)
    • lang: Language (string)
    • timezone: Timezone (string)
Configuration Ensure the connector is configured with the base URL via CONNECTOR_ENV_OPENDATA_BRUSSELS_BASE_URL. For GCP deployment, set the apikey via query parameters or GCP Secret Manager.
Output
  • Successful: Returns a JSON object with record details (e.g., _id, fields like timezone, name).
  • Failure: Returns error details (e.g., message: Bad Request)
Workflow Example Configure the connector with the base URL and apikey in GCP Secret Manager.
Execute the getRecord action with dataset_id and record_id.
Display the record in a GCP-hosted user interface.

Workflow Creation with the Connector

Example Workflow: Dataset Exploration and Export

Retrieve Available Datasets Use the getDatasets action to fetch a list of datasets with optional refine=publisher:Opendatasoft.
Identify datasets of interest (e.g., geonames-all-cities-with-a-population-1000).
Query Dataset Records Execute the getRecords action with dataset_id=geonames-all-cities-with-a-population-1000 and optional where=timezone:Europe/Brussels.
Process records to display in a GCP-hosted dashboard.
Export Dataset for Analysis Use the exportRecordsCSV action with dataset_id and delimiter=; to export records.
Store the CSV in GCP Cloud Storage and analyze it using Google BigQuery.

This workflow enables applications to explore, query, and export open data from the City of Brussels, enhancing data-driven applications hosted on GCP.

Pricing

Request a Quote

Support

For Technical support please contact us on

custom-connectors-support@isolutions.sa

iSolution logo - white - transparent 250 px

iSolution logo - white - transparent 250 px

A tech solution company dedicated to providing innovation thus empowering businesses to thrive in the digital age.

  • Home
  • About us
  • Blog
  • Careers
  • Success Stories
  • News
  • Articles
  • Contact Us
  • Terms and conditions
  • Privacy Policy
© Copyright 2024 iSolution | All Rights Reserved
  • Home
  • About us
  • Technologies
    • Cloud Services
      • Google Cloud Platform
        • Networking
        • Compute
        • Storage
        • SAP on GCP
        • Google Maps
        • Data Center Modernization
    • Infrastructure
      • iSolution Services
      • Unified Communication
      • Network Security
      • Access Security & Control
      • Computing Platforms
      • Structured Cabling Infrastructure
      • Datacenter Infrastructure
      • Networking Infrastructure
      • Retail Analytics
      • Cloud Infrastructure
    • Integration
      • Apigee
      • IBM
      • Custom Connectors
      • UnifAI
    • Security
      • Security Consulting Services
      • Security Solutions
    • Data & AI
      • BigQuery, Looker
      • Gemini
    • Collaboration Tools
      • Google Workspace For Enterprise
    • ERP-CRM
      • Odoo
      • Salesforce
      • SAP on GCP
    • DevOps
      • GCP
      • SonarSource
    • Managed Service Provider
      • Managed Service Provider
    • App Development
      • App Development
    • Open Banking
      • Open banking
    • Chrome Devices
  • Unplugged Podcast
  • Blog
    • Success Stories
    • News
    • Articles
  • Careers
  • Contact Us
Ismena website

Register To Palo Alto & iSolution Event

Register to IBM x iSolution Event

Register to Gemini in Action Workshop

[forminator_form id=”14485″]

Registration To Amman Unplugged Event

[forminator_form id=”14419″]

Register to Gemini in Action Workshop

[forminator_form id=”14298″]

Tech and Culture Riyadh

[forminator_form id=”13094″]