TikTok

Knowi enables visualization, analysis, and reporting automation from your TikTok account data.

Connect your TikTok account to pull your profile stats and video performance ? views, likes, comments, shares, and follower counts ? into Knowi for dashboards and automated reports, with no manual exports needed.

Overview

Connect to TikTok using the TikTok for Developers Display API. Knowi requests read-only access to your profile, stats, and public video list. Knowi never posts to your account.

The connection uses OAuth: TikTok issues a short-lived access token plus a long-lived refresh token, and Knowi automatically refreshes the access token as needed so scheduled queries keep working.

Connecting

  1. Log in to Knowi and select "Queries" from the left sidebar.

  2. Click the "New Datasource +" button and select TikTok from the list of datasources under API & Cloud Services.

  3. Configure the following details:

    a. Datasource Name: Enter a name for your datasource (e.g., "My TikTok Account").

    b. Refresh Token: Click "Authenticate" to connect your TikTok account. You will be redirected to TikTok to approve access.

  4. On the TikTok consent screen, review the requested permissions (profile info, stats, and video list) and approve to continue.

  5. After approving, you will be redirected back to Knowi. Click "Save" to finish setting up the datasource.

To revoke access at any time, open the TikTok app and go to Settings and privacy ? Security & permissions ? Apps and websites.

Report Types

After connecting, select a report type from the dropdown to query your TikTok data.

Profile & Stats

Retrieves your profile and aggregate statistics including follower count, following count, total likes, and video count.

Parameters:

  • Fields (required) ? Comma-separated profile fields. Stats: follower_count, following_count, likes_count, video_count. Profile: open_id, union_id, avatar_url, display_name, bio_description, profile_deep_link, is_verified.

Default Cloud9QL:

select data.user;

Video List

Retrieves the list of videos on your account with per-video metrics and metadata. The response includes a cursor and has_more flag for paging through older videos.

Parameters:

  • Fields (required) ? Comma-separated video fields. Metrics: view_count, like_count, comment_count, share_count. Metadata: id, title, video_description, duration, cover_image_url, share_url, create_time.
  • Request Body (JSON) (required) ? max_count (1?20) sets the page size; cursor (Unix-ms of the last video on the previous page, 0 for the first page) controls paging.

Default Cloud9QL:

select expand(data.videos);

Video Query (by ID)

Retrieves metrics and metadata for specific videos by their IDs (up to 20). Get the IDs from the Video List report.

Parameters:

  • Fields (required) ? Same field options as Video List.
  • Request Body (JSON) (required) ? A filters.video_ids array of TikTok video IDs.

Default Cloud9QL:

select expand(data.videos);

Scopes

The connector requests the following Display API scopes: user.info.basic, user.info.profile, user.info.stats, and video.list. Stat fields require user.info.stats; profile fields require user.info.profile; video reports require video.list.

Notes

  • The Display API exposes your own profile and public videos. Aggregate per-day analytics (impressions over time, audience demographics) are part of TikTok's separate Business/Research APIs and are not covered by this connector.
  • TikTok caps the Video List page size at 20 videos per request; Knowi can page through additional videos using the returned cursor.