Extracting Shareholder Data into Separate Rows Using Companies House API

Jonathan M. · 2025-12-17T13:40:06.597Z

Is there a way to pull multiple person data (shareholders of a company) into it's own row? Currently I have the company details and then using the companies house API to pull significant shareholders, but they all appear on the same row

Extracting Shareholder Data into Separate Rows Using Companies House API | Clay

13 comments

· Sorted by Oldest

Clay Support
APP
·
·
Yes! You can split those shareholders into separate rows using the "Turn items into rows" feature. [1]
Here's how:
1.
Click into the cell containing your shareholders list
2.
Hover to the right of the list to see action options
3.
Select "Turn items into rows" to move each shareholder into its own row in another table [2]
Alternatively, use the "Write to Other Table" enrichment:
1.
Add Column > Add Enrichment > Search "write to table"
2.
Select the column with your shareholders list
3.
Map the shareholder properties to columns in your destination table [3]
This will create individual rows for each shareholder with their respective data mapped out properly. [4]
Clay Support
APP
·
·
Is that what you were looking for?
Jonathan M.
·
·
I can't write to another table as it won't let me write data from two different columns into the same one in the new table
Clay Support
APP
·
·
That's a common limitation. You can work around this by combining your data first, then writing to the new table.
Option 1: Merge columns first
Add Column > Merge Columns
Combine your two columns into one using a formula
Then use Write to Other Table with the merged column [1]
Option 2: Map each column separately
In Write to Other Table, use "Column mapping" mode
Enter "/" to skip list selection
Map each source column to different destination columns
Option 3: Use the newer "Send table data"
Actions > Send table data > "Send row for each item in a list"
This gives you more flexibility for complex mappings [2]
Which approach works better for your shareholder data structure?
Clay Support
APP
·
·
If you still need help with managing your shareholder data or have questions about these approaches, I'm here to assist. Would you like to provide more details about your data structure or the specific issue you're encountering?
Jonathan M.
·
·
But some of the data I want to keep the same (company name) but split out the data at the end of the row into new rows. So if I have 3 shareholders in 1 row, I'd like to split them into 3 rows, all with the same company data, but with the different shareholder data in each row?
Clay Support
APP
·
·
Perfect! Use Send table data with "Send row for each item in a list":
1.
Actions → Send table data
2.
Select your destination table
3.
Choose "Send row for each item in a list"
4.
Map your shareholders column as the list to split
5.
Map company name and other static data to repeat for each row
This creates one row per shareholder while duplicating the company data across all rows. [1] It's specifically designed for flattening lists while preserving associated data. [2]
Clay Support
APP
·
·
Did that answer your question?
Clay Support
APP
·
·
If you still need help with splitting your shareholder data into separate rows while keeping company details, I’m here to assist. Would you like to share more about your current setup or any specific challenges you’re facing with this process?
Tom M.
·
·
Hey Jonathan M., I have recently been playing around with the Companies house API. You should see the below when you call the API to get people. The two Items in the list are the two persons with significant control in this case. Feel free to DM if you want to explore further...
Clay Support
APP
·
·
Perfect! You've found the right action. "Write each item to new row in other table" will split your shareholders into separate rows while preserving the company data. [1]
This creates one row per shareholder with the company details duplicated across all rows - exactly what you need for flattening your Companies House API results. [2]
Clay Support
APP
·
·
Is that what you were looking for?
Clay Support
APP
·
·
If you still need help with splitting your shareholder data into separate rows while keeping company details, I’m here to assist. Would you like to share more about your current setup or any specific challenges you’re facing with this process?

Clay Support
APP
·
·
Yes! You can split those shareholders into separate rows using the "Turn items into rows" feature. [1]
Here's how:
1.
Click into the cell containing your shareholders list
2.
Hover to the right of the list to see action options
3.
Select "Turn items into rows" to move each shareholder into its own row in another table [2]
Alternatively, use the "Write to Other Table" enrichment:
1.
Add Column > Add Enrichment > Search "write to table"
2.
Select the column with your shareholders list
3.
Map the shareholder properties to columns in your destination table [3]
This will create individual rows for each shareholder with their respective data mapped out properly. [4]
Clay Support
APP
·
·
Is that what you were looking for?
Jonathan M.
·
·
I can't write to another table as it won't let me write data from two different columns into the same one in the new table
Clay Support
APP
·
·
That's a common limitation. You can work around this by combining your data first, then writing to the new table.
Option 1: Merge columns first
Add Column > Merge Columns
Combine your two columns into one using a formula
Then use Write to Other Table with the merged column [1]
Option 2: Map each column separately
In Write to Other Table, use "Column mapping" mode
Enter "/" to skip list selection
Map each source column to different destination columns
Option 3: Use the newer "Send table data"
Actions > Send table data > "Send row for each item in a list"
This gives you more flexibility for complex mappings [2]
Which approach works better for your shareholder data structure?
Clay Support
APP
·
·
If you still need help with managing your shareholder data or have questions about these approaches, I'm here to assist. Would you like to provide more details about your data structure or the specific issue you're encountering?
Jonathan M.
·
·
But some of the data I want to keep the same (company name) but split out the data at the end of the row into new rows. So if I have 3 shareholders in 1 row, I'd like to split them into 3 rows, all with the same company data, but with the different shareholder data in each row?
Clay Support
APP
·
·
Perfect! Use Send table data with "Send row for each item in a list":
1.
Actions → Send table data
2.
Select your destination table
3.
Choose "Send row for each item in a list"
4.
Map your shareholders column as the list to split
5.
Map company name and other static data to repeat for each row
This creates one row per shareholder while duplicating the company data across all rows. [1] It's specifically designed for flattening lists while preserving associated data. [2]
Clay Support
APP
·
·
Did that answer your question?
Clay Support
APP
·
·
If you still need help with splitting your shareholder data into separate rows while keeping company details, I’m here to assist. Would you like to share more about your current setup or any specific challenges you’re facing with this process?
Tom M.
·
·
Hey Jonathan M., I have recently been playing around with the Companies house API. You should see the below when you call the API to get people. The two Items in the list are the two persons with significant control in this case. Feel free to DM if you want to explore further...
Clay Support
APP
·
·
Perfect! You've found the right action. "Write each item to new row in other table" will split your shareholders into separate rows while preserving the company data. [1]
This creates one row per shareholder with the company details duplicated across all rows - exactly what you need for flattening your Companies House API results. [2]
Clay Support
APP
·
·
Is that what you were looking for?
Clay Support
APP
·
·
If you still need help with splitting your shareholder data into separate rows while keeping company details, I’m here to assist. Would you like to share more about your current setup or any specific challenges you’re facing with this process?