Queries a list of files.
Try it now
Test
RAM authorization
Request parameters
|
Parameter |
Type |
Required |
Description |
Example |
| FileFolderPath |
string |
No |
The path to the folder where the file is located. |
Business_process/my_first_business_process/MaxCompute/ods_layer |
| ProjectId |
integer |
No |
The DataWorks workspace ID. You can log on to the DataWorks console and go to the Workspace page to obtain the ID. You must configure either this parameter or the ProjectIdentifier parameter to determine the DataWorks workspace to which the operation is applied. |
10000 |
| Keyword |
string |
No |
The keyword for the file name. Fuzzy match is supported. You can enter a keyword to query all files that contain the keyword. |
ods |
| ProjectIdentifier |
string |
No |
The DataWorks workspace name. To obtain the workspace name, log on to the DataWorks console and navigate to the workspace configuration page. You must specify either this parameter or ProjectId to identify the target DataWorks workspace for this API call. |
dw_project |
| PageNumber |
integer |
No |
The page number for pagination. |
1 |
| PageSize |
integer |
No |
The number of entries per page. Default value: 10. Maximum value: 100. |
10 |
| UseType |
string |
No |
The functional module to which the file belongs. Valid values:
|
NORMAL |
| FileTypes |
string |
No |
The code type of the file. The code type of the file. Common code types and their corresponding file types include: 6 (Shell), 10 (ODPS SQL), 11 (ODPS MR), 23 (Data Integration), 24 (ODPS Script), 97 (PAI), 98 (Combined node), 99 (Virtual node), 221 (PyODPS 2), 225 (ODPS Spark), 227 (EMR Hive), 228 (EMR Spark), 229 (EMR Spark SQL), 230 (EMR MR), 239 (OSS object inspection), 257 (EMR Shell), 258 (EMR Spark Shell), 259 (EMR Presto), 260 (EMR Impala), 900 (Real-time sync), 1002 (PAI internal node), 1089 (Cross-tenant node), 1091 (Hologres development), 1093 (Hologres SQL), 1100 (Assignment node), 1106 (ForEach node), 1221 (PyODPS 3). |
10,23 |
| Owner |
string |
No |
The ID of the file owner. |
3726346**** |
| NodeId |
integer |
No |
The ID of the scheduling node. You can call the ListNodes operation to obtain the node ID. |
123541234 |
| NeedContent |
boolean |
No |
Specifies whether the query result includes the file content. For files with large content, network transmission delays may occur. |
false |
| NeedAbsoluteFolderPath |
boolean |
No |
Specifies whether the query result includes the path to the folder where the file is located. |
false |
| ExactFileName |
string |
No |
The exact file name. The file name in the query result must exactly match this parameter. |
ods_create.sql |
| FileIdIn |
string |
No |
The list of file IDs. The file IDs in the query result must be a subset of this list. You can specify up to 50 file IDs at a time. |
78237,816123 |
| LastEditUser |
string |
No |
The Alibaba Cloud account ID of the user who last updated the file. |
11233*** |
| CommitStatus |
integer |
No |
The current commit status of the file. Valid values: 0 (the latest code is not committed) and 1 (the latest code is committed). |
1 |
Response elements
|
Element |
Type |
Description |
Example |
|
object |
The response. |
||
| HttpStatusCode |
integer |
The HTTP status code. |
200 |
| ErrorMessage |
string |
The error message. |
The connection does not exist. |
| RequestId |
string |
The request ID. Use this ID to troubleshoot issues. |
0000-ABCD-**** |
| ErrorCode |
string |
The error code. |
Invalid.Tenant.ConnectionNotExists |
| Success |
boolean |
Indicates whether the call succeeded. Valid values:
|
true |
| Data |
object |
The response details. |
|
| PageNumber |
integer |
The page number. |
1 |
| PageSize |
integer |
The number of entries per page. |
10 |
| TotalCount |
integer |
The total number of entries returned. |
13 |
| Files |
array<object> |
The file details. |
|
|
object |
The file information. |
||
| CommitStatus |
integer |
The current commit status of the file. Valid values: 0 (the latest code is not committed) and 1 (the latest code is committed). |
1 |
| AutoParsing |
boolean |
Specifies whether automatic parsing is enabled for the file. Valid values:
This parameter corresponds to Analyze Code when you set Dependencies to Same Cycle in the scheduling configuration of a Data Studio task in the DataWorks console. |
true |
| Owner |
string |
The Alibaba Cloud account ID of the file owner. |
3872572**** |
| CreateTime |
integer |
The timestamp (in milliseconds) when the file was created. |
1593950832000 |
| FileType |
integer |
The file type. Different file types have different code. For more information, see DataWorks node types. |
10 |
| CurrentVersion |
integer |
The latest version of the file. |
2 |
| BizId |
integer |
The ID of the workflow to which the file belongs. This parameter is deprecated. Use the BusinessId parameter instead. |
300000 |
| LastEditUser |
string |
The Alibaba Cloud account ID of the user who last updated the file. |
382762**** |
| FileName |
string |
The file name. |
ods_user_info_d |
| ConnectionName |
string |
The data source name used by the task. |
odps_source |
| UseType |
string |
The functional module to which the file belongs. Valid values:
|
NORMAL |
| FileFolderId |
string |
The ID of the folder where the file is located. |
2735c2**** |
| FileId |
integer |
The file ID. |
10000001 |
| ParentId |
integer |
If the current file is an internal file of a combined node, this parameter specifies the ID of the corresponding combined node file. |
-1 |
| CreateUser |
string |
The Alibaba Cloud account ID of the file creator. |
382762**** |
| IsMaxCompute |
boolean |
If the current file is a MaxCompute resource file, this parameter specifies whether the resource file needs to be uploaded to MaxCompute. You only need to configure this parameter when the file is a MaxCompute resource file. |
false |
| BusinessId |
integer |
The ID of the workflow to which the file belongs. |
300000 |
| FileDescription |
string |
The description of the file. |
my test datastudio file |
| LastEditTime |
integer |
The timestamp (in milliseconds) when the file was last modified. |
1593950832000 |
| Content |
string |
This parameter is deprecated. You can call the GetFile operation to query this information. |
SHOW TABLES; |
| NodeId |
integer |
The ID of the scheduling task generated in the scheduling system after the file is committed. |
300001 |
| AbsoluteFolderPath |
string |
The path to the folder where the file is located. |
Business_process/my_first_business_process/MaxCompute/ods_layer |
Examples
Success response
JSON format
{
"HttpStatusCode": 200,
"ErrorMessage": "The connection does not exist.",
"RequestId": "0000-ABCD-****",
"ErrorCode": "Invalid.Tenant.ConnectionNotExists",
"Success": true,
"Data": {
"PageNumber": 1,
"PageSize": 10,
"TotalCount": 13,
"Files": [
{
"CommitStatus": 1,
"AutoParsing": true,
"Owner": "3872572****",
"CreateTime": 1593950832000,
"FileType": 10,
"CurrentVersion": 2,
"BizId": 300000,
"LastEditUser": "382762****",
"FileName": "ods_user_info_d",
"ConnectionName": "odps_source",
"UseType": "NORMAL",
"FileFolderId": "2735c2****",
"FileId": 10000001,
"ParentId": -1,
"CreateUser": "382762****",
"IsMaxCompute": false,
"BusinessId": 300000,
"FileDescription": "my test datastudio file",
"LastEditTime": 1593950832000,
"Content": "SHOW TABLES;",
"NodeId": 300001,
"AbsoluteFolderPath": "Business_process/my_first_business_process/MaxCompute/ods_layer"
}
]
}
}
Error codes
|
HTTP status code |
Error code |
Error message |
Description |
|---|---|---|---|
| 500 | InternalError.System | An internal system error occurred. Try again later. | |
| 500 | InternalError.UserId.Missing | An internal system error occurred. Try again later. | |
| 403 | Forbidden.Access | Access is forbidden. Please first activate DataWorks Enterprise Edition or Flagship Edition. | No permission, please authorize |
| 429 | Throttling.Api | The request for this resource has exceeded your available limit. | |
| 429 | Throttling.System | The DataWorks system is busy. Try again later. | |
| 429 | Throttling.User | Your request is too frequent. Try again later. |
See Error Codes for a complete list.
Release notes
See Release Notes for a complete list.