Office collaboration

Use cases

• Archive structured data: Your team maintains data such as attendance records, registrations, or inventory lists in Feishu online spreadsheets and needs to archive this data to MaxCompute for offline correlation analysis.

• Share query results: You need to publish calculation results from MaxCompute as a Feishu online spreadsheet and share it via a link with collaborators who do not have MaxCompute permissions.

• Process unstructured documents: You need to import office files, such as PDF, DOC, or PPT files, from Feishu Drive into MaxCompute for batch processing tasks like text extraction, optical character recognition (OCR), or translation.

Feature index

1. Create a custom Feishu application

1. Go to the Feishu Developer Console, and click Create Custom App.

2. Enter an application name and description.

3. On the credentials and basic information page, get the App ID and App Secret.

2. Enable permissions

On the permission management page in the Feishu Developer Console, enable the following permissions:

3. Release the application

On the version management and release page in the Feishu Developer Console, release the application. For personal editions of Feishu, changes to an application are released automatically.

4. Permission scope

The application can only access the following documents:

• Documents the application creates.

• Documents shared directly with the application.

• Wiki spaces where the application is a collaborator.

To access more documents, add the application as a collaborator to the target documents or Wiki spaces in Feishu.

Connect to the data source

1. In the sidebar, click the Office Collaboration icon to open the collaboration panel.

2. Click the Feishu connector to enter the Feishu feature area.

3. Click Authorize with Lark. If you see an "App ID/App Secret not configured" message, go to the Settings page and enter the App ID and App Secret for your Feishu application.

4. The Feishu authorization page opens in your browser. Confirm the authorization to return to the client.

5. After successful authorization, the panel displays the current Feishu username and switches to the document browser.

Permission diagnosis

After a successful connection, a permission diagnosis runs automatically to check the following items in sequence:

• Token retrieval: Checks if the access token can be obtained.

• Wiki: Checks if the list of Wiki spaces is accessible.

• Feishu Drive files: Checks if files in Feishu Drive are accessible.

• Document search: Checks if the search API is available.

If all checks pass, the document browser opens. If a check fails, verify that you have enabled the corresponding permission in the Feishu Developer Console.

Disconnect

In the Feishu feature area, click Disconnect to clear the local authorization credentials. After you disconnect, you must authorize again to use the Feishu features.

File import

This mode is suitable for online documents and files in Feishu Drive. It imports the document content into a MaxCompute table for text processing.

1. In the document browser, select the documents that you want to import.

2. A count of the selected items appears at the top. Click Configure Sync.

3. Enter a task name and a table name prefix. The default prefix is feishu_.

4. Click Start Sync.

Table import

This mode is suitable for online spreadsheets and Bitable. It imports tabular data into a MaxCompute table, preserving column names and data types.

1. In the document browser, select the target tables.

2. Switch to Table Import mode.

3. Preview the table schema and sample data.

4. After you confirm the column mapping, click Start Sync.

Sync tasks

Synchronization tasks run asynchronously. After creating a task, you can view its progress in the task list. When the task completes, the data is written to a MaxCompute table, where it can be queried by using SQL.