Connexion Buffer pour LinkyFlow
LinkyFlow connecte Excel a Buffer pour consulter, modifier et publier les donnees e-commerce utiles depuis un tableur.
Ressources
11
Requetes de lecture
9
Actions ecriture
12
Champs documentes
118
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
Account
The Buffer account this connection reaches: its name, time zone and creation date.
Account
The Buffer account this connection reaches: its name, time zone and creation date.
Route: GET /account
Formule Excel: =LF.buffer.account("selection", "fields")
Entrees configurables
Donnees retournees dans Excel
Field | Type | Relations | Description |
|---|---|---|---|
iddefault | id | — | - |
namedefault | string | — | - |
timezonedefault | string | — | - |
createdAtdefault | date | — | - |
Channels
The social channels connected to an organization — a LinkedIn page, an X profile, an Instagram account… —, whether they can publish, and their queue.
Utilise comme filtre par
Channels
The social channels connected to an organization — a LinkedIn page, an X profile, an Instagram account… —, whether they can publish, and their queue.
Route: GET /channels
Formule Excel: =LF.buffer.channels("selection", "fields")
Entrees configurables
Donnees retournees dans Excel
Field | Type | Relations | Description |
|---|---|---|---|
iddefault | id | — | - |
namedefault | string | — | - |
servicedefault | enum | — | - |
typedefault | string | — | - |
externalLinkdefault | string | — | - |
isDisconnecteddefault | boolean | — | - |
isLockeddefault | boolean | — | - |
isQueuePauseddefault | boolean | — | - |
Organizations
The organizations the account belongs to, with what their plan allows: every channel, post, idea and tag belongs to one.
Utilise comme filtre par
Organizations
The organizations the account belongs to, with what their plan allows: every channel, post, idea and tag belongs to one.
Route: GET /organizations
Formule Excel: =LF.buffer.organizations("selection", "fields")
Entrees configurables
Donnees retournees dans Excel
Field | Type | Relations | Description |
|---|---|---|---|
iddefault | id | — | - |
namedefault | string | — | - |
channelCountdefault | number | — | - |
limits | string | — | - |
channelsdefault | number | — | - |
scheduledPostsdefault | number | — | - |
members | number | — | - |
ideas | number | — | - |
tags | number | — | - |
scheduledThreadsPerChannel | number | — | - |
scheduledStoriesPerChannel | number | — | - |
Tags
The tags an organization puts on its posts and ideas, by name.
Utilise comme filtre par
Tags
The tags an organization puts on its posts and ideas, by name.
Route: GET /tags
Formule Excel: =LF.buffer.tags("selection", "fields")
Entrees configurables
Donnees retournees dans Excel
Field | Type | Relations | Description |
|---|---|---|---|
iddefault | id | — | - |
namedefault | string | — | - |
colordefault | string | — | - |
colorName | string | — | - |
isLocked | boolean | — | - |
Create Tag
Create Tag
Route: POST /mutation/tags
Entrees configurables
Donnees retournees dans Excel
Cette action retourne une confirmation plutot qu une table selectionnable.
Update Tag
Update Tag
Route: PATCH /mutation/tags
Entrees configurables
Donnees retournees dans Excel
Cette action retourne une confirmation plutot qu une table selectionnable.
Delete Tag
Delete Tag
Route: DELETE /mutation/tags
Entrees configurables
Donnees retournees dans Excel
Cette action retourne une confirmation plutot qu une table selectionnable.
Analytics
Post Metrics
What the organization’s sent posts achieved over a period, summed by Buffer: how many posts, impressions, reactions, comments, clicks… One row.
Post Metrics
What the organization’s sent posts achieved over a period, summed by Buffer: how many posts, impressions, reactions, comments, clicks… One row.
Route: GET /postMetrics
Formule Excel: =LF.buffer.postMetrics("selection", "fields")
Entrees configurables
Donnees retournees dans Excel
Field | Type | Relations | Description |
|---|---|---|---|
postCountdefault | number | — | - |
impressionsdefault | number | — | - |
reach | number | — | - |
reactionsdefault | number | — | - |
commentsdefault | number | — | - |
shares | number | — | - |
reposts | number | — | - |
clicksdefault | number | — | - |
engagementRate | number | — | - |
views | number | — | - |
saves | number | — | - |
likes | number | — | - |
quotes | number | — | - |
follows | number | — | - |
viewers | number | — | - |
averageTimeWatched | number | — | - |
totalTimeWatched | number | — | - |
metricsUpdatedAt | date | — | - |
Posts
Idea Groups
The columns an organization sorts its ideas into (To Do, In Progress…).
Idea Groups
The columns an organization sorts its ideas into (To Do, In Progress…).
Route: GET /ideaGroups
Formule Excel: =LF.buffer.ideaGroups("selection", "fields")
Entrees configurables
Donnees retournees dans Excel
Field | Type | Relations | Description |
|---|---|---|---|
iddefault | id | — | - |
namedefault | string | — | - |
isLockeddefault | boolean | — | - |
Ideas
The organization’s ideas: the posts it plans, with their networks and target date. None is published.
Ideas
The organization’s ideas: the posts it plans, with their networks and target date. None is published.
Route: GET /ideas
Formule Excel: =LF.buffer.ideas("selection", "fields")
Entrees configurables
Donnees retournees dans Excel
Field | Type | Relations | Description |
|---|---|---|---|
iddefault | id | — | - |
titledefault | string | — | - |
textdefault | string | — | - |
servicesdefault | string[] | — | - |
datedefault | date | — | - |
createdAtdefault | number | — | - |
Create Idea
Create Idea
Route: POST /mutation/ideas
Entrees configurables
Donnees retournees dans Excel
Cette action retourne une confirmation plutot qu une table selectionnable.
Move In Queue
Moves this queued post to the top or the bottom of its channel’s queue: the queue’s posts are published in the new order.
Move In Queue
Move In Queue
Route: POST /mutation/moveInQueue
Entrees configurables
Donnees retournees dans Excel
Cette action retourne une confirmation plutot qu une table selectionnable.
Post Templates
The templates a post can start from: Buffer’s public library, the organization’s internal ones and the account’s private ones. None is published.
Post Templates
The templates a post can start from: Buffer’s public library, the organization’s internal ones and the account’s private ones. None is published.
Route: GET /postTemplates
Formule Excel: =LF.buffer.postTemplates("selection", "fields")
Entrees configurables
Donnees retournees dans Excel
Field | Type | Relations | Description |
|---|---|---|---|
iddefault | id | — | - |
titledefault | string | — | - |
bodydefault | string | — | - |
descriptiondefault | string | — | - |
emoji | string | — | - |
visibilitydefault | enum | — | - |
organizationId | id | — | - |
createdAt | date | — | - |
updatedAt | date | — | - |
Create Post Template
Create Post Template
Route: POST /mutation/postTemplates
Entrees configurables
Donnees retournees dans Excel
Cette action retourne une confirmation plutot qu une table selectionnable.
Update Post Template
Update Post Template
Route: PATCH /mutation/postTemplates
Entrees configurables
Donnees retournees dans Excel
Cette action retourne une confirmation plutot qu une table selectionnable.
Delete Post Template
Delete Post Template
Route: DELETE /mutation/postTemplates
Entrees configurables
Donnees retournees dans Excel
Cette action retourne une confirmation plutot qu une table selectionnable.
Posts
The organization’s posts on every channel, the latest first: drafts, queued, sent and failed, with their date, their link once sent and their metrics.
Posts
The organization’s posts on every channel, the latest first: drafts, queued, sent and failed, with their date, their link once sent and their metrics.
Route: GET /posts
Formule Excel: =LF.buffer.posts("selection", "fields")
Entrees configurables
Donnees retournees dans Excel
Field | Type | Relations | Description |
|---|---|---|---|
iddefault | id | — | - |
textdefault | string | — | - |
statusdefault | enum | — | - |
channelIddefault | id | → channels | - |
channelServicedefault | enum | — | - |
dueAtdefault | date | — | - |
sentAtdefault | date | — | - |
externalLinkdefault | string | — | - |
impressionsdefault | number | — | - |
reactionsdefault | number | — | - |
commentsdefault | number | — | - |
clicksdefault | 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.
Publish Now
Publishes this post on its channel’s network at once, whatever its date or its place in the queue.
Publish Now
Publish Now
Route: POST /mutation/publishNow
Entrees configurables
Donnees retournees dans Excel
Cette action retourne une confirmation plutot qu une table selectionnable.