Windsor brings all your Line data into Power BI, Looker Studio, Google Sheets, Excel, BigQuery, Snowflake, Tableau, Azure, PostgreSQL, MySQL, Python, Amazon S3, Azure MS SQL
Line Field Reference
Sample
The Line connector pulls message an follower data from Line.
A sample URL to query message data:
https://connectors.windsor.ai/line?api_key=[API_KEY]&fields=date,account_id,channel_id,account_name,basic_id,message__broadcast,message__api_broadcast,message__api_push,message__status,message__chat
A sample URL to query follower data:
https://connectors.windsor.ai/line?api_key=[API_KEY]&fields=date,account_id,channel_id,account_name,basic_id,followers__status,followers__followers,followers__blocks,display_name
Fields
ID | Type | Name | Description | Report |
---|---|---|---|---|
account_id | TEXT | account id | Same as channel_id | |
account_name | TEXT | account name | Same as channel_id | |
basic_id | TEXT | basicId | Bot's basic ID | bot_info |
channel_id | TEXT | channel ID | Unique identifier for the channel | |
datasource | TEXT | Data Source | The name of the Windsor connector returning the row | |
date | DATE | Date | The Date | |
day_of_month | TEXT | Day of month | Day of the month | |
display_name | TEXT | display name | Bot's display name | bot_info |
followers__blocks | NUMERIC | blocks | The number of users blocking the account as of the specified date. The number decreases when a user unblocks the account. | insight_followers |
followers__followers | NUMERIC | followers | The number of times, as of the specified date, that a user added this LINE Official Account as a friend for the first time. The number doesn't decrease even if a user later blocks the account or when they delete their LINE account. | insight_followers |
followers__status | TEXT | insight_followers_status | Status of the counting process of number of followers. One of: ready, unready, out_of_service | insight_followers |
followers__targeted_reaches | NUMERIC | targeted_reaches | The number of users, as of the specified date, that the LINE Official Account can reach through targeted messages based on gender, age, and/or region. This number only includes users who are active on LINE or LINE services and whose demographics have a high level of certainty. | insight_followers |
message__api_broadcast | NUMERIC | api_broadcast | Number of broadcast messages sent with the Send broadcast message Messaging API operation. | insight_message_delivery |
message__api_multicast | NUMERIC | api_multicast | Number of multicast messages sent with the Send multicast message Messaging API operation. | insight_message_delivery |
message__api_narrowcast | NUMERIC | api_narrowcast | Number of narrowcast messages sent with the Send narrowcast message Messaging API operation. | insight_message_delivery |
message__api_push | NUMERIC | api_push | Number of push messages sent with the Send push message Messaging API operation. | insight_message_delivery |
message__api_reply | NUMERIC | api_reply | Number of replies sent with the Send reply message Messaging API operation. | insight_message_delivery |
message__auto_response | NUMERIC | auto_response | Number of auto-response messages sent. | insight_message_delivery |
message__broadcast | NUMERIC | broadcast | Number of messages sent to all of this LINE Official Account's friends (broadcast messages). | insight_message_delivery |
message__chat | NUMERIC | chat | Number of messages sent from LINE Official Account Manager Chat screen. | insight_message_delivery |
message__status | TEXT | insight_message_delivery_status | Status of the counting process of message deliveries. One of: ready, unready, out_of_service | insight_message_delivery |
message__targeting | NUMERIC | targeting | Number of messages sent to some of this LINE Official Account's friends, based on specific attributes (targeted messages). | insight_message_delivery |
message__welcome_response | NUMERIC | welcome_response | Number of greeting messages sent. | insight_message_delivery |
month | TEXT | Month | Number of the month | |
source | TEXT | Source | The name of the Windsor connector returning the row | |
today | DATE | Today | Today's date | |
week | TEXT | Week | Week (Sun-Sat). | |
week_day | TEXT | Day of week and day number | Weekday number and name combined (Sun-Sat).Numbered from 0 Sunday to 6 Saturday. | |
week_day_iso | TEXT | Day of week and day number, ISO | Weekday number and name combined, ISO format (Mon-Sun).Numbered from 1 Monday to 7 | |
week_iso | TEXT | Week ISO | Week, ISO format (Mon-Sun). | |
year | TEXT | Year | Year | |
year_month | TEXT | Yearmonth | Year and month, e.g. 2024|3 | |
year_of_week | TEXT | Year of week | The year that contains first day of the week (Sun-Sat). | |
year_of_week_iso | TEXT | Year of week, ISO | The year that contains first day of the ISO week (Mon-Sun). | |
year_week | TEXT | Year week | Year and week for US weeks (Sun-Sat), e.g. 2024|15 | |
year_week_iso | TEXT | Year week ISO | Year and week for ISO weeks (Mon-Sun), e.g. 2024|20 |