Windsor brings all your Apify Dataset data into Power BI, Looker Studio, Google Sheets, Excel, BigQuery, Snowflake, Tableau, Azure, PostgreSQL, MySQL, Python, Amazon S3, Azure, Azure MS SQL
Apify Dataset Field Reference
Fields
| ID | Type | Name | Description | Report |
|---|---|---|---|---|
| dataset__accessedAt | TEXT | dataset.accessedAt | dataset.accessedAt | dataset |
| dataset__actId | TEXT | dataset.actId | dataset.actId | dataset |
| dataset__actRunId | TEXT | dataset.actRunId | dataset.actRunId | dataset |
| dataset__cleanItemCount | NUMERIC | dataset.cleanItemCount | dataset.cleanItemCount | dataset |
| dataset__createdAt | TEXT | dataset.createdAt | dataset.createdAt | dataset |
| dataset__fields | TEXT | dataset.fields | dataset.fields | dataset |
| dataset__id | TEXT | dataset.id | dataset.id | dataset |
| dataset__itemCount | NUMERIC | dataset.itemCount | dataset.itemCount | dataset |
| dataset__modifiedAt | TEXT | dataset.modifiedAt | dataset.modifiedAt | dataset |
| dataset__name | TEXT | dataset.name | dataset.name | dataset |
| dataset__schema | OBJECT | dataset.schema | dataset.schema | dataset |
| dataset__stats | OBJECT | dataset.stats | dataset.stats | dataset |
| dataset__title | TEXT | dataset.title | dataset.title | dataset |
| dataset__userId | TEXT | dataset.userId | dataset.userId | dataset |
| dataset_collection__accessedAt | TEXT | dataset_collection.accessedAt | dataset_collection.accessedAt | dataset_collection |
| dataset_collection__actId | TEXT | dataset_collection.actId | dataset_collection.actId | dataset_collection |
| dataset_collection__actRunId | TEXT | dataset_collection.actRunId | dataset_collection.actRunId | dataset_collection |
| dataset_collection__cleanItemCount | NUMERIC | dataset_collection.cleanItemCount | dataset_collection.cleanItemCount | dataset_collection |
| dataset_collection__createdAt | TEXT | dataset_collection.createdAt | dataset_collection.createdAt | dataset_collection |
| dataset_collection__fields | TEXT | dataset_collection.fields | dataset_collection.fields | dataset_collection |
| dataset_collection__id | TEXT | dataset_collection.id | dataset_collection.id | dataset_collection |
| dataset_collection__itemCount | NUMERIC | dataset_collection.itemCount | dataset_collection.itemCount | dataset_collection |
| dataset_collection__modifiedAt | TEXT | dataset_collection.modifiedAt | dataset_collection.modifiedAt | dataset_collection |
| dataset_collection__name | TEXT | dataset_collection.name | dataset_collection.name | dataset_collection |
| dataset_collection__schema | TEXT | dataset_collection.schema | dataset_collection.schema | dataset_collection |
| dataset_collection__stats | OBJECT | dataset_collection.stats | dataset_collection.stats | dataset_collection |
| dataset_collection__title | TEXT | dataset_collection.title | dataset_collection.title | dataset_collection |
| dataset_collection__userId | TEXT | dataset_collection.userId | dataset_collection.userId | dataset_collection |
| dataset_collection__username | TEXT | dataset_collection.username | dataset_collection.username | dataset_collection |
| datasource | TEXT | Data Source | The name of the Windsor connector returning the row | |
| item_collection__data | OBJECT | item_collection.data | item_collection.data | item_collection |
| item_collection_website_content_crawler__crawl | OBJECT | item_collection_website_content_crawler.crawl | item_collection_website_content_crawler.crawl | item_collection_website_content_crawler |
| item_collection_website_content_crawler__markdown | TEXT | item_collection_website_content_crawler.markdown | item_collection_website_content_crawler.markdown | item_collection_website_content_crawler |
| item_collection_website_content_crawler__metadata | OBJECT | item_collection_website_content_crawler.metadata | item_collection_website_content_crawler.metadata | item_collection_website_content_crawler |
| item_collection_website_content_crawler__screenshotUrl | TEXT | item_collection_website_content_crawler.screenshotUrl | item_collection_website_content_crawler.screenshotUrl | item_collection_website_content_crawler |
| item_collection_website_content_crawler__text | TEXT | item_collection_website_content_crawler.text | item_collection_website_content_crawler.text | item_collection_website_content_crawler |
| item_collection_website_content_crawler__url | TEXT | item_collection_website_content_crawler.url | item_collection_website_content_crawler.url | item_collection_website_content_crawler |
| source | TEXT | Source | The name of the Windsor connector returning the row | |
| today | DATE | Today | Today's date |