Power Platform Community Forum Thread Details

Hello,

I'm trying to create a custom connector for our API and I'm facing a problem.

Here are some pieces of my OpenAPI file :

the trigger definition :

    "/api/application/subscribe/16": {
      "x-ms-notification-content": {
        "schema": {
          "type": "object",
          "properties": {
            "EventName": {
              "type": "string",
              "description": "EventName"
            },
            "RowStatusName": {
              "type": "string",
              "description": "RowStatusName"
            },
            "Row": { "$ref": "#/definitions/Row" },
            "Cell": {
              "type": "object",
              "properties": {
                "columnId": {
                  "type": "string",
                  "description": "columnId"
                },
                "oldValue": {
                  "type": "string",
                  "description": "oldValue"
                },
                "newValue": {
                  "type": "string",
                  "description": "newValue"
                }
              },
              "description": "Cell"
            }
          }
        },
        "description": "Updated row"
      },
      "post": {
        "consumes": [
          "application/json"
        ],        
        "responses": {
          "200": {
            "description": "default",
            "schema": {
              "type": "object",
              "properties": {
                "subscriptionId": {
                  "type": "string",
                  "description": "Id",
                  "title": "",
                  "x-ms-visibility": "internal"
                }
              }
            }
          }
        },
        "x-ms-visibility": "important",
        "x-ms-trigger": "single",
        "summary": "Column Changed",
        "description": "Triggers when a value has changed in a specific column.",
        "operationId": "ColumnChanged",
        "parameters": [
          {
            "name": "body",
            "in": "body",
            "required": false,
            "schema": {
              "type": "object",
              "properties": {
                "TargetUrl": {
                  "type": "string",
                  "description": "TargetUrl",
                  "x-ms-visibility": "internal",
                  "x-ms-notification-url": true,
                  "title": "Target URL"
                },
                "ListId": {"$ref": "#/definitions/TableId"},
                "ColumnId": {
                  "type": "string",
                  "description": "Choose a column",
                  "title": "Column",
                  "x-ms-visibility": "important",
                  "x-ms-dynamic-list": {
                    "operationId": "LoadListColumns",
                    "itemValuePath": "Id",
                    "itemTitlePath": "DisplayName",
                    "parameters": {
                      "listId": {
                        "parameterReference": "body/ListId"
                      }
                    }
                  }
                },
                "EventType": {
                  "type": "integer",
                  "format": "int32",
                  "description": "EventType",
                  "title": "",
                  "x-ms-visibility": "internal",
                  "default": 16
                },
                "ApplicationId": {
                  "type": "string",
                  "description": "ApplicationId",
                  "title": "",
                  "x-ms-visibility": "internal",
                  "default": "423c6b2d524a4c4a97c58c0952d30160"
                }
              },
              "x-ms-visibility": "important",
              "required": [
                "TargetUrl",
                "EventType",
                "ApplicationId",
                "ColumnId",
                "ListId"
              ]
            },
            "x-ms-visibility": "important"
          }
        ]
      }
    },

in the "definitions" section :

  "definitions": {
    "TableId": {
      "type": "string",
      "description": "Choose a table",
      "title": "Table",
      "x-ms-visibility": "important",
      "x-ms-dynamic-list": {
        "operationId": "LoadOwnedList",
        "itemValuePath": "Id",
        "itemTitlePath": "Name"
      }
    },
    "Row": {
      "type": "object",
      "properties": {
        "Id": {
          "type": "string",
          "title": "Id",
          "description": "Id"
        },
        "ListId": {
          "type": "string",
          "title": "ListId",
          "description": "ListId",
          "x-ms-visibility": "internal"
        },
        "Index": {
          "type": "integer",
          "format": "int32",
          "title": "Index",
          "description": "Index"
        },
        "CanUpdate": {
          "type": "boolean",
          "title": "CanUpdate",
          "description": "CanUpdate"
        },
        "CanSuppress": {
          "type": "boolean",
          "title": "CanSuppress",
          "description": "CanSuppress"
        },
        "CanAssign": {
          "type": "boolean",
          "title": "CanAssign",
          "description": "CanAssign"
        },
        "CreatedDateUtc": {
          "type": "string",
          "title": "CreatedDateUtc",
          "description": "CreatedDateUtc"
        },
        "ModifiedDateUtc": {
          "type": "string",
          "title": "ModifiedDateUtc",
          "description": "ModifiedDateUtc"
        },
        "ModifiedByNickName": {
          "type": "string",
          "title": "ModifiedByNickName",
          "description": "ModifiedByNickName"
        },
        "ModifiedByEmail": {
          "type": "string",
          "title": "ModifiedByEmail",
          "description": "ModifiedByEmail"
        },
        "CreatedByNickName": {
          "type": "string",
          "title": "CreatedByNickName",
          "description": "CreatedByNickName"
        },
        "CreatedByEmail": {
          "type": "string",
          "title": "CreatedByEmail",
          "description": "CreatedByEmail"
        },
        "Owner": {
          "type": "object",
          "properties": {
            "BackgroundColorIndex": {
              "type": "integer",
              "format": "int32",
              "title": "BackgroundColorIndex",
              "description": "BackgroundColorIndex"
            },
            "Bigram": {
              "type": "string",
              "title": "Bigram",
              "description": "Bigram"
            },
            "Name": {
              "type": "string",
              "title": "Name",
              "description": "Name"
            },
            "Email": {
              "type": "string",
              "title": "Email",
              "description": "Email"
            },
            "Type": {
              "type": "integer",
              "format": "int32",
              "title": "Type",
              "description": "Type"
            },
            "DisplayName": {
              "type": "string",
              "title": "DisplayName",
              "description": "DisplayName"
            }
          },
          "title": "Owner",
          "description": "Owner"
        },
        "OwnerManagerEmail": {
          "type": "string",
          "description": "OwnerManagerEmail"
        },
        "OwnerManagerName": {
          "type": "string",
          "description": "OwnerManagerName"
        },
        "Status": {
          "type": "integer",
          "format": "int32",
          "title": "Status",
          "description": "Row Status : 1: Active, 2: Deleted, 8: Archived, 9: Locked"
        },
        "StatusDateUtc": {
          "type": "string",
          "title": "StatusDateUtc",
          "description": "StatusDateUtc"
        },
        "StatusChangeByUserName": {
          "type": "string",
          "title": "StatusChangeByUserName",
          "description": "StatusChangeByUserName"
        },
        "Values": {
          "type": "object",
          "x-ms-dynamic-properties": {
            "operationId": "GetRowValuesSchema",
            "parameters": {
              "listId": {
                "parameterReference": <Is there a way to reference the ListId selected in dynamic values of the ColumnChanged operation ?>
              }
            }
          }
        }
      },
      "title": "Row",
      "description": "Row"
    }    
  },

I'd like to be able to select a ListId in the trigger and then use the selected Id in my other operations as, for example, a parameter for a dynamic property operation.

Thanks for your help.

Categories:

Connector development