The community member is enriching data from Storeleads on about 10,000 eCommerce companies, using the "Facebook Ads Scraper" and "Instagram Profile Scraper" to find the latest post and ad details. The issue is that the output has thousands of columns with metadata they don't need, and they can't omit the "results" column without losing all the results. The community member is looking for a way to grab only the latest result from the output within Apify, without needing to use complex code.
In the comments, another community member suggests that it's not currently possible to limit the number of nested items, but they recommend trying to unwind the results and process only the first item on the user's side.
I'm currently enriching data I got from Storeleads on about 10k eCommerce companies I'm doing outreach to. The data comes with store name, Facebook URL, & Instagram URL, so I'm using the "Facebook Ads Scraper" and "Instagram Profile Scraper" to enrich these companies.
I want to find the last post & latest ad (startDate/endDate fields & ad description for FB; latestPost & likes/cmments for IG).
The problem is I get thousands of columns with a bunch of other metadata I don't need. I also can't omit the "results" column because I'll lose all results instead of the first one.
Anyone know a way to grab the latest result these from the output within Apify? I'm not savvy with code so preferably without any console wizardry.
hi, it's unfortunately not possible to limit the number of nested items currently. You can however try to take a look at Advanced options when exporting the dataset, unwind results and process only the first item on your side
