Connexion LinkedIn pour LinkyFlow
LinkyFlow connecte Excel a LinkedIn pour consulter, modifier et publier les donnees e-commerce utiles depuis un tableur.
Ressources
7
Requetes de lecture
7
Actions ecriture
8
Champs documentes
91
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.
Account
Profile and Pages
The member this connection is, then each LinkedIn page they hold an approved role on: who a post, a comment or a reaction can be written as.
Utilise comme filtre par
Profile and Pages
The member this connection is, then each LinkedIn page they hold an approved role on: who a post, a comment or a reaction can be written as.
Route: GET /authors
Formule Excel: =LF.linkedin.authors("selection", "fields")
Entrees configurables
Donnees retournees dans Excel
Field | Type | Relations | Description |
|---|---|---|---|
iddefault | id | — | - |
kinddefault | enum | — | - |
namedefault | string | — | - |
roledefault | enum | — | - |
state | enum | — | - |
vanityName | string | — | - |
localizedWebsite | string | — | - |
Posts
Comments
The comments on a post of a page the member administers, and the replies to them: who wrote them, their text and when.
Comments
The comments on a post of a page the member administers, and the replies to them: who wrote them, their text and when.
Route: GET /comments
Formule Excel: =LF.linkedin.comments("selection", "fields")
Entrees configurables
Donnees retournees dans Excel
Field | Type | Relations | Description |
|---|---|---|---|
iddefault | id | — | - |
commentId | id | — | - |
objectdefault | id | — | - |
actordefault | id | — | - |
message | string | — | - |
textdefault | string | — | - |
created | string | — | - |
timedefault | number | — | - |
lastModified | string | — | - |
time | number | — | - |
parentComment | id | → comments | - |
likesSummary | string | — | - |
totalLikes | number | — | - |
commentsSummary | string | — | - |
aggregatedTotalComments | number | — | - |
Comment on Post
Comment on Post
Route: POST /mutation/comments
Entrees configurables
Donnees retournees dans Excel
Cette action retourne une confirmation plutot qu une table selectionnable.
Edit Comment
Edit 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.
Post Engagement
What a post of a page the member administers has gathered: its reactions by kind, its comments, and whether comments are open.
Post Engagement
What a post of a page the member administers has gathered: its reactions by kind, its comments, and whether comments are open.
Route: GET /postEngagement
Formule Excel: =LF.linkedin.postEngagement("selection", "fields")
Entrees configurables
Donnees retournees dans Excel
Field | Type | Relations | Description |
|---|---|---|---|
entitydefault | id | — | - |
reactionSummaries | string | — | - |
LIKE | string | — | - |
PRAISE | string | — | - |
EMPATHY | string | — | - |
INTEREST | string | — | - |
APPRECIATION | string | — | - |
ENTERTAINMENT | string | — | - |
commentSummary | string | — | - |
countdefault | number | — | - |
topLevelCount | number | — | - |
commentsState | enum | — | - |
Posts
The posts of a page the member administers, newest first: their text, visibility, state, media or link, and when they were published. LinkedIn lets no application list a member’s own posts.
Utilise comme filtre par
Posts
The posts of a page the member administers, newest first: their text, visibility, state, media or link, and when they were published. LinkedIn lets no application list a member’s own posts.
Route: GET /posts
Formule Excel: =LF.linkedin.posts("selection", "fields")
Entrees configurables
Donnees retournees dans Excel
Field | Type | Relations | Description |
|---|---|---|---|
iddefault | id | — | - |
authordefault | id | → authors | - |
commentarydefault | string | — | - |
visibilitydefault | enum | — | - |
lifecycleStatedefault | enum | — | - |
publishedAtdefault | number | — | - |
Publish Post
Publish Post
Route: POST /mutation/posts
Entrees configurables
Donnees retournees dans Excel
Cette action retourne une confirmation plutot qu une table selectionnable.
Edit Post
Edit 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.
Reactions
The reactions to a post of a page the member administers: who reacted, how and when.
Reactions
The reactions to a post of a page the member administers: who reacted, how and when.
Route: GET /reactions
Formule Excel: =LF.linkedin.reactions("selection", "fields")
Entrees configurables
Donnees retournees dans Excel
Field | Type | Relations | Description |
|---|---|---|---|
iddefault | id | — | - |
reactionTypedefault | enum | — | - |
rootdefault | id | — | - |
created | string | — | - |
actordefault | id | — | - |
timedefault | number | — | - |
React to Post
React to Post
Route: POST /mutation/reactions
Entrees configurables
Donnees retournees dans Excel
Cette action retourne une confirmation plutot qu une table selectionnable.
Remove Reaction
Remove Reaction
Route: DELETE /mutation/reactions
Entrees configurables
Donnees retournees dans Excel
Cette action retourne une confirmation plutot qu une table selectionnable.
Statistics
My Post Statistics
What the member’s own posts gathered — impressions, members reached, reactions, comments, reshares and more —, for all of them or one, in all or day by day.
My Post Statistics
What the member’s own posts gathered — impressions, members reached, reactions, comments, reshares and more —, for all of them or one, in all or day by day.
Route: GET /memberPostStatistics
Formule Excel: =LF.linkedin.memberPostStatistics("selection", "fields")
Entrees configurables
Donnees retournees dans Excel
Field | Type | Relations | Description |
|---|---|---|---|
queryTypedefault | enum | — | - |
countdefault | number | — | - |
datedefault | string | — | - |
entity | id | — | - |
Page Statistics
What the organic posts of a page the member administers gathered: impressions, clicks, reactions, comments, shares and engagement — in all, per post, or day by day or month by month over a period of the last twelve months.
Page Statistics
What the organic posts of a page the member administers gathered: impressions, clicks, reactions, comments, shares and engagement — in all, per post, or day by day or month by month over a period of the last twelve months.
Route: GET /pageStatistics
Formule Excel: =LF.linkedin.pageStatistics("selection", "fields")
Entrees configurables
Donnees retournees dans Excel
Field | Type | Relations | Description |
|---|---|---|---|
organizationalEntitydefault | id | — | - |
startdefault | number | — | - |
impressionCountdefault | number | — | - |
uniqueImpressionsCountdefault | number | — | - |
clickCountdefault | number | — | - |
likeCountdefault | number | — | - |
commentCountdefault | number | — | - |
shareCountdefault | number | — | - |
engagementdefault | number | — | - |