lad_legal_consultancy_firms-open

Published by
Dubai Legal Affairs Department
Number of Data Files / Resources 1
Updated: 15 Apr 2024
Open Data
All current registered legal consultancy firms
Show more
Send Feedback
Legal_Consultancy_Firms.csv
Updated: 15 Apr 2024 File Size : 0.03 MB
CSV
Field Value
Data Provenance Services: New Legal Consultancy Branch Licence, New Sole Establishment Licence, Renewal of legal consultancy firm license ,amendment of legal consultancy firm license. Application: Legal profession system. Tables: tbl_lcfirm
Dataset Source Legal Profision System
Format CSV
Created 17 Mar 2018
Last updated 15 Apr 2024
Frequency of Update on Source RealTime
Frequency of Update to SDP
Weekly
Expected Volume/Ingestion Cycle(Daily if Real-time)
Weekly
Language English~Mix~Mix~English~Mix~English~Mix~English~English~Mix~Mix~Mix
State active
Rights
License notspecified
Show more
Name Description Primary Key Size Datatype Foreign Key Range of Values Language Classification
license_number Unique identification number given to each legal consultancy firm Yes 100 nvarchar N/A English Open
issue_date Date in which the legal consultancy firm first accquired a licence from the Department No datetime Mix Open
expiry_date Expiry date of the firm licence, term of licence is always one (1) calender year No datetime Mix Open
number_of_registered_legal_consultants Number of consultants registered as practising legal consultants within that particular legal consultancy firm No int N/A English Open
address As per the address submitted by the legal consultancy firm to the Department No 45 nvarchar N/A Mix Open
phone_number As per the telephone number submitted by the legal consultancy firm to the Department No 15 nvarchar N/A English Open
licensing_authority the organization that issues the commercial license  No 100 nvarchar N/A Mix Open
authority_license_number the license number Yes 100 nvarchar N/A English Open
email_address email address submitted by the legal consultancy firm to the Department No 45 nvarchar N/A English Open
firm_name Firm name as per the licence issued by the Department No 100 nvarchar N/A Mix Open
name_of_managing_partner Name as per registered managing partner on the Departments issued licence No 100 nvarchar N/A Mix Open
type Entity as per the licence of the relevent licensing authority in the Emirate (including the freezones), (sole establishment, or company established in the Emirate) No smallint branch ,sole , company, partner Mix Open
Show more Show less

Dubai Pulse Data API

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

Endpoints
Expand
Collapse
The Data API can be accessed via the following actions of the CKAN action API.
  • Query
    https://www.dubaipulse.gov.ae/dataset/249d47a2-f08b-4b76-8f2f-06e160ae211e/resource/cdc1c4dd-53c5-49fc-9ea4-60e85e74de7b/download/legal_consultancy_firms.csv
How to Use?
Expand
Collapse
  • 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.
Examples
Expand
Collapse
  • 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