Azure / Azure/LogicAppsUX

SFTP - SSH Connector Trigger not populating when you click the "Open Folder" icon

Open
#7,527 0 comments 0 reactions 0 assignees View on GitHub
Dynamic Data
Dominant language
TypeScript
Stars
111
Forks
109
Avg merge
1d 23h
Merged PRs (30d)
20

Description

### Severity

P3 - Medium (Minor functionality affected)

### Describe the Bug with repro steps

When you add a SFTP - SSH Connector Trigger, and then click the "Open Folder" icon, it shows SFTPWithSsh to represent the root folder as usual, but when you then click > icon (navigate to), it should populate with a list of folders at root, but it says "No items". When I go to action of SFTP-SSH it works as expected. It's just triggers that aren't working.

### What type of Logic App Is this happening in?

Consumption (Portal)

### Are you experiencing a regression?

_No response_

### Which operating system are you using?

Windows

### Did you refer to the TSG before filing this issue? https://aka.ms/lauxtsg

Yes

### Workflow JSON

```json
{
"definition": {
"$schema": "https://schema.management.azure.com/providers/Microsoft.Logic/schemas/2016-06-01/workflowdefinition.json#",
"contentVersion": "1.0.0.0",
"triggers": {
"When_files_are_added_or_modified_(properties_only)": {
"type": "ApiConnection",
"inputs": {
"host": {
"connection": {
"name": "@parameters('$connections')['sftpwithssh-1']['connectionId']"
}
},
"method": "get",
"path": "/datasets/default/triggers/batch/onupdatedfile",
"queries": {
"folderId": "",
"maxFileCount": 10,
"checkBothCreatedAndModifiedDateTime": false
}
},
"recurrence": {
"interval": 3,
"frequency": "Minute"
},
"splitOn": "@triggerBody()"
}
},
"actions": {
"Exception": {
"type": "ApiConnection",
"inputs": {
"host": {
"connection": {
"name": "@parameters('$connections')['office365']['connectionId']"
}
},
"method": "post",
"body": {
"To": "@parameters('emailTo')",
"Subject": "Exception occurred in MyRG Inbound @{parameters('customerName')} for file : @{base64ToString(triggerOutputs()['headers']['x-ms-file-name-encoded'])}",
"Body": "

Error At : @{last(body('Filter_Error_Messages'))?['name']}
\n
\nRun : @{workflow().run.name}
\n
\n@{if(equals(first(string(coalesce(last(body('Filter_Error_Messages'))?['outputs']?['body'],'{}'))),'{'),coalesce(last(body('Filter_Error_Messages'))?['outputs']?['body']?['error']?['message'],last(body('Filter_Error_Messages'))?['outputs']?['body']?['errorMessage'],last(body('Filter_Error_Messages'))?['error']?['message'],last(body('Filter_Error_Messages'))?['outputs']?['body'],last(body('Filter_Error_Messages'))?['error']),last(body('Filter_Error_Messages'))?['outputs']?['body'])}

",
"Importance": "High"
},
"path": "/v2/Mail"
},
"runAfter": {
"Filter_Error_Messages": [
"Succeeded"
]
}
},
"Filter_Error_Messages": {
"type": "Query",
"inputs": {
"from": "@result('Scope')",
"where": "@equals(item()['status'], 'Failed')"
},
"runAfter": {
"Scope": [
"Failed"
]
}
},
"Scope": {
"type": "Scope",
"actions": {
"ConvertEncoding": {
"type": "Function",
"inputs": {
"body": {
"text": "@{base64(triggerBody())}"
},
"function": {
"id": "/subscriptions/*****/resourceGroups/MyRG/providers/Microsoft.Web/sites/MyRGFunctions/functions/ConvertEncoding"
}
},
"runAfter": {
"Create_SPO": [
"Succeeded"
]
}
},
"Create_SPO": {
"type": "ApiConnection",
"inputs": {
"host": {
"connection": {
"name": "@parameters('$connections')['sharepointonline']['connectionId']"
}
},
"method": "post",
"path": "/datasets/@{encodeURIComponent(encodeURIComponent('https://legacyhld.sharepoint.com/sites/MyRG'))}/files",
"queries": {
"folderPath": "/Shared Documents/WMG/Received",
"name": "@base64ToString(triggerOutputs()['headers']['x-ms-file-name-encoded'])",
"queryParametersSingleEncoded": true
}
}
},
"Rename_File": {
"type": "ApiConnection",
"inputs": {
"host": {
"connection": {
"name": "@parameters('$connections')['sftpwithssh']['connectionId']"
}
},
"method": "post",
"headers": {
"ReadFileMetadataFromServer": false
},
"path": "/datasets/default/files/@{encodeURIComponent(encodeURIComponent(''))}/rename",
"queries": {
"newName": "Done/@{base64ToString(triggerOutputs()['headers']['x-ms-file-name-encoded'])}"
}
},
"runAfter": {
"Switch_on_Filename_Prefix": [
"Succeeded"
]
}
},
"Switch_on_Filename_Prefix": {
"type": "Switch",
"expression": "@first(split(base64ToString(triggerOutputs()['headers']['x-ms-file-name-encoded']),'_'))",
"default": {
"actions": {}
},
"cases": {
"Case_PO": {
"actions": {
"Delay_PO": {
"type": "Wait",
"inputs": {
"interval": {
"count": 1,
"unit": "Hour"
}
}
},
"GroupDetail_PO": {
"type": "Function",
"inputs": {
"body": "@base64ToString(body('ConvertEncoding')['text'])",
"function": {
"id": "/subscriptions/*****/resourceGroups/MyRG/providers/Microsoft.Web/sites/MyRGFunctions/functions/GroupDetail"
}
},
"runAfter": {
"Delay_PO": [
"Succeeded"
]
}
},
"Inbound_Transform_PO": {
"type": "Workflow",
"inputs": {
"host": {
"workflow": {
"id": "/subscriptions/*****/resourceGroups/MyRG/providers/Microsoft.Logic/workflows/Inbound_Transform"
},
"triggerName": "manual"
},
"body": {
"CustomerCode": "@parameters('customerCode')",
"CustomerName": "@parameters('customerName')",
"Data": "@{body('GroupDetail_PO')}",
"EmailTo": "@parameters('emailTo')",
"Extension": "rcxml",
"Filename": "@base64ToString(triggerOutputs()['headers']['x-ms-file-name-encoded'])",
"Process": "Receipt"
}
},
"runAfter": {
"GroupDetail_PO": [
"Succeeded"
]
}
}
},
"case": "PO"
},
"Case_Product_Master": {
"actions": {
"Create_TMP_File": {
"type": "ApiConnection",
"inputs": {
"host": {
"connection": {
"name": "@parameters('$connections')['sftpwithssh']['connectionId']"
}
},
"method": "post",
"body": "@body('ConvertEncoding')['text']",
"headers": {
"ReadFileMetadataFromServer": false
},
"path": "/datasets/default/files",
"queries": {
"folderPath": "/inbound/Converted/tmp",
"name": "@base64ToString(triggerOutputs()['headers']['x-ms-file-name-encoded'])",
"queryParametersSingleEncoded": true
}
},
"runtimeConfiguration": {
"contentTransfer": {
"transferMode": "Chunked"
}
}
},
"Inbound_Transform_Item_Master": {
"type": "Workflow",
"inputs": {
"host": {
"workflow": {
"id": "/subscriptions/*****/resourceGroups/MyRG/providers/Microsoft.Logic/workflows/Inbound_Transform"
},
"triggerName": "manual"
},
"body": {
"CustomerCode": "@parameters('customerCode')",
"CustomerName": "@parameters('customerName')",
"Data": "@{base64ToString(body('ConvertEncoding')['text'])}",
"EmailTo": "@parameters('emailTo')",
"Extension": "imxml",
"Filename": "@base64ToString(triggerOutputs()['headers']['x-ms-file-name-encoded'])",
"Process": "ItemMaster"
}
},
"runAfter": {
"Rename_TMP_File": [
"Succeeded"
]
}
},
"Rename_TMP_File": {
"type": "ApiConnection",
"inputs": {
"host": {
"connection": {
"name": "@parameters('$connections')['sftpwithssh']['connectionId']"
}
},
"method": "post",
"headers": {
"ReadFileMetadataFromServer": false
},
"path": "/datasets/default/files/@{encodeURIComponent(encodeURIComponent(body('Create_TMP_File')?['Path']))}/rename",
"queries": {
"newName": "../@{base64ToString(triggerOutputs()['headers']['x-ms-file-name-encoded'])}"
}
},
"runAfter": {
"Create_TMP_File": [
"Succeeded"
]
}
}
},
"case": "PROD"
},
"Case_Sales_Order": {
"actions": {
"Create_Temp_File": {
"type": "ApiConnection",
"inputs": {
"host": {
"connection": {
"name": "@parameters('$connections')['sftpwithssh']['connectionId']"
}
},
"method": "post",
"body": "@base64ToString(body('ConvertEncoding')['text'])",
"headers": {
"ReadFileMetadataFromServer": false
},
"path": "/datasets/default/files",
"queries": {
"folderPath": "/inbound/Converted/tmp",
"name": "@base64ToString(triggerOutputs()['headers']['x-ms-file-name-encoded'])",
"queryParametersSingleEncoded": true
}
},
"runtimeConfiguration": {
"contentTransfer": {
"transferMode": "Chunked"
}
}
},
"Rename_Temp_File": {
"type": "ApiConnection",
"inputs": {
"host": {
"connection": {
"name": "@parameters('$connections')['sftpwithssh']['connectionId']"
}
},
"method": "post",
"headers": {
"ReadFileMetadataFromServer": false
},
"path": "/datasets/default/files/@{encodeURIComponent(encodeURIComponent(body('Create_Temp_File')?['Path']))}/rename",
"queries": {
"newName": "../@{base64ToString(triggerOutputs()['headers']['x-ms-file-name-encoded'])}"
}
},
"runAfter": {
"Create_Temp_File": [
"Succeeded"
]
}
}
},
"case": "SO"
},
"Case_Sales_Order_-_Future": {
"actions": {
"Inbound_Transform_Ship_Order": {
"type": "Workflow",
"inputs": {
"host": {
"workflow": {
"id": "/subscriptions/*****/resourceGroups/MyRG/providers/Microsoft.Logic/workflows/Inbound_Transform"
},
"triggerName": "manual"
},
"body": {
"CustomerCode": "@parameters('customerCode')",
"CustomerName": "@parameters('customerName')",
"Data": "@{base64ToString(body('ConvertEncoding')['text'])}",
"EmailTo": "@parameters('emailTo')",
"Extension": "shxml",
"Filename": "@base64ToString(triggerOutputs()['headers']['x-ms-file-name-encoded'])",
"Process": "ShipOrder"
}
}
}
},
"case": "XSO"
}
},
"runAfter": {
"ConvertEncoding": [
"Succeeded"
]
}
}
},
"runAfter": {}
}
},
"outputs": {},
"parameters": {
"customerCode": {
"defaultValue": "WMG",
"type": "String"
},
"customerName": {
"defaultValue": "WMG",
"type": "String"
},
"emailTo": {
"defaultValue": "MyRGAlerts@legacyscs.com",
"type": "String"
},
"$connections": {
"type": "Object",
"defaultValue": {}
}
}
},
"parameters": {
"$connections": {
"type": "Object",
"value": {
"office365": {
"id": "/subscriptions/*****/providers/Microsoft.Web/locations/eastus/managedApis/office365",
"connectionId": "/subscriptions/*****/resourceGroups/MyRG/providers/Microsoft.Web/connections/office365",
"connectionName": "office365"
},
"sharepointonline": {
"id": "/subscriptions/*****/providers/Microsoft.Web/locations/eastus/managedApis/sharepointonline",
"connectionId": "/subscriptions/*****/resourceGroups/MyRG/providers/Microsoft.Web/connections/sharepointonline",
"connectionName": "sharepointonline"
},
"sftpwithssh": {
"id": "/subscriptions/*****/providers/Microsoft.Web/locations/eastus/managedApis/sftpwithssh",
"connectionId": "/subscriptions/*****/resourceGroups/MyRG/providers/Microsoft.Web/connections/sftpwithssh-1",
"connectionName": "sftpwithssh-1"
},
"sftpwithssh-1": {
"id": "/subscriptions/*****/providers/Microsoft.Web/locations/eastus/managedApis/sftpwithssh",
"connectionId": "/subscriptions/*****/resourceGroups/MyRG/providers/Microsoft.Web/connections/sftpwithssh-10",
"connectionName": "sftpwithssh-10"
}
}
}
}
}
```

### Screenshots or Videos

_No response_

### Environment

Microsoft Edge for Business
Version 137.0.3296.68 (Official build) (64-bit)

### Additional context

_No response_

Contributor guide

No contributing guide indexed for this repository

Assessment

This issue has not been assessed yet.

Get new issues in your inbox

A short digest of beginner-friendly GitHub issues.