how do I run Apify actor inside of Clay.com? Got this as error:
{
"error": {
"type": "invalid-input",
"message": "Cannot parse input JSON body: Expected property name or '}' in JSON at position 1 (line 1 column 2)"
}
}
To run an Apify actor in Clay without the "Cannot parse input JSON body" error, follow these steps: 1. In your Clay workbook, click "+ Add" and search for "Apify" or use the enrichment search bar. 2. Select your Apify account and choose the actor you want to run. 3. In the "Input Data" section, enter your data in JSON format. Make sure to: • Use double quotes for keys and string values • Separate key-value pairs with commas • Avoid extra spaces or hidden characters 4. When using column tokens, keep the key in quotes, but don't put quotes around the token itself. For example: { "email": ##{{email field}}, "name": ##{{name field}} } To troubleshoot further, please copy and paste your JSON input into the chat so I can help identify any specific issues.
{ "Company Linkedin URL": ## Company Linked In URL}
To fix the JSON input error for your Apify actor in Clay, you need to adjust the formatting of your input. Here's the corrected version: LBKS{ "Company Linkedin URL": ##{{Company Linked In URL}} }LBKS
The main issues were:
1. Missing quotes around the column token.
2. Extra space in the column name.
When using column tokens in Clay, keep the key in quotes, but don't wrap the value (column token) in quotes. Also, make sure to use the exact column name without extra spaces.
If you're still experiencing issues, please paste your entire JSON input so I can help troubleshoot further.
Source: Run Apify Actor with Apify
{ "Company Linkedin URL": ##{{Company Linked In URL}} }
The JSON input you provided looks correct for use with an Apify actor in Clay. Here's a breakdown: 1. The key "Company Linkedin URL" is properly enclosed in double quotes. 2. The value uses the correct Clay column token format: ##{{Column Name}}. 3. There are no extra spaces or characters causing issues. If you're still encountering an error, it might be due to: 1. The exact column name in your Clay table. Ensure it's "Company Linked In URL" with spaces. 2. Any hidden characters or formatting issues not visible in plain text. To troubleshoot further, try: 1. Double-check the column name in your Clay table. 2. Copy the JSON into a text editor to spot any hidden characters. 3. If issues persist, use Clay's built-in debugger or an online JSON validator.
are there other scrapers I can use to scrap employee growth or new hires from company Linkedin profile?
We offer a few options to extract employee growth and new hire information from LinkedIn company profiles: 1. "Find Company Headcount Growth" action: This retrieves headcount growth data over time using company social profiles. 2. "Find Employee Headcount by Criteria" action: This allows you to find specific employee counts based on certain criteria. Both actions use our "Companies, People, and Jobs" integration, which can access LinkedIn data. To use these, you'll need to provide either the company's LinkedIn URL, Sales Navigator URL, or website domain. For more detailed information or if you need help setting this up, please let me know.
yes but are there other scrapers? or data source? Clay's built in Find Company Headcount Growth isn't accurate
Yes, there are alternative options for more accurate employee growth and new hire data from LinkedIn company profiles: 1. External scrapers: Tools like Phantombuster or Apify can provide more up-to-date data. However, be cautious as using these may put your LinkedIn account at risk. 2. Clay's native actions: We offer "Find Company Headcount Growth" and "Find Employee Headcount by Criteria" actions using our "Companies, People, and Jobs" integration. 3. Other Clay integrations: Consider exploring Owler, People Data Labs, or ZoomInfo for company data enrichment. If you need further assistance or have concerns about data accuracy, please request human support by clicking "Talk to a person".
Hey team, im trying to run Apify actor inside of Clay, one that requires Linkedin Sales Nav cookie session. Can you show me how to implement it? I know how to extract data from Apify if the initial scrping is done there. But in this instance I need the Apify actor to run inside of Clay table based of company Linkedin url inputs from the table
Hey, Can you send over the table URL and the actor URL so we can take a closer look? Usually, you’ll want to copy the input JSON directly from the Apify actor’s Input tab—this shows the exact format needed. Paste that into Clay as-is, and once it’s working, you can start replacing values with dynamic Clay fields. Let me know if you run into any issues!