SSIS Components for LinkedIn

Build 24.0.9060

GeoLocation

Provides the display name for a given geo Id, or a set of geo Ids.

GeoLocation requires an Id in SELECT statements. For example:

SELECT * FROM geolocation where id = 'urn:li:geo:123456'
To specify multiple geolocation Ids use the IN operator:
SELECT * FROM geolocation WHERE id IN (<List of geolocation ids>)

Columns

Name Type Description
Id [KEY] String Unique identifier for the entity. Can be a single Id or a comma-separated list of Ids.
Country String An uppercase two-letter country code as defined by ISO-3166.
Language String A lowercase two-letter language code as defined by ISO-639.
Value String The value of the display text.

Pseudo-Columns

Pseudo column fields are used in the WHERE clause of SELECT statements and offer a more granular control over the tuples that are returned from the data source.

Name Type Description
LocaleLanguage String The locale language the country data is requested in. A lowercase two-letter language code as defined by ISO-639.

The default value is en.

LocaleCountry String The locale country the country data is requested in. An uppercase two-letter country code as defined by ISO-3166.

The default value is US.

Copyright (c) 2024 CData Software, Inc. - All rights reserved.
Build 24.0.9060