Data Normalization

This topic describes how to perform data normalization for uploading users and uploading companies using the LinkedIn connector.

Data layout for uploading users

The following table list the data layout for uploading users:


Field name	Description	Remarks
`action`	The action to take on this entity. For example: `ADD` or `REMOVE`.	User needs to prepare their data as per given data format.
`userIds` `idType` `idValue`	List of ID to match. For idType details, see IdTypes.	Two `IdType` values are supported: `SHA256 EMAIL`: User needs to prepare their data as per given data format and hashing is taken care by Link connector. `GOOGLE AID`: User needs to prepare their data as per given data format and Link connector only change all text to lowercase.
`firstName`	The first name with a maximum length of 35 characters. For example: `Mike`	User needs to prepare their data as per given data format.
`lastName`	The last name with a maximum length of 35 characters. For example: `Smith`.	User needs to prepare their data as per given data format.
`title`	The job title name with a maximum length of 50 characters. For example: `Software Engineer`.	User needs to prepare their data as per given data format.
`company`	The company name with a maximum length of 50 characters. For example: `Microsoft Corporation`.	User needs to prepare their data as per given data format.
`country`	The ISO standardized two letter country code. For example: `US`.	User needs to prepare their data as per given data format.

Table 1. IdTypesThe following table list the IdType values which are supported:
Symbol	Description	Remarks
`SHA256 EMAIL`	A HEX encoded string with a maximum length of 64 characters.	`692682111bc191d915ac7009d118a78bc496cf7a2` `ba8c2d0134ade012ac1234`
`GOOGLE AID`	A plain text string with a maximum length of 32 characters and all in lower case.	`cdda802e-fb9c-47ad-0794d394c912....`

Data layout for uploading companies

The following table lists the data layout for uploading companies:


Field Name	Description	Remarks
`action`	The action to take on this entity. For example: `ADD` or `REMOVE`.	User needs to prepare their data as per given data format.
`companyName`	The company name. For example: `Microsoft`	User needs to prepare their data as per given data format.
`companyWebsiteDomain`	The company website domain string in URL format. For example: `www.microsoft.com`	User needs to prepare their data as per given data format.
`companyEmailDomain`	The company email domain string in URL format (sometimes different from the website domain). For example: `linkedin.com`	User needs to prepare their data as per given data format.
`organizationUrn`	The LinkedIn company page URN of this company. For example: `urn:li:organizationUrn:123`	User needs to prepare their data as per given data format.
`companyPageUrl`	The LinkedIn company page URL of this company with maximum length of 100 characters. For example: `linkedin.com/company/microsoft`	User needs to prepare their data as per given data format.
`stockSymbol`	The stock symbol with a maximum length of 5 characters. For example: `MSFT`	User needs to prepare their data as per given data format.
`industries`	Maximum three industry names, each with maximum length of 50 letters. For example: `["technology", "software"]`	User needs to prepare their data as per given data format.
`city`	The city name with a maximum length of 50 characters. For example: `San Francisco`	User needs to prepare their data as per given data format.
`state`	The state/province name with a maxi mum length of 50 characters. For example: `California or CA`	User needs to prepare their data as per given data format.
`country`	The ISO standardized two letter country code. For example: `US`	User needs to prepare their data as per given data format.
`postalCode`	The postal code of the company with maximum length 20 letters. For example: `94103`	User needs to prepare their data as per given data format.

Note: Provide input data for one of the following fields as per given data format:

companyName
organizationUrn
companyWebsiteDomain or companyEmailDomain
companyPageUrl