Number of Data Files / Resources 1
Updated: 16 Dec 2021
Records of inspection visits within Dubai Land.
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 Some Gov. Dept. are integrating with DED in inspections such as (RTA, Dubai Municipality, DTCM and Dubai Police) for license renewal process. Inspection, can cover the individuals and/or institutions carried unauthorized business activities. DED has a group of inspectors and has its own fines. to renew the license, all Governmental fines should be cleared. All inspections are within Dubai Land only, not free zones.
Dataset Source DED DB
Format API
Created 07 Apr 2018
Last updated 16 Dec 2021
Frequency of Update on Source
Frequency of Update to SDP
Weekly
Expected Volume/Ingestion Cycle(Daily if Real-time)
3000-4000
Language English~Arabic~English~English~Arabic~English~English~English~English~English~Arabic~English~English~Arabic~English~English~English
State active
Rights N/A
License notspecified
Name Description Primary Key Size Datatype Foreign Key Range of Values Language Classification
inspection_result_code Inspection result code No 2 NUMBER English Open
result_ar Inspection result No 30 VARCHAR2 Arabic Open
result_en Inspection result No 30 VARCHAR2 English Open
inspection_reason_code Inspection reason code No 2 NUMBER English Open
reason_ar Inspection reason No 30 VARCHAR2 Arabic Open
reason_en Inspection reason No 30 VARCHAR2 English Open
inspection_status Inspection status code No 2 CHAR English Open
inspection_report_serial Inspection report number Yes 8 NUMBER English Open
inspector_code Inspector ID No 6 NUMBER English Open
inspection_type_code Inspection type code Yes 2 NUMBER English Open
inspection_type_ar Inspection type No 40 VARCHAR2 Arabic Open
inspection_type_en Inspection type No 40 VARCHAR2 English Open
license_no License number No 10 NUMBER English Open
status_ar Inspection status No 150 VARCHAR2 Arabic Open
status_en Inspection status No 150 VARCHAR2 English Open
report_date Inspection report date No Date English Open
offender_id Offender Id ( in case the offender is not license) No NUMBER English 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/ded/ded_inspection_report-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?order_by=primary_key_attribute&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