Excel Add-In for LinkedIn

Build 24.0.9062

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

SELECT ステートメントのWHERE 句では、疑似カラムフィールドを使用して、データソースから返されるタプルを詳細に制御することができます。

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.

デフォルト値はenです。

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

デフォルト値はUSです。

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