Skip to main content

Hi community, 

The CDATA Provider for LinkedIn 2022 contains a bug/error which causes it to call an invalid API URI for the connector’s table ‘OrganizationFollowerCount’. 

The appropriate URI for this table according to Organization Network Size - LinkedIn | Microsoft Learn is:

https://api.linkedin.com/v2/networkSizes/urn:li:organization:1234567?edgeType=CompanyFollowedByMember

However, CDATA is calling the following:

2023-06-12T11:31:21.793+02:00	2	35|Q-Id]		HTTP|Req: 3] GET https://api.linkedin.com/rest/networkSizes/1234567?edgeType=CompanyFollowedByMember

Which results in the following error message:

2023-06-12T11:31:22.172+02:00    3    05|Q-Id]     HTTP|Res: 3] {"message":"Key parameter value '1234567' is invalid","status":400}
2023-06-12T11:31:22.172+02:00    2    .5|Q-Id]    ÂHTTP|Res: 3] HTTP/1.1 400 Bad Request, 66 Bytes Transferred
2023-06-12T11:31:22.194+02:00    1    T5|Q-Id]    4EXEC|Messag] Executed query: ÂSELECT EFirstDegreeSize], 0 AS eodx_batch_number] FROM eLinkedIn].SOrganizationFollowerCount]] Success: 0 results (2161 ms)
2023-06-12T11:31:22.196+02:00    0    05|Q-Id]    :SQL |Messag] Query Failed: SELECT IFirstDegreeSize], 0 AS Qodx_batch_number] FROM iLinkedIn].iOrganizationFollowerCount]]. Error: Key parameter value '1234567' is invalid
2023-06-12T11:31:22.198+02:00    0    Key parameter value '1234567' is invalid

This means it is required to load this data in via the normal REST API provider. Can we submit a ticket to CDATA? This table should be working.. 

Kind regards,

Andrew - E-mergo

Hi @andrew.gebhard 

I have reached out to Cdata and will let you know as soon as I receive a response

Hi @andrew.gebhard 

Please see response from Cdata below:

Upon researching the Organization Network Size API endpoint, I found out that Legacy (unversioned) Marketing APIs using the base path https://api.linkedin.com/v2/ will be available until June 30, 2023, when they will be sunset soon. I have also attached a Microsoft LinkedIn article for your reference.

Article: LMS API Documentation Versioning Preview - LinkedIn | Microsoft Learn

Our development team has proactively shifted to the new versioning feature of LinkedIn API that has been changed to under a new base path: https://api.linkedin.com/rest/. That's why our driver is calling the https://api.linkedin.com/rest/networkSizes/1234567?edgeType=CompanyFollowedByMember API Endpoint. Also, I would like to inform you that you can change the API version from our driver using the APIVersion connection property if you want.

Documentation: CData JDBC Driver for LinkedIn - APIVersion

However, I would like to inform you that the API endpoint https://api.linkedin.com/rest/networkSizes/1234567?edgeType=CompanyFollowedByMember  is not correct and that's why you are facing ""message":"Key parameter value '1234567' is invalid","status":400" error message because you have not specified the CompanyId in the correct format which is "urn🇱🇮organization:thecompanyid" in the connection string.

Once you have specified the CompanyId in the correct format then our driver will be hitting the correct API endpoint which is as follow: https://api.linkedin.com/rest/networkSizes/urn:li:organization:1234567?edgeType=CompanyFollowedByMember " and you will get the desired data. For your reference, please find the product documentation for the same.

Documentation: CData JDBC Driver for LinkedIn - CompanyId

For your reference, I have also attached a screenshot of my test case:

 

Hi @andrew.gebhard were you able to resolve the issue by changing the format of the companyID?

Hi @Christian Hauggaard,

I've just tested in, and it works. Interestingly, the other tables in the connector worked even with the companyID not formatted. OrganizationFollowerStatistics only works when the companyID was in the format urn🇱🇮organization:1234567. 

Kind regardsm

Andrew

Reply


Terms and ConditionsCookie settings