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 [5|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 [5|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 [5|Q-Id] [EXEC|Messag] Executed query: [SELECT [FirstDegreeSize], 0 AS [odx_batch_number] FROM [LinkedIn].[OrganizationFollowerCount]] Success: 0 results (2161 ms)
2023-06-12T11:31:22.196+02:00 0 [5|Q-Id] [SQL |Messag] Query Failed: [SELECT [FirstDegreeSize], 0 AS [odx_batch_number] FROM [LinkedIn].[OrganizationFollowerCount]]. 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
Best answer by Christian Hauggaard
View original