Connexion Facebook pour LinkyFlow
LinkyFlow connecte Excel a Facebook pour consulter, modifier et publier les donnees e-commerce utiles depuis un tableur.
Ressources
10
Requetes de lecture
7
Actions ecriture
14
Champs documentes
86
Workflows a ramener dans Excel
Chaque ressource ci-dessous correspond a un workflow tableur concret. Les lectures ramenent des colonnes utiles dans Excel; les creations et modifications indiquent ce qui peut etre relu en lignes avant envoi.
Engagement
Comments
The comments on a Page’s posts — by people and by the Page —, with who wrote each, its likes and replies, whether it is hidden, and what the Page may do with it.
Comments
The comments on a Page’s posts — by people and by the Page —, with who wrote each, its likes and replies, whether it is hidden, and what the Page may do with it.
Route: GET /comments
Formule Excel: =LF.facebook.comments("selection", "fields")
Entrees configurables
Donnees retournees dans Excel
Field | Type | Relations | Description |
|---|---|---|---|
iddefault | id | — | - |
messagedefault | string | — | - |
from_namedefault | string | — | - |
created_timedefault | date | — | - |
like_countdefault | number | — | - |
is_hiddendefault | boolean | — | - |
Create Comment
Create Comment
Route: POST /mutation/comments
Entrees configurables
Donnees retournees dans Excel
Cette action retourne une confirmation plutot qu une table selectionnable.
Update Comment
Update Comment
Route: PATCH /mutation/comments
Entrees configurables
Donnees retournees dans Excel
Cette action retourne une confirmation plutot qu une table selectionnable.
Delete Comment
Delete Comment
Route: DELETE /mutation/comments
Entrees configurables
Donnees retournees dans Excel
Cette action retourne une confirmation plutot qu une table selectionnable.
Hide Comment
Hides this comment from everyone but its author and their friends, who are not told. Undone by Unhide Comment.
Hide Comment
Hide Comment
Route: POST /mutation/commentHide
Entrees configurables
Donnees retournees dans Excel
Cette action retourne une confirmation plutot qu une table selectionnable.
Reply to Comment
Replies to this comment as the Page, under it, for everyone who can see the post.
Reply to Comment
Reply to Comment
Route: POST /mutation/commentReply
Entrees configurables
Donnees retournees dans Excel
Cette action retourne une confirmation plutot qu une table selectionnable.
Unhide Comment
Shows this hidden comment again to everyone who can see the post.
Unhide Comment
Unhide Comment
Route: POST /mutation/commentUnhide
Entrees configurables
Donnees retournees dans Excel
Cette action retourne une confirmation plutot qu une table selectionnable.
Insights
Page Insights
What Facebook counts on a Page, metric by metric and period by period: views, reach, engagement, follows, video views. One row per metric and period end.
Page Insights
What Facebook counts on a Page, metric by metric and period by period: views, reach, engagement, follows, video views. One row per metric and period end.
Route: GET /pageInsights
Formule Excel: =LF.facebook.pageInsights("selection", "fields")
Entrees configurables
Donnees retournees dans Excel
Field | Type | Relations | Description |
|---|---|---|---|
id | id | — | - |
metricdefault | string | — | - |
perioddefault | string | — | - |
end_timedefault | date | — | - |
valuedefault | number | — | - |
breakdown | string | — | - |
title | string | — | - |
description | string | — | - |
page_id | id | — | - |
Post Insights
What Facebook counts on a post over its lifetime: views, people reached, clicks, reactions by kind. One row per metric.
Post Insights
What Facebook counts on a post over its lifetime: views, people reached, clicks, reactions by kind. One row per metric.
Route: GET /postInsights
Formule Excel: =LF.facebook.postInsights("selection", "fields")
Entrees configurables
Donnees retournees dans Excel
Field | Type | Relations | Description |
|---|---|---|---|
id | id | — | - |
metricdefault | string | — | - |
perioddefault | string | — | - |
end_timedefault | date | — | - |
valuedefault | number | — | - |
breakdown | string | — | - |
title | string | — | - |
description | string | — | - |
post_iddefault | id | — | - |
page_id | id | — | - |
Pages
Pages
The Facebook Pages the person granted LinkyFlow: each one’s profile, audience, what the person may do on it (tasks) and whether its access still works.
Utilise comme filtre par
Pages
The Facebook Pages the person granted LinkyFlow: each one’s profile, audience, what the person may do on it (tasks) and whether its access still works.
Route: GET /pages
Formule Excel: =LF.facebook.pages("selection", "fields")
Entrees configurables
Donnees retournees dans Excel
Field | Type | Relations | Description |
|---|---|---|---|
iddefault | id | — | - |
namedefault | string | — | - |
categorydefault | string | — | - |
followers_countdefault | number | — | - |
tasksdefault | string | — | - |
token_statusdefault | enum | — | - |
Publishing
Photos
The photos a Page uploaded, newest first: each one’s caption, size and address.
Photos
The photos a Page uploaded, newest first: each one’s caption, size and address.
Route: GET /photos
Formule Excel: =LF.facebook.photos("selection", "fields")
Entrees configurables
Donnees retournees dans Excel
Field | Type | Relations | Description |
|---|---|---|---|
iddefault | id | — | - |
namedefault | string | — | - |
created_timedefault | date | — | - |
updated_time | date | — | - |
urldefault | string | — | - |
picture | string | — | - |
width | number | — | - |
height | number | — | - |
page_id | id | — | - |
Create Photo
Create Photo
Route: POST /mutation/photos
Entrees configurables
Donnees retournees dans Excel
Cette action retourne une confirmation plutot qu une table selectionnable.
Delete Photo
Delete Photo
Route: DELETE /mutation/photos
Entrees configurables
Donnees retournees dans Excel
Cette action retourne une confirmation plutot qu une table selectionnable.
Posts
The posts a Page published — text, links, photos, videos —, newest first, with how many reactions, comments and shares each received.
Utilise comme filtre par
Posts
The posts a Page published — text, links, photos, videos —, newest first, with how many reactions, comments and shares each received.
Route: GET /posts
Formule Excel: =LF.facebook.posts("selection", "fields")
Entrees configurables
Donnees retournees dans Excel
Field | Type | Relations | Description |
|---|---|---|---|
iddefault | id | — | - |
messagedefault | string | — | - |
created_timedefault | date | — | - |
urldefault | string | — | - |
reactions_countdefault | number | — | - |
comments_countdefault | number | — | - |
shares_countdefault | number | — | - |
Create Post
Create Post
Route: POST /mutation/posts
Entrees configurables
Donnees retournees dans Excel
Cette action retourne une confirmation plutot qu une table selectionnable.
Update Post
Update Post
Route: PATCH /mutation/posts
Entrees configurables
Donnees retournees dans Excel
Cette action retourne une confirmation plutot qu une table selectionnable.
Delete Post
Delete Post
Route: DELETE /mutation/posts
Entrees configurables
Donnees retournees dans Excel
Cette action retourne une confirmation plutot qu une table selectionnable.
Videos
The videos a Page published, newest first: title, length, and where Facebook is with each (processing until it can be watched, ready, error).
Videos
The videos a Page published, newest first: title, length, and where Facebook is with each (processing until it can be watched, ready, error).
Route: GET /videos
Formule Excel: =LF.facebook.videos("selection", "fields")
Entrees configurables
Donnees retournees dans Excel
Field | Type | Relations | Description |
|---|---|---|---|
iddefault | id | — | - |
titledefault | string | — | - |
description | string | — | - |
created_timedefault | date | — | - |
updated_time | date | — | - |
urldefault | string | — | - |
length | number | — | - |
statusdefault | string | — | - |
published | boolean | — | - |
picture | string | — | - |
page_id | id | — | - |
Create Video
Create Video
Route: POST /mutation/videos
Entrees configurables
Donnees retournees dans Excel
Cette action retourne une confirmation plutot qu une table selectionnable.
Update Video
Update Video
Route: PATCH /mutation/videos
Entrees configurables
Donnees retournees dans Excel
Cette action retourne une confirmation plutot qu une table selectionnable.
Delete Video
Delete Video
Route: DELETE /mutation/videos
Entrees configurables
Donnees retournees dans Excel
Cette action retourne une confirmation plutot qu une table selectionnable.