Published by
Dubai Courts
Number of Data Files / Resources 1
Updated: 20 Sep 2021
This Dataset will list all the records of court session information that are scheduled within the next seven days
Request Permission

I acknowledge that I have read and agree to the terms and conditions

Cancel
Send Request
Your request has been successfully submitted
You will receive a confirmation within 14days time period. If you are
having any query feel free to contact us.
Done
Send Feedback
Field Value
Data Provenance This data set represent a list of all courts session at Dubai Courts is generated by by Case management application that run using Oracle tools and Orale Database over Dubia Courts infrastructre
Dataset Source next_sess_rol_details
Format API
Created 07 Apr 2018
Last updated 20 Sep 2021
Frequency of Update on Source RealTime
Frequency of Update to SDP
Daily
Expected Volume/Ingestion Cycle(Daily if Real-time)
3000 records
Language English~English~English~English~Arabic~Arabic~English~English~English~Arabic~Arabic~Arabic
State active
Rights N/A
License notspecified
Name Description Primary Key Size Datatype Foreign Key Range of Values Language Classification
session_date The date of the case session Yes 10 DATE Denormalized DD-MM-YYYY English Open
session_day Day of session Yes 10 VARCHAR2 Denormalized English Open
session_time The time of session Yes 5 VARCHAR2 Denormalized DD-MM-YYYY HH24:MI English Open
area_description The jurisdiction area Yes 100 VARCHAR2 Denormalized Please see CaseArea tab English Open
hall_description The hall number Yes 60 VARCHAR2 Denormalized Please see CaseHall tab Arabic Open
session_sequence_number sequence of the session in a particular the hall (Multiple rows) Yes 4 NUMBER Denormalized Arabic Open
case_subtype_code Case number PK1 (Multiple rows) Yes 3 NUMBER Denormalized Please see CaseSubtype tab English Open
case_year Case number PK2 (Multiple rows) Yes 4 NUMBER Denormalized English Open
case_serial_number Case number PK2 (Multiple rows) Yes 5 NUMBER Denormalized English Open
case_number Concatenated Case key with subtype code description (Multiple rows) Yes 250 VARCHAR2 Denormalized Arabic Open
status Status of the case (Multiple rows) Yes 150 VARCHAR2 Denormalized Please see CaseStatus tab Arabic Open
postponement_reason The reason of the case postponement (Multiple rows) Yes 150 VARCHAR2 Denormalized Arabic Open

Dubai Pulse Data API

Access resource data via a web API with powerful query support.

The Data API can be accessed via the following actions of the CKAN action API.
  • Query
    https://api.dubaipulse.gov.ae/open/dubai-courts/courts_session_agendas-open-api
  • End Users will receive "API Key" and "API Secret" in two separate emails on the first time Grant of a Dataset, first Purchase of a Commercial Dataset, or Purchase of an API Package. This API Key and API Secret combination should be used to generate API token and the token will need to be included in the http headers of every API call made.

    Authentication Service to generate API token: https://api.dubaipulse.gov.ae/oauth/client_credential/accesstoken?grant_type=client_credentials with body 'client_id={API Key}&client_secret={API Secret}

    Read the value of "access_token" from the response of the above service and use it in the header of every API call. The obtained API token is valid for certain duration (for example 30 minutes) after which a fresh token needs to be obtained.

    Header Name : Authorization
    Value : Bearer {access_token}

  • Query Parameters
    API calls can be made for full dataset result (subject to maximum results limit) or to a subset of results. Different filters can be applied on the results. Developers can use the attributes to apply a combination of filters with and/or conditions.
  • Limiting the Response Size
    Developers can limit the number of records returned by an API call passing the "Limit" parameter in the call. The value of the "Limit" must be less than the allowed maximum limit.
  • Limiting the Attributes
    Developers can limit the API response to specific set of attributes by passing the attribute names in the API call. The example below explains how the attributes can be specified in the API call. This feature can be used in conjunction with query parameters.
  • Curl Command Sample:
    curl -X GET --header "Authorization: qMtn6xQapeouAlirfHXD7DWJFabV" "https://api.dubaipulse.gov.ae/shared/rta/rta_tram_stations-open-api"
  • Query Samples:
    https://api.dubaipulse.gov.ae/shared/rta/rta_tram_stations-open-api?filter=location_id=223 AND zone_id=2 https://api.dubaipulse.gov.ae/shared/rta/rta_tram_stations-open-api?filter=location_id=223 OR zone_id=2
  • Record Limit Sample:
    https://api.dubaipulse.gov.ae/shared/rta/rta_tram_stations-open-api?limit=10
  • Record Offset Sample:
    https://api.dubaipulse.gov.ae/shared/rta/rta_tram_stations-open-api?offset=10
  • Record Order By Sample:
    https://api.dubaipulse.gov.ae/shared/rta/rta_tram_stations-open-api?order_by=location_id
  • Attribute Limiting Sample:
    https://api.dubaipulse.gov.ae/shared/rta/rta_tram_stations-open-api?filter=location_id=223 OR zone_id=2 &column=zone_id,line_name,location_id