`

Matillion ETL Data Model for LinkedIn
Version - 18.0.6886

Note: Data models are true for the latest version of Matillion ETL. If you are on an older version or using a component from an old job, your experience may differ.




Connection String OptionsBack To Top

  1. Auto Cache
  2. Batch Size
  3. Cache Connection
  4. Cache Driver
  5. Cache Location
  6. Cache Metadata
  7. Cache Query Result
  8. Callback URL
  9. Company Id
  10. Connection Life Time
  11. Connect On Open
  12. Firewall Password
  13. Firewall Port
  14. Firewall Server
  15. Firewall Type
  16. Firewall User
  17. Initiate OAuth
  18. Location
  19. Logfile
  20. Max Log File Size
  21. Max Rows
  22. OAuth Access Token
  23. OAuth Client Id
  24. OAuth Client Secret
  25. OAuth Scope
  26. OAuth Settings Location
  27. OAuth Verifier
  28. Offline
  29. Other
  30. Page Size
  31. Pool Idle Timeout
  32. Pool Max Size
  33. Pool Min Size
  34. Pool Wait Time
  35. Proxy Auth Scheme
  36. Proxy Auto Detect
  37. Proxy Exceptions
  38. Proxy Password
  39. Proxy Port
  40. Proxy Server
  41. Proxy SSL Type
  42. Proxy User
  43. Pseudo Columns
  44. Readonly
  45. RTK
  46. SSL Server Cert
  47. Support Enhanced SQL
  48. Tables
  49. Timeout
  50. Use Connection Pooling
  51. Verbosity
  52. Views



Auto Cache

Automatically caches the results of SELECT queries into a cache database specified by either CacheLocation or both of CacheConnection and CacheProvider . Configured with CacheQueryResult .
Data Type

bool

Default Value

false

Remarks

When AutoCache is set, the driver automatically maintains a cache of your table's data in the database of your choice. With CacheQueryResult additionally set, the driver updates the cache when you execute a SELECT query and returns the live results from the LinkedIn data.

Explicitly Caching SELECT Results

CacheQueryResult is a way to query LinkedIn in real time while maintaining a cache for offline use. Set CacheQueryResult to update the cache whenever you execute a SELECT statement. When you execute a SELECT statement with AutoCache and CacheQueryResult set, the driver executes the query to the remote data and caches the results; rows that already exist are overwritten. That is, SELECT statements are used to create and refresh the cache, not to query it. Data manipulation commands are executed to the remote data as well.

To query the cached data, set the Offline property. If you need to query the cached data in an online connection, you can append #CACHE to the table name. For example:

SELECT * FROM [CompanyStatusUpdates#CACHE]

Setting the Caching Database

When AutoCache is set, the driver caches to a simple, file-based cache. You can configure its location or cache to a different database with the following properties:

See Also





Batch Size

The maximum size of each batch operation to submit.
Data Type

int

Default Value

0

Remarks

When BatchSize is set to a value greater than 0, the batch operation will split the entire batch into separate batches of size BatchSize. The split batches will then be submitted to the server individually. This is useful when the server has limitations on the size of the request that can be submitted.

Setting BatchSize to 0 will submit the entire batch as specified.





Cache Connection

The connection string for the cache database. Always used in conjunction with CacheProvider . Setting both properties will override the value set for CacheLocation for caching data.
Data Type

string

Default Value

""

Remarks

The cache database is determined based on the CacheDriver and CacheConnection properties. Both properies are required to use the cache database. Examples of common cache database settings can be found below. For more information on setting the caching database's driver, refer to CacheDriver.

The connection string specified in the CacheConnection property is passed directly to the underlying CacheDriver. Consult the documentation for the specific JDBC driver for more information on the available properties. Make sure to include the JDBC driver in your application's classpath.

Derby and Java DB

The driver simplifies caching to Derby, only requiring you to set the CacheLocation property to make a basic connection.

Alternatively, you can configure the connection to Derby manually using CacheProvider and CacheConnection. Below is the Derby JDBC URL syntax:

jdbc:derby:[subsubprotocol:][databaseName][;attribute=value[;attribute=value] ... ]
For example, to cache to an in-memory database, use the following:
jdbc:derby:memory

SQLite

To cache to SQLite, you can use the SQLite JDBC driver. Below is the syntax of the JDBC URL:

jdbc:sqlite:dataSource

MySQL

The installation includes the CData JDBC Driver for MySQL. Below is an example JDBC URL:

jdbc:mysql:User=root;Password=root;Server=localhost;Port=3306;Database=cache
Below are typical connection properties:

SQL Server

The JDBC URL for the Microsoft JDBC Driver for SQL Server has the following syntax:

jdbc:sqlserver://[serverName[\instance][:port]][;database=databaseName][;property=value[;property=value] ... ]
For example:
jdbc:sqlserver://localhost\sqlexpress:1433;integratedSecurity=true
Below are typical SQL Server connection properties:
Oracle

Below is the conventional JDBC URL syntax for the Oracle JDBC Thin driver:

jdbc:oracle:thin:[userId/password]@[//]host[[:port][:sid]]
For example:
jdbc:oracle:thin:scott/tiger@myhost:1521:orcl
Below are typical connection properties:
PostgreSQL

Below is the JDBC URL syntax for the official PostgreSQL JDBC driver:

jdbc:postgresql:[//[host[:port]]/]database[[?option=value][[&option=value][&option=value] ... ]]
For example, the following connection string connects to a database on the default host (localhost) and port (5432):
jdbc:postgresql:postgres
Below are typical connection properties:





Cache Driver

The database driver to be used to cache data.
Data Type

string

Default Value

""

Remarks

You can cache to any database for which you have a JDBC driver, including CData JDBC drivers.

The cache database is determined based on the CacheDriver and CacheConnection properties. The CacheDriver is the name of the JDBC driver class that you would like to use to cache data.

Note that you must also add the CacheDriver JAR to the classpath.

The following examples show how to cache to several major databases. Refer to CacheConnection for more information on the JDBC URL syntax and typical connection properties.

Derby and Java DB

The driver simplifies Derby configuration. Java DB is the Oracle distribution of Derby. The JAR is shipped in the JDK. You can find the JAR, derby.jar, in the db subfolder of the JDK installation. In most caching scenarios, you need to specify only the following, after adding derby.jar to the classpath.

jdbc:linkedin:CacheLocation='c:/Temp/cachedir';InitiateOAuth=GETANDREFRESH;OAuthClientId=MyOAuthClientId;OAuthClientSecret=MyOAuthClientSecret;CallbackURL=http://localhost:portNumber;CompanyId=XXXXXXX
To customize the Derby JDBC URL, use CacheDriver and CacheConnection. For example, to cache to an in-memory database, use a JDBC URL like the following:
jdbc:linkedin:CacheDriver=org.apache.derby.jdbc.EmbeddedDriver;CacheConnection='jdbc:derby:memory';InitiateOAuth=GETANDREFRESH;OAuthClientId=MyOAuthClientId;OAuthClientSecret=MyOAuthClientSecret;CallbackURL=http://localhost:portNumber;CompanyId=XXXXXXX
SQLite

Below is a JDBC URL for the SQLite JDBC driver:

jdbc:linkedin:CacheDriver=org.sqlite.JDBC;CacheConnection='jdbc:sqlite:C:/Temp/sqlite.db';InitiateOAuth=GETANDREFRESH;OAuthClientId=MyOAuthClientId;OAuthClientSecret=MyOAuthClientSecret;CallbackURL=http://localhost:portNumber;CompanyId=XXXXXXX
MySQL

Below is a JDBC URL for the included CData JDBC Driver for MySQL:

  jdbc:linkedin:Cache Driver=cdata.jdbc.mysql.MySQLDriver;Cache Connection='jdbc:mysql:Server=localhost;Port=3306;Database=cache;User=root;Password=123456';InitiateOAuth=GETANDREFRESH;OAuthClientId=MyOAuthClientId;OAuthClientSecret=MyOAuthClientSecret;CallbackURL=http://localhost:portNumber;CompanyId=XXXXXXX
  
The CData JDBC Driver for MySQL is located in the lib subfolder of the CData JDBC Driver for LinkedIn 2018 installation directory.
SQL Server

The following JDBC URL uses the Microsoft JDBC Driver for SQL Server:

jdbc:linkedin:Cache Driver=com.microsoft.sqlserver.jdbc.SQLServerDriver;Cache Connection='jdbc:sqlserver://localhost\sqlexpress:7437;user=sa;password=123456;databaseName=Cache';InitiateOAuth=GETANDREFRESH;OAuthClientId=MyOAuthClientId;OAuthClientSecret=MyOAuthClientSecret;CallbackURL=http://localhost:portNumber;CompanyId=XXXXXXX
Oracle

Below is a JDBC URL for the Oracle Thin Client:

jdbc:linkedin:Cache Driver=oracle.jdbc.driver.OracleDriver;CacheConnection='jdbc:oracle:thin:scott/tiger@localhost:1521:orcldb';InitiateOAuth=GETANDREFRESH;OAuthClientId=MyOAuthClientId;OAuthClientSecret=MyOAuthClientSecret;CallbackURL=http://localhost:portNumber;CompanyId=XXXXXXX
PostgreSQL

The following JDBC URL uses the official PostgreSQL JDBC driver:

jdbc:linkedin:CacheDriver=org.postgresql.Driver;CacheConnection='jdbc:postgresql://localhost:5433/postgres?user=postgres&password=admin';InitiateOAuth=GETANDREFRESH;OAuthClientId=MyOAuthClientId;OAuthClientSecret=MyOAuthClientSecret;CallbackURL=http://localhost:portNumber;CompanyId=XXXXXXX





Cache Location

Specifies the path to the cache when caching to a file.
Data Type

string

Default Value

""

Remarks

The CacheLocation is a simple, file-based cache. The driver uses Java DB, Oracle's distribution of the Derby database. To cache to Java DB, you will need to add the Java DB JAR to the classpath. The JAR, derby.jar, is shipped in the JDK and located in the db subfolder of the JDK installation.

CacheLocation defaults to the directory specified by the Location setting.

See Also





Cache Metadata

Whether or not to cache the table metadata to a file store.
Data Type

bool

Default Value

false

Remarks

As you execute queries with this property set, table metadata in the LinkedIn catalog are cached to the file store specified by CacheLocation if set or the user's home directory otherwise. A table's metadata will be retrieved only once, when the table is queried for the first time.

When to Use CacheMetadata

The driver automatically persists metadata in memory for up to two hours when you first discover the metadata for a table or view and therefore, CacheMetadata is generally not required. CacheMetadata becomes useful when metadata operations are expensive such as when you are working with large amounts of metadata or when you have many short-lived connections.

When Not to Use CacheMetadata





Cache Query Result

With AutoCache set, caches each row read from a SELECT query's results. Without this, the provider will attempt to fully replicate the table before executing the actual query against the replication database.
Data Type

bool

Default Value

false

Remarks

When CacheQueryResult and AutoCache are set, the rows returned from a SELECT query are cached in the cache database. The driver handles caching in a streaming fashion with each row being processed into the cache database from the original result set as you read the row from the returned ResultSet object. This ensures that the live data is not queried twice. Note that any rows you do not read from the returned ResultSet will not be updated in the cache.





Callback URL

The OAuth callback URL to return to when authenticating. This value must match the callback URL you specify in your app settings.
Data Type

string

Default Value

""

Remarks

During the authentication process, the OAuth authorization server redirects the user to this URL. This value must match the callback URL you specify in your app settings.





Company Id

The company Id of the currently logged on user.
Data Type

string

Default Value

""

Remarks

This property must be set in the connection string or query. Otherwise, the driver will use the first found company Id.





Connection Life Time

The maximum lifetime of a connection in seconds. Once the time has elapsed, the connection object is disposed.
Data Type

string

Default Value

"0"

Remarks

The maximum lifetime of a connection in seconds. Once the time has elapsed, the connection object is disposed. The default is 0 which indicates there is no limit to the connection lifetime.





Connect On Open

Species whether to connect to the LinkedIn when the connection is opened.
Data Type

bool

Default Value

false

Remarks

When set to 'true', a connection will be made to LinkedIn when the connection is opened. This property enables the 'Test Connection' feature available in various database tools.

This feature acts as a NOOP command as it is used to verify a connection can be made to LinkedIn and nothing from this initial connection is maintained.

Setting this property to 'false' may provide performance improvements (depending upon the number of times a connection is opened).





Firewall Password

A password used to authenticate to a proxy-based firewall.
Data Type

string

Default Value

""

Remarks

This property is passed to the proxy specified by FirewallServer and FirewallPort, following the authentication method specified by FirewallType.





Firewall Port

The TCP port for a proxy-based firewall.
Data Type

string

Default Value

""

Remarks

This specifies the TCP port for a proxy allowing traversal of a firewall. Use FirewallServer to specify the name or IP address. Specify the protocol with FirewallType.





Firewall Server

The name or IP address of a proxy-based firewall.
Data Type

string

Default Value

""

Remarks

This property specifies the IP address, DNS name, or host name of a proxy allowing traversal of a firewall. The protocol is specified by FirewallType: Use FirewallServer with this property to connect through SOCKS or do tunneling. Use ProxyServer to connect to an HTTP proxy.

Note that the driver uses the system proxy by default. To use a different proxy, set ProxyAutoDetect to false.





Firewall Type

The protocol used by a proxy-based firewall.
Data Type

string

Default Value

"NONE"

Remarks

This property specifies the protocol that the driver will use to tunnel traffic through the FirewallServer proxy. Note that by default the driver connects to the system proxy; to disable this behavior and connect to one of the following proxy types, set ProxyAutoDetect to false.

Type Default Port Description
TUNNEL 80 When this is set, the driver opens a connection to LinkedIn and traffic flows back and forth through the proxy.
SOCKS4 1080 When this is set, the driver sends data through the SOCKS 4 proxy specified by FirewallServer and FirewallPort and passes the FirewallUser value to the proxy, which determines if the connection request should be granted.
SOCKS5 1080 When this is set, the driver sends data through the SOCKS 5 proxy specified by FirewallServer and FirewallPort. If your proxy requires authentication, set FirewallUser and FirewallPassword to credentials the proxy recognizes.

To connect to HTTP proxies, use ProxyServer and ProxyPort. To authenticate to HTTP proxies, use ProxyAuthScheme, ProxyUser, and ProxyPassword.





Firewall User

The user name to use to authenticate with a proxy-based firewall.
Data Type

string

Default Value

""

Remarks

The FirewallUser and FirewallPassword properties are used to authenticate against the proxy specified in FirewallServer and FirewallPort, following the authentication method specified in FirewallType.





Initiate OAuth

Set this property to initiate the process to obtain or refresh the OAuth access token when you connect.
Data Type

string

Default Value

"OFF"

Remarks

The following options are available:

  1. OFF: Indicates that the OAuth flow will be handled entirely by the user. An OAuthAccessToken will be required to authenticate.
  2. GETANDREFRESH: Indicates that the entire OAuth Flow will be handled by the driver. If no token currently exists, it will be obtained by prompting the user via the browser. If a token exists, it will be refreshed when applicable.





Location

A path to the directory that contains the schema files defining tables, views, and stored procedures.
Data Type

string

Default Value

""

Remarks

The path to a directory which contains the schema files for the driver (.rsd files for tables and views, .rsb files for stored procedures). The Location property is only needed if you would like to customize definitions (e.g., change a column name, ignore a column, etc.) or extend the data model with new tables, views, or stored procedures.

The schema files are deployed alongside the driver assemblies. You must also ensure that Location points to the folder that contains the schema files. The folder location can be a relative path from the location of the executable.





Logfile

A path to the log file.
Data Type

string

Default Value

""

Remarks

For more control over what is written to the log file, take a look at Verbosity.





Max Log File Size

A string specifying the maximum size in bytes for a log file (ex: 10MB). When the limit is hit, a new log is created in the same folder with the date and time appended to the end.
Data Type

string

Default Value

"100MB"

Remarks

A string specifying the maximum size in bytes for a log file (ex: 10MB). When the limit is hit, a new log is created in the same folder with the date and time appended to the end. The default limit is 100MB. Values lower than 100kB will use 100kB as the value instead.





Max Rows

Limits the number of rows returned rows when no aggregation or group by is used in the query. This helps avoid performance issues at design time.
Data Type

string

Default Value

"-1"

Remarks

Limits the number of rows returned rows when no aggregation or group by is used in the query. This helps avoid performance issues at design time.





OAuth Access Token

The access token for connecting using OAuth.
Data Type

string

Default Value

""

Remarks

The OAuthAccessToken property is used to connect using OAuth. The OAuthAccessToken is retrieved from the OAuth server as part of the authentication process. It has a server-dependent timeout and can be reused between requests.

The access token is used in place of your username and password. The access token protects your credentials by keeping them on the server.





OAuth Client Id

The client Id assigned when you register your application with an OAuth authorization server.
Data Type

string

Default Value

""

Remarks

As part of registering an OAuth application, you will receive the OAuthClientId value, sometimes also called a consumer key, and a client secret, the OAuthClientSecret.





OAuth Client Secret

The client secret assigned when you register your application with an OAuth authorization server.
Data Type

string

Default Value

""

Remarks

As part of registering an OAuth application, you will receive the OAuthClientId, also called a consumer key. You will also receive a client secret, also called a consumer secret. Set the client secret in the OAuthClientSecret property.





OAuth Scope

A specific scope that the user requires the access token.
Data Type

string

Default Value

""

Remarks

This property must be set in the connection string or query to get a scoped token with specific privileges.





OAuth Settings Location

The location of the settings file where OAuth values are saved when InitiateOAuth is set to GETANDREFRESH or REFRESH. Alternatively, this can be held in memory by specifying a value starting with memory://.
Data Type

string

Default Value

"%APPDATA%\\CData\\LinkedIn Data Provider\\OAuthSettings.txt"

Remarks

When InitiateOAuth is set to GETANDREFRESH or REFRESH, the driver saves OAuth values to avoid requiring the user to manually enter OAuth connection properties and allowing the credentials to be shared across connections or processes. The default OAuthSettingsLocation is a settings file located in the %AppData%\CData folder. Alternatively to specifying a file path, memory storage can be used instead. Memory locations are specified by using a value starting with 'memory://' followed by a unique identifier for that set of credentials (ex: memory://user1). The identifier can be anything you choose but should be unique to the user. Unlike with the file based storage, you must manually store the credentials when closing the connection with memory storage to be able to set them in the connection when the process is started again. The OAuth property values can be retrieved with a query to the sys_connection_props system table. If there are multiple connections using the same credentials, the properties should be read from the last connection to be closed.





OAuth Verifier

The verifier code returned from the OAuth authorization URL.
Data Type

string

Default Value

""

Remarks

The verifier code returned from the OAuth authorization URL. This can be used on systems where a browser cannot be launched such as headless systems.

Authentication on Headless Machines

See the Getting Started section to obtain the OAuthVerifier value.

Set OAuthSettingsLocation along with OAuthVerifier. When you connect, the driver exchanges the OAuthVerifier for the OAuth authentication tokens and saves them, encrypted, to the specified file. Set InitiateOAuth to GETANDREFRESH automate the exchange.

Once the OAuth settings file has been generated, you can remove OAuthVerifier from the connection properties and connect with OAuthSettingsLocation set.

To automatically refresh the OAuth token values, set OAuthSettingsLocation and additionally set InitiateOAuth to REFRESH.





Offline

Use offline mode to get the data from the cache instead of the live source.
Data Type

bool

Default Value

false

Remarks

When Offline is set to TRUE, all queries execute against the cache as opposed to the live data source. In this mode, certain queries like INSERT, UPDATE, DELETE, and CACHE are not allowed.





Other

Hidden properties needed only in specific use cases.
Data Type

string

Default Value

""

Remarks

The properties listed below are available for specific use cases. Normal driver use cases and functionality should not require these properties.

Specify multiple properties in a semicolon-separated list.

Caching Configuration

CachePartial=TrueCaches only a subset of columns, which you can specify in your query.
QueryPassthrough=TruePasses the specified query to the cache database instead of using the SQL parser of the driver.

Integration and Formatting

DefaultColumnSizeSets the default length of string fields when the data source does not provide column length in the metadata. The default value is 2000.
ConvertDateTimeToGMTWhether to convert date-time values to GMT, instead of the local time of the machine.
RecordToFile=filenameRecords the underlying socket data transfer to the specified file.





Page Size

The number of results to return per page from LinkedIn.
Data Type

string

Default Value

"100"

Remarks

The PageSize can control the number of results requested from Marketo on a given query. Setting a higher PageSize will cause more data to come back in a given request, but may take longer to execute. Setting a smaller PageSize is generally recommended to ensure timeout exceptions do not occur.

By default PageSize will be 100 for all subsequent requests.





Pool Idle Timeout

The allowed idle time for a connection before it is closed.
Data Type

string

Default Value

""

Remarks

The allowed idle time a connection can remain in the pool until the connection is closed. The default is 60 seconds.





Pool Max Size

The maximum connections in the pool.
Data Type

string

Default Value

"100"

Remarks

The maximum connections in the pool. The default is 100. To disable this property, set the property value to 0 or less.





Pool Min Size

The minimum number of connections in the pool.
Data Type

string

Default Value

"1"

Remarks

The minimum number of connections in the pool. The default is 1.





Pool Wait Time

The max seconds to wait for an available connection.
Data Type

string

Default Value

""

Remarks

The max seconds to wait for a connection to become available. If a new connection request is waiting for an available connection and exceeds this time, an error is thrown. By default, new requests wait forever for an available connection.





Proxy Auth Scheme

The authentication type to use to authenticate to the ProxyServer proxy.
Data Type

string

Default Value

"BASIC"

Remarks

This value specifies the authentication type to use to authenticate to the HTTP proxy specified by ProxyServer and ProxyPort.

Note that the driver will use the system proxy settings by default, without further configuration needed; if you want to connect to another proxy, you will need to set ProxyAutoDetect to false, in addition to ProxyServer and ProxyPort. To authenticate, set ProxyAuthScheme and set ProxyUser and ProxyPassword, if needed.

The authentication type can be one of the following:

If you need to use another authentication type, such as SOCKS 5 authentication, see FirewallType.





Proxy Auto Detect

This indicates whether to use the system proxy settings or not. Set ProxyAutoDetect to FALSE to use custom proxy settings. This takes precedence over other proxy settings.
Data Type

bool

Default Value

true

Remarks

By default, the driver uses the system HTTP proxy. Set this to false if you want to connect to another proxy.

To connect to an HTTP proxy, see ProxyServer.

For other proxies, such as SOCKS or tunneling, see FirewallType.





Proxy Exceptions

A semicolon separated list of hosts or IPs that will be exempt from connecting through the ProxyServer .
Data Type

string

Default Value

""

Remarks

The ProxyServer will be used for all addresses, except for addresses defined in this property. Use semicolons to separate entries.

Note that the driver will use the system proxy settings by default, without further configuration needed; if you want to explicitly configure proxy exceptions for this connection, you will need to set ProxyAutoDetect to false, and configure ProxyServer and ProxyPort. To authenticate, set ProxyAuthScheme and set ProxyUser and ProxyPassword, if needed.





Proxy Password

A password to be used to authenticate to the ProxyServer proxy.
Data Type

string

Default Value

""

Remarks

This property is used to authenticate to an HTTP proxy server that supports NTLM (Windows), Kerberos, or HTTP authentication. To specify the HTTP proxy, you can set ProxyServer and ProxyPort. To specify the authentication type, set ProxyAuthScheme.

If you are using HTTP authentication, additionally set ProxyUser and ProxyPassword to HTTP proxy.

If you are using NTLM authentication, set ProxyUser and ProxyPassword to your Windows password. You may also need these to complete Kerberos authentication.

For SOCKS 5 authentication or tunneling, see FirewallType.

By default, the driver uses the system proxy. If you want to connect to another proxy, set ProxyAutoDetect to false.





Proxy Port

The TCP port the ProxyServer proxy is running on.
Data Type

string

Default Value

"80"

Remarks

The port the HTTP proxy is running on that you want to redirect HTTP traffic through. Specify the HTTP proxy in ProxyServer. For other proxy types, see FirewallType.





Proxy Server

The hostname or IP address of a proxy to route HTTP traffic through.
Data Type

string

Default Value

""

Remarks

The hostname or IP address of a proxy to route HTTP traffic through. The driver can use the HTTP, Windows (NTLM), or Kerberos authentication types to authenticate to an HTTP proxy.

If you need to connect through a SOCKS proxy or tunnel the connection, see FirewallType.

By default, the driver uses the system proxy. If you need to use another proxy, set ProxyAutoDetect to false.





Proxy SSL Type

The SSL type to use when connecting to the ProxyServer proxy.
Data Type

string

Default Value

"AUTO"

Remarks

This property determines when to use SSL for the connection to an HTTP proxy specified by ProxyServer. This value can be AUTO, ALWAYS, NEVER, or TUNNEL. The applicable values are the following:

AUTODefault setting. If the URL is an HTTPS URL, the driver will use the TUNNEL option. If the URL is an HTTP URL, the component will use the NEVER option.
ALWAYSThe connection is always SSL enabled.
NEVERThe connection is not SSL enabled.
TUNNELThe connection is through a tunneling proxy: The proxy server opens a connection to the remote host and traffic flows back and forth through the proxy.





Proxy User

A user name to be used to authenticate to the ProxyServer proxy.
Data Type

string

Default Value

""

Remarks

The ProxyUser and ProxyPassword options are used to connect and authenticate against the HTTP proxy specified in ProxyServer.

You can select one of the available authentication types in ProxyAuthScheme. If you are using HTTP authentication, set this to the username of a user recognized by the HTTP proxy. If you are using Windows or Kerberos authentication, set this property to a username in one of the following formats:

user@domain
domain\user





Pseudo Columns

Indicates whether or not to include pseudo columns as columns to the table.
Data Type

string

Default Value

""

Remarks

This setting is particularly helpful in Entity Framework, which does not allow you to set a value for a pseudo column unless it is a table column. The value of this connection setting is of the format "Table1=Column1, Table1=Column2, Table2=Column3". You can use the "*" character to include all tables and all columns; i.e., "*=*".





Readonly

You can use this property to enforce read-only access to LinkedIn from the provider.
Data Type

bool

Default Value

false

Remarks

If this property is set to true, the driver will allow only SELECT queries. INSERT, UPDATE, DELETE, and stored procedure queries will cause an error to be thrown.





RTK

The runtime key used for licensing.
Data Type

string

Default Value

""

Remarks

The RTK property may be used to license a build. Please see the included licensing file to see how to set this property. The runtime key is only available if you purchased an OEM license.





SSL Server Cert

The certificate to be accepted from the server when connecting using TLS/SSL.
Data Type

string

Default Value

""

Remarks

If using a TLS/SSL connection, this property can be used to specify the TLS/SSL certificate to be accepted from the server. Any other certificate that is not trusted by the machine will be rejected.

This property can take the forms:

Description Example
A full PEM Certificate (example shortened for brevity) -----BEGIN CERTIFICATE----- MIIChTCCAe4CAQAwDQYJKoZIhv......Qw== -----END CERTIFICATE-----
A path to a local file containing the certificate C:\cert.cer
The public key (example shortened for brevity) -----BEGIN RSA PUBLIC KEY----- MIGfMA0GCSq......AQAB -----END RSA PUBLIC KEY-----
The MD5 Thumbprint (hex values can also be either space or colon separated) ecadbdda5a1529c58a1e9e09828d70e4
The SHA1 Thumbprint (hex values can also be either space or colon separated) 34a929226ae0819f2ec14b4a3d904f801cbb150d

If not specified, any certificate trusted by the machine will be accepted. Use '*' to signify to accept all certificates (not recommended for security concerns).





Support Enhanced SQL

Enhances SQL functionality beyond what can be supported through the API directly, by enabling in-memory client-side processing.
Data Type

bool

Default Value

true

Remarks

When SupportEnhancedSQL is set to true, the driver offloads as much of the SELECT statement processing as possible to LinkedIn and then processes the rest of the query in memory. In this way the driver can execute unsupported predicates, joins, and aggregation.

When SupportEnhancedSQL is set to false, the driver limits SQL execution to what is supported by the LinkedIn API.

Execution of Predicates

The driver determines which of the clauses are supported by the data source and then pushes them to the source to get the smallest superset of rows that would satisfy the query. It then filters the rest of the rows locally. The filter operation is streamed, which enables the driver to filter effectively for even very large datasets.

Execution of Joins

The driver uses various techniques to join in memory. The driver trades off memory utilization against the requirement of reading the same table more than once.

Execution of Aggregates

The driver retrieves all rows necessary to process the aggregation in memory.





Tables

Restrict the tables reported to a subset of the available tables. For example: Tables=TableA,TableB,TableC.
Data Type

string

Default Value

""

Remarks

Listing the tables from some databases can be expensive. Providing a list of tables in the connection string improves the performance of the driver.

This property can also be used as an alternative to automatically listing views if you already know which ones you want to work with and there would otherwise be too many to work with.

Specify the tables you want in a comma-separated list. For example: Tables=TableA,TableB,TableC





Timeout

The value in seconds until the timeout error is thrown, canceling the operation.
Data Type

string

Default Value

"60"

Remarks

If the Timeout property is set to 0, operations do not time out: They run until they complete successfully or encounter an error condition.

If Timeout expires and the operation is not yet complete, the driver throws an exception.





Use Connection Pooling

Enables connection pooling.
Data Type

bool

Default Value

false

Remarks

Enables connection pooling. The default is false. See Connection Pooling for information on using connection pools.





Verbosity

The verbosity level that determines the amount of detail included in the log file.
Data Type

string

Default Value

"1"

Remarks

The verbosity level determines the amount of detail that the driver reports to the Logfile. Verbosity levels from 1 to 5 are supported. These are described below:

1Setting Verbosity to 1 will log the query, the number of rows returned by it, the start of execution and the time taken, and any errors.
2Setting Verbosity to 2 will log everything included in Verbosity 1, cache queries, and additional information about the request, if applicable, such as HTTP headers.
3Setting Verbosity to 3 will additionally log the body of the request and the response.
4Setting Verbosity to 4 will additionally log transport-level communication with the data source. This includes SSL negotiation.
5Setting Verbosity to 5 will additionally log communication with the data source and additional details that may be helpful in troubleshooting problems. This includes interface commands.

The Verbosity should not be set to greater than 1 for normal operation. Substantial amounts of data can be logged at higher verbosities, which can delay execution times.





Views

Restrict the views reported to a subset of the available tables. For example: Views=ViewsA,ViewsB,ViewsC.
Data Type

string

Default Value

""

Remarks

Listing the views from some databases can be expensive. Providing a list of views in the connection string improves the performance of the driver.

This property can also be used as an alternative to automatically listing views if you already know which ones you want to work with and there would otherwise be too many to work with.

Specify the views you want in a comma-separated list. For example: For example: Views=ViewsA,ViewsB,ViewsC





TablesBack To Top

  1. CompanyStatusUpdates



CompanyStatusUpdates

Lists update events from the LinkedIn company page. This table supports the SELECT and INSERT operations.

Select

The CompanyStatusUpdates table supports only the CompanyId column in the WHERE clause. The supported operator for the CompanyId column is =. For example:

SELECT * FROM CompanyStatusUpdates WHERE CompanyId='183432'
Insert

To share an update you must specify the Comment and VisibilityCode fields. Optional fields are SubmittedUrl, SubmittedImageUrl, and Title. (In the case that only Comment and VisibilityCode are specified, reference a URL in the comment.)

INSERT INTO CompanyStatusUpdates(Comment,VisibilityCode) VALUES ('Check out developer.linkedin.com! http://linkd.in/1FC2PyG','anyone')
Columns

Name Type ReadOnly Description
Id [KEY] String False

The unique identifier for the update.

Title String False

The title of the content being shared.

Comment String False

Comment associated with update status.

Description String False

The description of the content being shared.

CompanyId String False

Id of the Company associated with the update.

LikeCount Integer False

Number of likes for the update.

CommentCount Integer False

Number of comments for the update.

Date Datetime False

Update created time .

SubmittedUrl String False

A fully qualified URL for the content being shared.

SubmittedImageUrl String False

A fully qualified URL to a thumbnail image to accompany the shared content. The image should be at least 80 x 150px for best results. 2MB max filesize.

UpdateType String False

Update type.

VisibilityCode String False

One of the following values: anyone: Share will be visible to all members. connections-only: Share will only be visible to connections of the member performing the share. This field is required in all sharing calls.

isCommentable Boolean False

It specifies whether the update is commentable or not.

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
Rows@Next String

Identifier for the next page of results. Do not set this value manually.





ViewsBack To Top

  1. AdAccounts
  2. AdAnalytics
  3. AdAudienceCount
  4. AdBudgetPricing
  5. AdCampaignGroups
  6. AdCampaigns
  7. AdCreatives
  8. AdDegrees
  9. AdFieldsOfStudy
  10. AdIndustries
  11. AdJobFunctions
  12. AdLocations
  13. AdSeniorities
  14. AdSkills
  15. AdSupplyForecast
  16. AdTitles
  17. Comments
  18. CompanyDetails
  19. CompanyFollowerCount
  20. CompanyFollowerStatistics
  21. CompanyJobUpdates
  22. CompanyList
  23. CompanyLocations
  24. CompanyUpdateStatistics
  25. Positions
  26. Profile



AdAccounts

The Ad Account status finder returns all accounts in a specified status that the authenticated user has access to.

Table Specific Information
Select

The AdAccounts view returns a list of the accounts that belong to the authenticated user so they can be used as dimensions in analytic requests.

The driver uses the LinkedIn API to process search criteria that refer to the Status column. The driver processes other filters client-side within the driver. For example, the following queries are processed server side.

SELECT * FROM AdAccounts

SELECT * FROM AdAccounts WHERE Status='ACTIVE'
You can turn off the client-side execution of the query by setting SupportEnhancedSQL to false in which case any search criteria will be ignored and an unfiltered response will be returned.
Columns

Name Type Description
Id [KEY] Long Id of the account
Name String A label for the account
Currency String The account's ISO-4217currency code.
Type String The type of account.
TotalBudgetAmount String The total amount of the budget
TotalBudgetCurrency String The currency of the budget
NotifiedOnCreativeRejection Boolean Indicates if creative contact is notified when a creative has been rejected due to content.
NotifiedOnEndOfCampaign Boolean Indicates if campaign contact is notified when an associated campaign has been completed.
Status String Status of the account

The allowed values are ACTIVE, PENDING_CANCELLATION, CANCELED, DRAFT.

NotifiedOnCampaignOptimization Boolean Indicates if campaign contact is notified about campaign optimization opportunities.
Version String Version of the account
TotalBudgetEndsAt Integer The amount when the total budget ends
Reference String The entity on whose behalf the account advertises.
NotifiedOnCreativeApproval Boolean Indicates if creative contact is notified when a creative has been reviewed and approved.
AuditStampsCreator String The person who created audit stamps for the first time
AuditStampsCreatedAt Datetime The datetime in which the audit stamp was created first
AuditStampsLastModifier String Last modifier of the Audit stamps
AuditStampsLastModifiedAt Datetime Last modified datetime of the audit stamps





AdAnalytics

The Ad Analytics API provides account, campaign, and creative level insights on click intelligence numbers.

Table Specific Information
Select

The AdAnalytics view provides account, campaign, and creative level insights on click intelligence numbers. Examples of these insights include clicks, shares, and impressions.

The driver uses the LinkedIn API to process search criteria. The driver processes other filters client-side within the driver. For example, the following queries are processed server side.

SELECT StartPeriod, EndPeriod, Clicks, Impressions, Follows, TotalEngagements From AdAnalytics WHERE StartDate='07/20/2016' AND Account='123456789' AND Granularity='MONTHLY'
Select Rules

Ad analytic reports:

Dimensions Required RequestType, StartDate, Granularity
Optional EndDate, CampaignType
If RequestType is Analytics Use 0 or 1 (Default is Campaign) Company, Account, Share, Campaign, CampaignGroup, Creative, Conversion, ServingLocation, CardIndex, MemberCompanySize, MemberIndustry, MemberSeniority, MemberJobTitle, MemberJobFunction, MemberCountry, MemberRegion, MemberCompany
If RequestType is Statistics Use 1 or 2 (Default is Campaign) Company, Account, Share, Campaign, CampaignGroup, Creative, Conversion, ServingLocation, CardIndex

Note: The default value for RequestType will be Analytics. The default value for Granularity will be MONTHLY. The default time window will be the last year period.

Metrics Use 1 or more ActionClicks,AdUnitClicks,CardClicks,CardImpressions,Clicks,CommentLikes,Comments,CompanyPageClicks,ConversionValueInLocalCurrency,CostInLocalCurrency,CostInUsd,StartPeriod,EndPeriod,ExternalWebsiteConversions,ExternalWebsitePostClickConversions,ExternalWebsitePostViewConversions,Follows,FullScreenPlays,Impressions,LandingPageClicks,LeadGenerationMailContactInfoShares,LeadGenerationMailInterestedClicks,Likes,OneClickLeadFormOpens,OneClickLeads,Opens,OtherEngagements,Pivot,PivotValue,Shares,TextUrlClicks,TotalEngagements,VideoCompletions,VideoFirstQuartileCompletions,VideoMidpointCompletions,VideoStarts,VideoThirdQuartileCompletions,VideoViews,ViralCardClicks,ViralCardImpressions,ViralClicks,ViralComments,ViralCompanyPageClicks,ViralExternalWebsiteConversions,ViralExternalWebsitePostClickConversions,ViralExternalWebsitePostViewConversions,ViralFollows,ViralFullScreenPlays,ViralImpressions,ViralLandingPageClicks,ViralLikes,ViralOneClickLeadFormOpens,ViralOneClickLeads,ViralOtherEngagements,ViralShares,ViralTotalEngagements,ViralVideoCompletions,ViralVideoFirstQuartileCompletions,ViralVideoMidpointCompletions,ViralVideoStarts,ViralVideoThirdQuartileCompletions,ViralVideoViews
Filter Use 1 or more Account, Campaign, Creative

Note: If there are no filters specified the default filter will be all the accounts that belong to the user.

You can turn off the client-side execution of the query by setting SupportEnhancedSQL to false in which case any search criteria will be ignored and an unfiltered response will be returned.

Columns

Name Type Description
Account String Pivot value which groups the result by account.
Campaign String Pivot value which groups the result by campaign.
Creative String Pivot value which groups the result by creative.
ActionClicks Long The count of clicks on the action button of the Sponsored InMail.
AdUnitClicks Long The count of clicks on the ad unit displayed alongside the Sponsored InMail.
CardClicks Long The number of clicks for each card of a carousel ad.
CardImpressions Long The number of impressions shown for each card of a carousel ad.
Clicks Long The count of chargeable clicks.
CommentLikes Long The count of likes of a comment.
Comments Long The count of comments. Sponsored
CompanyPageClicks Long The count of clicks to view the company page.
ConversionValueInLocalCurrency Decimal Value of the conversions in the account's local currency based on rules defined by the advertiser.
CostInLocalCurrency Decimal Cost in the account's local currency based on the pivot and timeGranularity.
CostInUsd Decimal Cost in USD based on the pivot and timeGranularity.
StartPeriod String Date start covered by the report data point.
EndPeriod String Date end covered by the report data point.
ExternalWebsiteConversions Long The count of conversions indicated by pixel loads on an external advertiser website.
ExternalWebsitePostClickConversions Long The count of post-click conversions indicated by pixel loads on an external advertiser website.
ExternalWebsitePostViewConversions Long The count of post-view conversions indicated by pixel loads on an external advertiser website.
Follows Long The count of follows. Sponsored
FullScreenPlays Long A user taps on the video, going into video view mode.
Impressions Long This is the count of 'impressions' for Direct Ads and Sponsored Updates and 'sends' for InMails.
LandingPageClicks Long The count of clicks which take the user to the creative landing page.
LeadGenerationMailContactInfoShares Long The number of times a user shared contact info through the One Click Leadgen for Sponsored InMail.
LeadGenerationMailInterestedClicks Long The count of InMail recipients showing interest.
Likes Long The count of likes.
OneClickLeadFormOpens Long The count of times a user opened the lead form for a One Click Lead Gen campaign.
OneClickLeads Long The count of leads generated through One Click Lead Gen.
Opens Long The count of opens of Sponsored InMail.
OtherEngagements Long The count of user interactions with the ad unit that do not fit into any other more specific category.
Pivot String The value of the pivot for a specific record returned.
PivotValue String The value of the pivot for a specific record returned.
Shares Long The count of shares.
TextUrlClicks Long The count of clicks on any links (anchor tags) that were included in the body of the Sponsored InMail.
TotalEngagements Long The count of all user interactions with the ad unit.
VideoCompletions Long The count of video ads that played 97-100% of the video.
VideoFirstQuartileCompletions Long The count of video ads that played through the first quartile of the video.
VideoMidpointCompletions Long The count of video ads that played through the midpoint of the video.
VideoStarts Long The count of video ads that were started by a user.
VideoThirdQuartileCompletions Long The count of video ads that played through the third quartile of the video.
VideoViews Long A video ad playing for at least 2 continuous seconds 50% in-view, or a click on the CTA, whichever comes first.
ViralCardClicks Long The number of viralClicks for each card of a carousel ad.
ViralCardImpressions Long The number of viralImpressions shown for each card of a carousel ad.
ViralClicks Long The count of clicks on viral impressions.
ViralComments Long The count of comments from viral impressions for this activity.
ViralCompanyPageClicks Long The count of clicks to view the company page from viral impressions for this activity.
ViralExternalWebsiteConversions Long The count of conversions indicated by pixel loads on an external advertiser website driven by a viral event.
ViralExternalWebsitePostClickConversions Long The count of post-click conversions indicated by pixel loads on an external advertiser website driven by a viral click.
ViralExternalWebsitePostViewConversions Long The count of post-view conversions indicated by pixel loads on an external advertiser website driven by a viral impression.
ViralFollows Long The count of follows from viral impressions for this activity.
ViralFullScreenPlays Long A user taps on the video, going into video view mode.
ViralImpressions Long The count of viral impressions for this activity.
ViralLandingPageClicks Long The count of clicks on viral impressions to take the user to the creative landing page.
ViralLikes Long The count of likes from viral impressions for this activity.
ViralOneClickLeadFormOpens Long The count of times a user opened the lead form for viral impressions from a Lead Gen campaign.
ViralOneClickLeads Long The count of leads generated through One Click Lead Gen from viral impressions for this activity.
ViralOtherEngagements Long The count of user interactions with viral impressions that do not fit into any other more specific category.
ViralShares Long The count of shares from viral impressions for this activity.
ViralTotalEngagements Long The count of all user interactions with a viral ad unit.
ViralVideoCompletions Long The count of viral video ads that played 97-100% of the video.
ViralVideoFirstQuartileCompletions Long The count of viral video ads that played through the first quartile of the video.
ViralVideoMidpointCompletions Long The count of viral video ads that played through the midpoint of the video.
ViralVideoStarts Long The count of viral video ads that were started by a user.
ViralVideoThirdQuartileCompletions Long The count of viral video ads that played through the third quartile of the video.
ViralVideoViews Long A viral video ad playing for at least 2 continuous seconds 50% in-view, or a click on the CTA, whichever comes first.

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
Company String Pivot value which groups the result by advertiser's company.
Share String Pivot value which groups the result by sponsored share.
CampaignGroup String Pivot value which groups the result by campaign group.
Conversion String Pivot value which groups the result by conversion.
ServingLocation String Pivot value which groups the result by serving location.
CardIndex String Pivot value which groups the result by card index.
MemberCompanySize String Pivot value which groups the result by member company size.
MemberIndustry String Pivot value which groups the result by member industry.
MemberSeniority String Pivot value which groups the result by member seniority.
MemberJobTitle String Pivot value which groups the result by member job title.
MemberJobFunction String Pivot value which groups the result by member job function.
MemberCountry String Pivot value which groups the result by member country.
MemberRegion String Pivot value which groups the result by member region.
MemberCompany String Pivot value which groups the result by member company.
CampaignType String Match result by campaign type.

The allowed values are TEXT_AD, SPONSORED_UPDATES, SPONSORED_INMAILS, DYNAMIC.

Granularity String Time granularity of results.

The allowed values are DAILY, MONTHLY, YEARLY, ALL.

RequestType String Designates the query finder. The only allowed values are

The allowed values are analytics, statistics.

StartDate String The start time of the period.
EndDate String The end time of the period.





AdAudienceCount

The Audience Count API allows advertisers to forecast the reach of targeting criteria.

Table Specific Information
Select

The AdAudienceCount view allows advertisers to forecast the reach of targeting criteria.

The driver uses the LinkedIn API to process search criteria. You can combine the following filters also in a single search. The driver processes other filters client-side within the driver. For example, the following queries are processed server side.

SELECT * FROM AdAudienceCount WHERE AgeRanges='AGE_25_34'

SELECT * FROM AdAudienceCount WHERE DegreesId='1234'

SELECT * FROM AdAudienceCount WHERE FieldsOfStudyId='1234'

SELECT * FROM AdAudienceCount WHERE Genders='MALE'

SELECT * FROM AdAudienceCount WHERE IndustriesId='1234'

SELECT * FROM AdAudienceCount WHERE JobFunctionsId='1234'

SELECT * FROM AdAudienceCount WHERE LocationsId='1234'

SELECT * FROM AdAudienceCount WHERE ProfileLocationsId='1234'

SELECT * FROM AdAudienceCount WHERE SenioritiesId='1234'

SELECT * FROM AdAudienceCount WHERE SkillsId='1234'

SELECT * FROM AdAudienceCount WHERE StaffCountRanges='SIZE_11_TO_50'

SELECT * FROM AdAudienceCount WHERE TitlesId='1234'
Select Rules

Ad audience count reports:

Dimensions Use 1 or more AgeRanges, DegreesId, FieldsOfStudyId, Genders, IndustriesId, JobFunctionsId, LocationsId, ProfileLocationsId, SenioritiesId, SkillsId, StaffCountRanges, TitlesId

Note: If no dimension is specified the default dimension will be Genders and will be set to both MALE and FEMALE as the default value.

You can turn off the client-side execution of the query by setting SupportEnhancedSQL to false in which case any search criteria will be ignored and an unfiltered response will be returned.

Columns

Name Type Description
ActiveAudience Integer Active audience count for the given targeting criteria.
TotalAudience Integer Total audience count for the given targeting criteria.

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
AgeRanges String Age ranges to match against member. Supported values are: AGE_18_24, AGE_25_34, AGE_35_54, AGE_55_PLUS
DegreesId String Educational degrees attained to match against those of the member.
FieldsOfStudyId String Fields of study to match against those listed by the member.
Genders String Genders to match against member. Supported values are: MALE, FEMALE
IndustriesId String Industries to be targeted.
JobFunctionsId String Top level groupings of supertitles to be targeted.
LocationsId String Location to be targeted.
ProfileLocationsId String The values are similar to
SenioritiesId String Seniorities to be targeted.
SkillsId String Skills to match against the member's listed skills.
StaffCountRanges String Organization sizes to be targeted. Supported values are: SIZE_1, SIZE_2_TO_10, SIZE_11_TO_50, SIZE_51_TO_200, SIZE_201_TO_500, SIZE_501_TO_1000, SIZE_1001_TO_5000, SIZE_5001_TO_10000, SIZE_10001_OR_MORE
TitlesId String Job titles to match against the member's current title.





AdBudgetPricing

The LinkedIn Ad Budget Pricing API provides developers with key insights on pricing metrics (e.g. minimum, maximum and suggested bids) based on targeting criteria.

Table Specific Information
Select

The AdBudgetPricing view provides developers with key insights on pricing metrics (e.g. minimum, maximum and suggested bids) based on targeting criteria.

The driver uses the LinkedIn API to process search criteria. You can combine the following filters also in a single search. The driver processes other filters client-side within the driver. For example, the following queries are processed server side.

SELECT * FROM AdBudgetPricing WHERE AgeRanges='AGE_25_34' AND Account='1234'

SELECT * FROM AdBudgetPricing WHERE DegreesId='1234' AND Account='1234'

SELECT * FROM AdBudgetPricing WHERE FieldsOfStudyId='1234' AND Account='1234'

SELECT * FROM AdBudgetPricing WHERE Genders='MALE' AND Account='1234'

SELECT * FROM AdBudgetPricing WHERE IndustriesId='1234' AND Account='1234'

SELECT * FROM AdBudgetPricing WHERE JobFunctionsId='1234' AND Account='1234'

SELECT * FROM AdBudgetPricing WHERE LocationsId='1234' AND Account='1234'

SELECT * FROM AdBudgetPricing WHERE ProfileLocationsId='1234' AND Account='1234'

SELECT * FROM AdBudgetPricing WHERE SenioritiesId='1234' AND Account='1234'

SELECT * FROM AdBudgetPricing WHERE SkillsId='1234' AND Account='1234'

SELECT * FROM AdBudgetPricing WHERE StaffCountRanges='SIZE_11_TO_50' AND Account='1234'

SELECT * FROM AdBudgetPricing WHERE TitlesId='1234' AND Account='1234'
Select Rules

Ad budget pricing reports:

Dimensions Use 1 or more AgeRanges, DegreesId, FieldsOfStudyId, Genders, IndustriesId, JobFunctionsId, LocationsId, ProfileLocationsId, SenioritiesId, SkillsId, StaffCountRanges, TitlesId

Note: If no dimension is specified the default dimension will be Genders and will be set to both MALE and FEMALE as the default value.

Filter Required CampaignType, Account, BidType, MatchType

Note: The default value for CampaignType will be TEXT_AD. The default value for BidType will be CPM. The default value for MatchType will be EXACT. If there is no Account specified there will be records for every account that belongs to the user.

You can turn off the client-side execution of the query by setting SupportEnhancedSQL to false in which case any search criteria will be ignored and an unfiltered response will be returned.

Columns

Name Type Description
SuggestedBidDefault String The suggested bid
SuggestedBidMin String Low end of suggested bid range
SuggestedBidMax String High end of suggested bid range
DailyBudgetLimitsDefault String Default daily budget
DailyBudgetLimitsMin String Minimum daily budget
DailyBudgetLimitsMax String Maximum daily budget
BidLimitsMax String The maximum bid allowed
BidLimitsMin String The minimum bid allowed, also known as the floor price
Account Long Sponsored account URN.

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
CampaignType String The campaign type.

The allowed values are TEXT_AD, SPONSORED_UPDATES.

BidType String The bidding type.

The allowed values are CPM, CPC, CPV.

MatchType String The matching type.

The allowed values are EXACT, AUDIENCE_EXPANDED.

AgeRanges String Age ranges to match against member. Supported values are: AGE_18_24, AGE_25_34, AGE_35_54, AGE_55_PLUS
DegreesId String Educational degrees attained to match against those of the member.
FieldsOfStudyId String Fields of study to match against those listed by the member.
Genders String Genders to match against member. Supported values are: MALE, FEMALE
IndustriesId String Industries to be targeted.
JobFunctionsId String Top level groupings of supertitles to be targeted.
LocationsId String Location to be targeted.
ProfileLocationsId String The values are similar to
SenioritiesId String Seniorities to be targeted.
SkillsId String Skills to match against the member's listed skills.
StaffCountRanges String Organization sizes to be targeted. Supported values are: SIZE_1, SIZE_2_TO_10, SIZE_11_TO_50, SIZE_51_TO_200, SIZE_201_TO_500, SIZE_501_TO_1000, SIZE_1001_TO_5000, SIZE_5001_TO_10000, SIZE_10001_OR_MORE
TitlesId String Job titles to match against the member's current title.





AdCampaignGroups

The Ad Campaign status finder returns all campaigns in a specified status that the authenticated user has access to.

Table Specific Information
Select

The AdCampaignGroups view returns a list of the campaign groups that belong to the authenticated user so they can be used as dimensions in analytic requests.

The driver uses the LinkedIn API to process search criteria that refer to the Status column. The driver processes other filters client-side within the driver. For example, the following queries are processed server side.

SELECT * FROM AdCampaignGroups

SELECT * FROM AdCampaignGroups WHERE Status='ACTIVE'
You can turn off the client-side execution of the query by setting SupportEnhancedSQL to false in which case any search criteria will be ignored and an unfiltered response will be returned.
Columns

Name Type Description
Id [KEY] Long Numerical identifier for the campaign group
Account String URN identifying the advertising account associated with the Campaign Group. This value is immutable once set
Name String The name of the Campaign Group. Primarily used to make it easier to reference a Campaign Group and to recall its purpose
Status String Current Status of the campaign group

The allowed values are ACTIVE, PAUSED, ARCHIVED, DRAFT, CANCELED.

TotalBudgetAmount Decimal Maximum amount to spend over the life of the Campaign Group.
TotalBudgetCurrencyCode String ISO currency code. The currency code must match that of the parent account.
ScheduleStartTime Datetime Represents the inclusive (greater than or equal to) value in which to start the range.
ScheduleEndTime Datetime Scheduled date range to run associated objects.
Backfilled Boolean Flag that denotes whether the Campaign Group was created organically or was created to backfill existing campaigns.





AdCampaigns

The Ad Campaign status finder returns all campaigns in a specified status that the authenticated user has access to.

Table Specific Information
Select

The AdCampaigns view returns a list of the campaigns that belong to the authenticated user so they can be used as dimensions in analytic requests.

The driver uses the LinkedIn API to process search criteria that refer to the Status column. The driver processes other filters client-side within the driver. For example, the following queries are processed server side.

SELECT * FROM AdCampaigns

SELECT * FROM AdCampaigns WHERE Status='ACTIVE'
You can turn off the client-side execution of the query by setting SupportEnhancedSQL to false in which case any search criteria will be ignored and an unfiltered response will be returned.
Columns

Name Type Description
Id [KEY] Long Numerical identifier for the campaign
Account String URN identifying the advertising account associated with the Campaign.
AssociatedEntity String An URN for a strongly associated object, with semantics varying based on the Campaign type.
AudienceExpansionEnabled Boolean Enable Audience Expansion for the campaign provides query expansion for certain targeting criteria
CostType String CPM - Cost per thousand advertising impressions. CPC - Cost per individual click on the associated link
CreativeSelection String ROUND_ROBIN - Rotate through available creatives to serve them as easily as possible. OPTIMIZED - Bias selection taking into account such things as expected performance
DailyBudgetAmount String The amount of money as a real number string
DailyBudgetCurrency String ISO currency code
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.
Name String The name of the Campaign
OffsiteDeliveryEnabled Boolean Allow this campaign access to be served on the LinkedIn Advertising Network.
ScheduleStartTime Datetime Scheduled date range to run associated creatives.
ScheduleEndTime Datetime Scheduled date range to run associated creatives.
Status String Current Status of the campaign

The allowed values are ACTIVE, PAUSED, ARCHIVED, COMPLETED, CANCELED.

Type String Type of campaign
UnitCostAmount String Amount to bid per click, impression, or other event depending on the pricing model.
UnitCostCurrency String Currency of the UnitCostAmount





AdCreatives

The Ad Creatives search finder allows you to search for creatives by id, campaign URN, status, or reference URN.

Table Specific Information
Select

The AdCreatives view returns a list of the creatives that belong to the authenticated user so they can be used as dimensions in analytic requests.

The driver uses the LinkedIn API to process search criteria that refer to the Status column. The driver processes other filters client-side within the driver. For example, the following queries are processed server side.

SELECT * FROM AdCreatives

SELECT * FROM AdCreatives WHERE Status='ACTIVE'
You can turn off the client-side execution of the query by setting SupportEnhancedSQL to false in which case any search criteria will be ignored and an unfiltered response will be returned.
Columns

Name Type Description
Id [KEY] Long Numerical identifier for the creative
Status String Status of the current creative

The allowed values are ACTIVE, PAUSED, ARCHIVED, CANCELED.

Type String Type of the current creative
Version String Version tag of the creative
Campaign String URN identifying the campaign associated with the creative
ReviewStatus String The current review status of the creative
LastModifiedAt Datetime Datetime when the creative was last modified
CreatedAt Datetime Datetime when the creative was first created
Reference String A reference URN for this object to an external system, with semantics varying based on the creative type.
CreativesClickUri String URI destination to forward on a click





AdDegrees

Degree taxonomy is used to standardize data across the LinkedIn platform. Use this API to retrieve standardized URNs and their names.

Table Specific Information
Select

The AdDegrees view returns a list of the degrees found accross LinkedIn so they can be used as dimensions in analytic requests.

The driver uses the LinkedIn API to process search criteria. The driver processes other filters client-side within the driver. For example, the following queries are processed server side.

SELECT * FROM AdDegrees
You can turn off the client-side execution of the query by setting SupportEnhancedSQL to false in which case any search criteria will be ignored and an unfiltered response will be returned.
Columns

Name Type Description
Id [KEY] Long Degree id
URN String Standardized degree URN
Name String Degree name in various locales. Represented as MultiLocaleString type.





AdFieldsOfStudy

Fields of study taxonomy is used to standardize data across the LinkedIn platform. Use this API to retrieve standardized URNs and their names.

Table Specific Information
Select

The AdFieldsOfStudy view returns a list of the fields of study found accross LinkedIn so they can be used as dimensions in analytic requests.

The driver uses the LinkedIn API to process search criteria. The driver processes other filters client-side within the driver. For example, the following queries are processed server side.

SELECT * FROM AdFieldsOfStudy
You can turn off the client-side execution of the query by setting SupportEnhancedSQL to false in which case any search criteria will be ignored and an unfiltered response will be returned.
Columns

Name Type Description
Id [KEY] Long Field of study id
URN String Standardized field of study URN
Name String Field of study name in various locales. Represented as MultiLocaleString type.





AdIndustries

Industry taxonomy is used to standardize data across the LinkedIn platform. Use this API to retrieve standardized URNs and their names.

Table Specific Information
Select

The AdIndustries view returns a list of the industries found accross LinkedIn so they can be used as dimensions in analytic requests.

The driver uses the LinkedIn API to process search criteria. The driver processes other filters client-side within the driver. For example, the following queries are processed server side.

SELECT * FROM AdIndustries
You can turn off the client-side execution of the query by setting SupportEnhancedSQL to false in which case any search criteria will be ignored and an unfiltered response will be returned.
Columns

Name Type Description
Id [KEY] Long Industry id
URN String Standardized industry URN
Name String Industry name in various locales. Represented as MultiLocaleString type.





AdJobFunctions

Job function taxonomy is used to standardize data across the LinkedIn platform. Use this API to retrieve standardized URNs and their names.

Table Specific Information
Select

The AdJobFunctions view returns a list of the Job Functions found accross LinkedIn so they can be used as dimensions in analytic requests.

The driver uses the LinkedIn API to process search criteria. The driver processes other filters client-side within the driver. For example, the following queries are processed server side.

SELECT * FROM AdJobFunctions
You can turn off the client-side execution of the query by setting SupportEnhancedSQL to false in which case any search criteria will be ignored and an unfiltered response will be returned.
Columns

Name Type Description
Id [KEY] Long Job function id
URN String Standardized Job function URN
Name String Job function name in various locales. Represented as MultiLocaleString type.





AdLocations

Location taxonomy is used to standardize data across the LinkedIn platform. Use this API to retrieve standardized URNs and their names.

Table Specific Information
Select

The AdLocations view returns a list of the locations and regions found accross LinkedIn so they can be used as dimensions in analytic requests.

The driver uses the LinkedIn API to process search criteria. The driver processes other filters client-side within the driver. For example, the following queries are processed server side.

SELECT * FROM AdLocations
You can turn off the client-side execution of the query by setting SupportEnhancedSQL to false in which case any search criteria will be ignored and an unfiltered response will be returned.
Columns

Name Type Description
Id [KEY] String The country code.
CountryGroup String The country group URN that this country belongs to.
URN String Standardized country URN
Name String Country name in various locales. Represented as LocaleString type.





AdSeniorities

Seniority taxonomy is used to standardize data across the LinkedIn platform. Use this API to retrieve standardized URNs and their names.

Table Specific Information
Select

The AdSeniorities view returns a list of the seniority positions found accross LinkedIn so they can be used as dimensions in analytic requests.

The driver uses the LinkedIn API to process search criteria. The driver processes other filters client-side within the driver. For example, the following queries are processed server side.

SELECT * FROM AdSeniorities
You can turn off the client-side execution of the query by setting SupportEnhancedSQL to false in which case any search criteria will be ignored and an unfiltered response will be returned.
Columns

Name Type Description
Id [KEY] Long Seniority id
URN String Standardized Seniority URN
Name String Seniority name in various locales. Represented as MultiLocaleString type.





AdSkills

Skills taxonomy is used to standardize data across the LinkedIn platform. Use this API to retrieve standardized URNs and their names.

Table Specific Information
Select

The AdSkills view returns a list of the job skills found accross LinkedIn so they can be used as dimensions in analytic requests.

The driver uses the LinkedIn API to process search criteria. The driver processes other filters client-side within the driver. For example, the following queries are processed server side.

SELECT * FROM AdSkills
You can turn off the client-side execution of the query by setting SupportEnhancedSQL to false in which case any search criteria will be ignored and an unfiltered response will be returned.
Columns

Name Type Description
Id [KEY] Long skill id
Name String skill name in various locales. Represented as MultiLocaleString type.





AdSupplyForecast

The LinkedIn Ad Supply Forecasting API provides impression and budget data based on target set, bid, and time period.

Table Specific Information
Select

The AdSupplyForecast view provides impression and budget data based on target set, bid, and time period.

The driver uses the LinkedIn API to process search criteria. You can combine the following filters also in a single search. The driver processes other filters client-side within the driver. For example, the following queries are processed server side.

SELECT * FROM AdSupplyForecast WHERE AgeRanges='AGE_25_34'

SELECT * FROM AdSupplyForecast WHERE DegreesId='1234'

SELECT * FROM AdSupplyForecast WHERE FieldsOfStudyId='1234'

SELECT * FROM AdSupplyForecast WHERE Genders='MALE'

SELECT * FROM AdSupplyForecast WHERE IndustriesId='1234'

SELECT * FROM AdSupplyForecast WHERE JobFunctionsId='1234'

SELECT * FROM AdSupplyForecast WHERE LocationsId='1234'

SELECT * FROM AdSupplyForecast WHERE ProfileLocationsId='1234'

SELECT * FROM AdSupplyForecast WHERE SenioritiesId='1234'

SELECT * FROM AdSupplyForecast WHERE SkillsId='1234'

SELECT * FROM AdSupplyForecast WHERE StaffCountRanges='SIZE_11_TO_50'

SELECT * FROM AdSupplyForecast WHERE TitlesId='1234'
Select Rules

Ad supply forecast reports:

Dimensions Use 1 or more AgeRanges, DegreesId, FieldsOfStudyId, Genders, IndustriesId, JobFunctionsId, LocationsId, ProfileLocationsId, SenioritiesId, SkillsId, StaffCountRanges, TitlesId

Note: If no dimension is specified the default dimension will be Genders and will be set to both MALE and FEMALE as the default value.

Filter Required CampaignType, StartDate, EndDate

Note: If there is no campaign type specified the default value will be TEXT_AD. Also if there is no time window specified, the default one will be the last 30 days.

You can turn off the client-side execution of the query by setting SupportEnhancedSQL to false in which case any search criteria will be ignored and an unfiltered response will be returned.

Columns

Name Type Description
MetricType String The metric type of the forecast.
Granularity String The granularity of the forecast.
ForecastTimeseriesValue Integer Forecasting supply value at certain time.
ForecastTimeseriesTimestamp Datetime Timestamp of the value. It represents the time when current forecast value will be seen.
ForecastTimeseriesRangeHigh Integer Range of the forecasting supply value at a certain time, represented by a high end
ForecastTimeseriesRangeLow Integer Range of the forecasting supply value at a certain time, represented by a low end

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
CampaignType String The campaign type.

The allowed values are TEXT_AD, SPONSORED_UPDATES.

StartDate String The start time of the period.
EndDate String The end time of the period.
AgeRanges String Age ranges to match against member. Supported values are: AGE_18_24, AGE_25_34, AGE_35_54, AGE_55_PLUS
DegreesId String Educational degrees attained to match against those of the member.
FieldsOfStudyId String Fields of study to match against those listed by the member.
Genders String Genders to match against member. Supported values are: MALE, FEMALE
IndustriesId String Industries to be targeted.
JobFunctionsId String Top level groupings of supertitles to be targeted.
LocationsId String Location to be targeted.
ProfileLocationsId String The values are similar to
SenioritiesId String Seniorities to be targeted.
SkillsId String Skills to match against the member's listed skills.
StaffCountRanges String Organization sizes to be targeted. Supported values are: SIZE_1, SIZE_2_TO_10, SIZE_11_TO_50, SIZE_51_TO_200, SIZE_201_TO_500, SIZE_501_TO_1000, SIZE_1001_TO_5000, SIZE_5001_TO_10000, SIZE_10001_OR_MORE
TitlesId String Job titles to match against the member's current title.





AdTitles

Titles taxonomy is used to standardize data across the LinkedIn platform. Use this API to retrieve standardized URNs and their names.

Table Specific Information
Select

The AdTitles view returns a list of the job titles found accross LinkedIn so they can be used as dimensions in analytic requests.

The driver uses the LinkedIn API to process search criteria. The driver processes other filters client-side within the driver. For example, the following queries are processed server side.

SELECT * FROM AdTitles
You can turn off the client-side execution of the query by setting SupportEnhancedSQL to false in which case any search criteria will be ignored and an unfiltered response will be returned.
Columns

Name Type Description
Id [KEY] Long Titles id
URN String Standardized Titles URN
Name String Titles name in various locales. Represented as MultiLocaleString type.





Comments

Query comments for a specific company update.

Select

The Comments view supports the UpdateId and CompanyId columns in the WHERE clause. The supported operator for these columns is =. For example:

SELECT * FROM Comments WHERE CompanyId='183432' AND UpdateId='UPDATE-12315-1352-112515'
SELECT * FROM Comments WHERE UpdateId='UPDATE-12315-1352-112515'

Make sure that, when selecting a specific update, comments are enabled on it.

Columns

Name Type Description
Id [KEY] String The unique identifier for the comment.
UpdateId String Id of the Update associated with the comment.
Text String Content of the update comment.
PersonId String The unique identifier for the person.
PersonFirstName String First name of the person which commented.
PersonLastName String Last name of the person which commented.
PersonHeadline String Headline of the person which commented.
PersonProfileUrl String Profile url of the person which commented.
PersonPictureUrl String Photo url of the person which commented.
CommentCompanyId String Id of the Company that commented the update.
CompanyId String Id of the Company that posted the update.
Date Datetime Comment created time.





CompanyDetails

Retrieve company profiles and updates.

Select

The CompanyDetails view supports only the CompanyId column in the WHERE clause. The only supported operator for the CompanyId column is =. For example:

SELECT * FROM CompanyDetails
SELECT * FROM CompanyDetails WHERE CompanyId='183432'
Columns

Name Type Description
CompanyId [KEY] String The unique, internal, numeric identifier for the company.
CompanyName String The name of the company.
UniversalName String The unique string identifier for the company.
EmailDomains String Company email domains.
Description String The company description. Limit of 500 characters.
Specialties String The company specialties.
EmployeeCountCode String The code for the number range of employees at the company. Valid codes and names: A (1), B (2-10), C (11-50), D (51-200), E (201-500), F (501-1000), G (1001-5000), H (5001-10,000), I (10,000+).
EmployeeCountName String The number range of employees at the company, corresponding to the EmployeeCountCode.
LogoUrl String The URL to the company logo.
WebsiteUrl String The URL for the company website.
SquareLogoUrl String The URL to the company logo, which must have a square format.
BlogRSSUrl String The URL to the RSS feed for the company blog.
NumberFollowers Integer The number of followers for the company profile.
StatusCode String The company status code. Valid codes and names: OPR (Operating), OPS (Operating Subsidiary), RRG (Reorganizing), OOB (Out-Of-Business), ACQ (acquired)
StatusName String The company status, corresponding to the company status.
StockExchangeCode String The code for the stock exchange the company is in. Valid codes and names: ASE (1, American Stock Exchange), NYS (2, New York Stock Exchange), NMS (3, NASDAQ), LSE (4, London Stock Exchange), FRA (5, Frankfurt Stock Exchange), GER (6, XETRA Trading platform), PAR (7, Euronext Paris)
StockExchangeName String The name of the stock exchange the company is in, corresponding to the StockExchangeCode.
CompanyTypeCode String The type of company. Valid codes and names: C (Public Company), D (Educational), E (Self-Employed), G (Government Agency), N (Nonprofit), O (Self-Owned), P (Privately Held), S (Partnership).
CompanyTypeName String The name of the company type.
Ticker String The company ticker identification for the stock exchange. Available only for public companies.
TwitterId String The handle for the company Twitter feed.
FoundedYear Integer The year the company was founded.
EndYear Integer The year listed for when the company closed or was acquired by another.





CompanyFollowerCount

This table displays Paid and Organic counts of followers within all of the days or months in the selected time range.

Select

CompanyFollowerCount view supports the CompanyId, Granularity, and Date columns in the WHERE clause. The CompanyId and Granularity columns support only the = operator. For example:

SELECT * FROM CompanyFollowerCount WHERE CompanyId='183432'

SELECT * FROM CompanyFollowerCount WHERE CompanyId='183432' AND Granularity='Day'

SELECT * FROM CompanyFollowerCount WHERE CompanyId='183432' AND Granularity='Day' AND Date >= '11/01/2016'
Columns

Name Type Description
OrganicFollowerCount Integer Number of organic followers added.
PaidFollowerCount Integer Number of paid followers added.
TotalFollowerCount Integer Total number of followers added.
Date Date Specific date for the statistic.
CompanyId String Id of the Company associated with the follow statistics.
Granularity String Granularity of statistics. Supported values are: day, month





CompanyFollowerStatistics

Query statistics about followers for a particular company page.

Select

The CompanyFollowerStatistics view supports only the CompanyId column in the WHERE clause. The supported operator for the CompanyId column is =. For example:

SELECT * FROM CompanyFollowerStatistics WHERE CompanyId='183432'
Columns

Name Type Description
CompanyId Integer Id of the Company associated with the follow statistics.
Category String The category of the followers.
Type String Type of the category.
TypeValue String Count of followers for this type of category.





CompanyJobUpdates

Lists job update events from the LinkedIn company page.

Select

The CompanyJobUpdates table supports only the CompanyId column in the WHERE clause. The supported operator for the CompanyId column is =. For example:

SELECT * FROM CompanyJobUpdates WHERE CompanyId='183432'
Columns

Name Type Description
Id [KEY] String The unique identifier for the update.
Position String The position title of the job being shared.
JobDescription String The position description of the job being shared.
CompanyId String Id of the Company associated with the job update.
CompanyName String Name of the Company associated with the job update.
JobLocationDescription String Location of the job postition.
SiteJobRequest String Site url of the job request.
Commentable Boolean Is commentable or not.
Likable Boolean Is likable or not.
Date Datetime Update created time .

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
Rows@Next String Identifier for the next page of results. Do not set this value manually.





CompanyList

Lists all companies that the member is an administrator of.

Select

The CompanyList view returns a list of all companies that the member is an administrator of. For example:

SELECT * FROM CompanyList
Columns

Name Type Description
Id [KEY] String A unique identifier for the company.
Name String Name of the company.

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
Rows@Next String Identifier for the next page of results. Do not set this value manually.





CompanyLocations

Retrieve company locations information.

Select

The CompanyLocations view supports only the CompanyId column in the WHERE clause. The only supported operator for the CompanyId column is =. For example:

SELECT * FROM CompanyLocations
SELECT * FROM CompanyLocations WHERE CompanyId='183432'
Columns

Name Type Description
CompanyId [KEY] String Id of the Company associated with the comment.
Description String The company description. Limit of 500 characters.
IsHeadQuarts Boolean Valid values are true or false. A value of true matches the Company headquarters location.
IsActive Boolean Valid values are true or false. A value of true matches the active location.
Street1 String The first line of the street address for the company location.
Street2 String The second line of the street address for the company location.
City String The city of the company location.
State String The state of the company location.
PostalCode String The postal code of the company location.
CountryCode String The country code of the company location.
RegionCode String The region code of the company location.
ContactFax String The fax number for the company location.
ContactPhone1 String The first phone number for the company location.
ContactPhone2 String The second phone number for the company location.





CompanyUpdateStatistics

Query update statistics about a company, for the last twelve months.

Select

The CompanyUpdateStatistics view supports only the CompanyId column in the WHERE clause. The supported operator for the CompanyId column is =. For example:

SELECT * FROM CompanyUpdateStatistics WHERE CompanyId='183432'
Columns

Name Type Description
Clicks Integer Total clicks count.
Comments Integer Total comments count.
Engagement Double Total engagement count.
Impressions Integer Total impressions count.
Likes Integer Total likes count.
Shares Integer Total shares count.
CompanyId String Id of the Company associated with the update statistics.
Date Date Specific date for the statistic.





Positions

Query the member's current positions.

Select

The Positions view retrieves all current positions for the logged in member. For example:

SELECT * FROM Positions
Columns

Name Type Description
Id [KEY] String A unique identifier for the member's position.
Title String The title of the position.
Summary String A summary of the position.
StartMonth Integer The month when the position began.
StartYear Integer The year when the position began.
IsCurrent Boolean A boolean value indicating whether the member is current in this position.
CompanyId String A unique identifier for the company.
CompanyName String The name of the company.
CompanyType String One of the following possible values: public or private.
CompanyIndustry String The industry in which the company operates.
CompanyTicker String The stock market ticker symbol for the company. This field will be empty for companies that are not publicly traded.





Profile

Lists the details of your profile.

Select

The Profile view returns a list of the details of your profile. For example:

SELECT * FROM Profile
Columns

Name Type Description
Id [KEY] String The unique identifier for the person.
FirstName String The first name for the person.
LastName String The last name for the person.
Headline String The headline for the person. Often this is Job Title at Company.
Connections Integer The number of connections for the person.
Recommenders Integer The number of recommenders for the person.
Location String The location for the person.
Industry String The industry the LinkedIn member has indicated their profile belongs to.
URL String A URL representing the resource you would request for programmatic access to the member's profile.