ExportInventoryAsset
Exports the full list of table assets under an inventory task as an XLSX file.
Operation description
Exports all inventory table assets based on the same filter conditions as SearchInventoryAsset. The server generates an XLSX file, uploads it to OSS, and returns a pre-signed download URL that is valid for 1 hour. No Size/Offset pagination parameters are required. A maximum of 50,000 records can be exported in a single request.
Try it now
Test
RAM authorization
Request syntax
POST / HTTP/1.1
Request parameters
|
Parameter |
Type |
Required |
Description |
Example |
| JobId |
integer |
Yes |
The ID of the inventory task. |
1001 |
| Query |
string |
No |
The search keyword used for fuzzy matching of asset information such as table names. |
order |
| SortBy |
string |
No |
The field by which to sort the results. Valid values:
Default value: confidence. |
confidence |
| SortOrder |
string |
No |
The sort order. Valid values:
Default value: desc. |
desc |
Response elements
|
Element |
Type |
Description |
Example |
|
object |
The response body. |
||
| RequestId |
string |
Id of the request |
0C1CB646-1DE4-4AD0-B4A4-7D47DD52E931 |
| ErrorCode |
string |
The error code. |
UnknownError |
| ErrorMessage |
string |
The error message. |
UnknownError |
| Success |
boolean |
Indicates whether the request was successful. Valid values:
|
true |
| Data |
object |
The paginated result of the inventory task list. |
|
| DownloadUrl |
string |
The temporary download URL for the XLSX file (an OSS pre-signed URL). |
https://cas-documents-service.oss-cn-shanghai.aliyuncs.com/Batch_Upload_Monitor_Domain.xlsx?Expires=1756865597&OSSAccessKeyId=LTAIuSosQIEgsbko&Signature=PbiIBNqP9jIBScrwQQFbgFPwNF4%3D |
| FileName |
string |
The suggested file name for saving the file. |
insert.sql |
| ExpireTime |
integer |
The expiration time of the download URL (UNIX timestamp in milliseconds). |
1766718830 |
| TotalCount |
integer |
The total number of exported records. |
10 |
Examples
Success response
JSON format
{
"RequestId": "0C1CB646-1DE4-4AD0-B4A4-7D47DD52E931",
"ErrorCode": "UnknownError",
"ErrorMessage": "UnknownError",
"Success": true,
"Data": {
"DownloadUrl": "https://cas-documents-service.oss-cn-shanghai.aliyuncs.com/Batch_Upload_Monitor_Domain.xlsx?Expires=1756865597&OSSAccessKeyId=LTAIuSosQIEgsbko&Signature=PbiIBNqP9jIBScrwQQFbgFPwNF4%3D",
"FileName": "insert.sql",
"ExpireTime": 1766718830,
"TotalCount": 10
}
}
Error codes
See Error Codes for a complete list.
Release notes
See Release Notes for a complete list.