Add Info Definitions

Add the details for your adapter in the info section.

In VS Code, click Explorer on the sidebar.
The directory structure of your workspace folder is displayed.
Within the definitions directory listing, click the adapter definition document that you want to work on.
The document is displayed in the VS Code editor.
Expand the info section in the document.
Add the basic information for your adapter, such as the ID, display name, description, version, and publisher information.
Specify the functional capabilities and security settings for your adapter in the settings object.
For more information about each field in the info section, see Info Properties and Sample Code

The following topics provide the procedure to make some common updates to the settings properties:

Restrict Outbound Invocations to Specific Domains

An adapter developer can restrict outbound invocations only to allow-listed domains in order to establish trust with the integration developers who'll use the adapter.

After the developer specifies the allow-listed domains in the adapter definition document, the Rapid Adapter Builder enforces the list to all the outbound invocations, like design-time, runtime, OAuth policies, and so on.

While specifying the domains, ensure that the domains conform to any of the following patterns:

.<secondLevelDomain>.<topLevelDomain>,
.<topLevelDomain>,
Any sub-resource of .<secondLevelDomain>.<topLevelDomain> (eg: *.a.b.c, a.b.c),
Valid IP,
Valid IP+Port

Note:

The Rapid Adapter Builder supports only the wildcard (*) character in the domain name.
You can specify a maximum of ten domains.
A generic domain value like * , *.com lowers the security score of the adapter.

In VS Code, click Explorer on the sidebar.
The directory structure of your workspace folder is displayed.
Within the definitions directory listing, click the adapter definition document that you want to work on.
The document is displayed in the VS Code editor.
Expand the info section in the document, and scroll to the settings object.
Update the allowedDomains property by adding the list of allowed domains as a JSON array, and press Ctrl+S to save the document.

Here is an example scenario to understand allowed domains better.

If you are developing an adapter for an application, for example, myDemoApp, the adapter will access the following:

The application's APIs hosted on the domain, https://myDemoApp.com
The API URLs, like https://auth.myDemoApp.com/v1/token, or https://identity.myDemoApp.com/v1/users, and so on

Now, if you want to restrict access only to the myDemoApp APIs from the adapter, you can set the allowedDomains property.

Sample Code:

"info": {
  "settings": {
  ...
      "allowedDomains" : ["*.myDemoApp.com"]
}

Allow Non-HTTPS Traffic

By default, the adapters built using the Rapid Adapter Builder allow HTTPS-only outbound calls from the design-time or runtime environments, and according to the defined security policies.

To test an adapter in the development environment, the adapter must also handle HTTP (non-HTTPS) traffic.

In VS Code, click Explorer on the sidebar.
The directory structure of your workspace folder is displayed.
Within the definitions directory listing, click the adapter definition document that you want to work on.
The document is displayed in the VS Code editor.
Expand the info section in the document, and scroll to the settings object.
Set the allowNonSSL property to true.
Press Ctrl+S to save the document.

Debug Integration Flows in Designtime

While configuring an adapter (built using the Rapid Adapter Builder) in an integration flow, you may have a configuration field or operation that requires execution of an additional flow to fetch data from external applications.

In the Oracle Integration designtime user interface (integration canvas), you can monitor and debug the execution of such background flows, with the help of browser tools. You can view the milestone information during the execution of a background flow and use this information to debug errors, if any. The information you see in designtime is consistent with the information that is presented at run time.

Note:

You can view the execution logs of background flows in designtime only while configuring adapters that are built using the Rapid Adapter Builder.

While configuring your adapter, if a UI event occurs, an event call is issued to the backend. The Rapid Adapter Builder designtime framework executes the page logic. If the configuration field of the adapter requires the execution of a background flow, the flow execution engine reads the adapter registry to check if the debug flag is turned on for the adapter. If the flag is turned on, the tracing is executed for the background flow, and the milestone information is appended in the response to the web client. You can monitor this milestone information using browser tools.

An overview of designtime debugging.

Configure Designtime Debugging

To view the execution logs of background flows in Oracle Integration designtime, you must turn on the _debug flag in the adapter definition document of the respective adapter.

In VS Code, click Explorer on the sidebar.
The directory structure of your workspace folder is displayed.
Within the definitions directory listing, click the adapter definition document that you want to work on.
The document is displayed in the VS Code editor.
Expand the info section in the document, and scroll to the settings object.
Set the _debug flag to true.
Press Ctrl+S to save the document.

View the Execution Logs in Designtime

While configuring the adapter's fields or operations in the integration canvas of Oracle Integration, open the developer tools in your browser. For example, in Google Chrome, click the vertical ellipsis, then More tools, and then Developer tools.

In the developer tools window:

With the Network tab selected, click the required request on the left.
View and debug the milestone information on the Response tab.
The milestone log information is shown as the last node of the JSON response.

Sample Response

Here's an example response resulting from the execution of a background flow, while configuring an adapter built using the Rapid Adapter Builder.

{
  "metaData": {
    "viewMode": false,
    "pages": [
      {
        "pageId": "welcome",
        "pageName": "Basic Info",
        "pageTitle": "Welcome to the Cloud Endpoint Configuration Wizard",
        "welcomeText": "This wizard helps you create a service using Metadata. \nYou will be asked to specify configuration parameters and define an action for the service.",
        "helpId": "HelpId",
        "disabled": false
      },
      {
        "pageId": "configuration",
        "pageName": "Configuration",
        "pageTitle": "Configuration",
        "welcomeText": "Configuration",
        "helpId": "GUID-139B596F-500D-4F59-9F1E-6B432AC0BE4D",
        "disabled": false
      },
      {
        "pageId": "summary",
        "pageName": "Summary",
        "pageTitle": "Cloud Endpoint Configuration Summary",
        "welcomeText": "Cloud Adapter configuration was successful.",
        "helpId": "summary",
        "disabled": false
      }
    ],
    "currentPageId": "configuration",
    "pluginId": "cloud:google-sheets"
  },
  "editFields": [
    {
      "labelFieldLayout": "twoRowFields",
      "helpText": null,
      "rowIdentifier": -1,
      "oneRowLabelFieldAlignment": "LEFT_LEFT",
      "triggerNext": false,
      "name": "spreadsheetId",
      "object": {
        "filterRequired": false,
        "filterPlaceHolderText": null,
        "groupFilterObject": null,
        "width": null,
        "filterHelpText": null,
        "itemDescriptionLabel": null,
        "filterText": null,
        "previousSelection": null,
        "size": 10,
        "type": "comboBoxObject",
        "groupFilterRequired": false,
        "displayItemDescription": false,
        "displayMode": 0,
        "options": [
          {
            "value": "1WxoiFLblMO6zeN7qkZkjnopI8_6vvfFB84dvbrZIdh0",
            "type": null,
            "formattedValue": "Customer Managment"
          },
          {
            "value": "1_7maXDpc_qMMRzMm0x6d90-Hj6vvhGyO2kyFX0tpuZs",
            "type": null,
            "formattedValue": "HL7 Message - FHIR R4: VXU_V04"
          },
          {
            "value": "1evBW_GzccQVcMM4OcBGXBiJOHhuywdahjQnAl5a9MjY",
            "type": null,
            "formattedValue": "Copy of Restricted Stock Unit (RSU) Calculator"
          },
          {
            "value": "1DjtOl1dvZPMT0O0LJZZts9foehDdRoicmfTP022Fkw4",
            "type": null,
            "formattedValue": "Development Management"
          },
          {
            "value": "1GT8i-J_PmgZwK0oer_VsHG1ev2JaR8jASK5Va7IUWEU",
            "type": null,
            "formattedValue": "Event Attendee List"
          },
          {
            "value": "1Ol0b0Et3MccQsXfHI4tAqvabENSHE6c1HnU2kDfYU0E",
            "type": null,
            "formattedValue": "HR Management"
          },
          {
            "value": "1MEv_Ifg87I0Qoe86RUp4cdOrVnQgcj8NLU1HKjHkKso",
            "type": null,
            "formattedValue": "Financial Managment"
          },
          {
            "value": "1yOVioh6TuYayc78Sbgwo6yxsbOIZE7IQpKqXomJ-qdA",
            "type": null,
            "formattedValue": "UAT-File"
          },
          {
            "value": "1ZveTrV1yDf92X_VPiE8FPDslUotfSiX7ztHfjCzWCQc",
            "type": null,
            "formattedValue": "SalesAccounts"
          }
        ],
        "value": null,
        "hasEvent": true
      },
      "required": true,
      "description": "",
      "disabled": false,
      "basic": true,
      "advanced": false,
      "label": "Spreadsheet Name"
    }
  ],
  "logs": [
    {
      "time": "2024-08-12T18:56:30.604071223",
      "flow": "spreadsheetIdFlow",
      "state": "startState",
      "summary": "State Execution Start",
      "input": {},
      "context": {
        "connectionProperties": {
          "applicationVersion": "1.0",
          "serviceInstanceOcid": "ocid5.exampleinstance.oc1.region.jjack",
          "pluginID": "cloud:google-sheets",
          "managedSecurity": "true",
          "integration_role": "TARGET",
          "oauth.scope": "https://www.googleapis.com/auth/drive https://www.googleapis.com/auth/spreadsheets",
          "useProxy": "true",
          "securityPolicy": "OAUTH_AUTHORIZATION_CODE_CREDENTIALS",
          "proxyHost": "10.xx.xy.yy",
          "oauth.client.id": "813090821001-uqpc1lsvauooc3lv8j3bh52cfs6kmfl4.apps.googleusercontent.com",
          "httpsProxyPort": "80",
          "oauth.client.secret": "gsYK8nYxxxxKx5p111188daJ",
          "oauth.auth.code.uri": "https://accounts.google.com/o/oauth2/auth",
          "oauth.access.token.uri": "https://www.googleapis.com/oauth2/v4/token",
          "proxyPort": "80",
          "RABEngineVersion": "24.10",
          "csfMap": "example.wsm.security",
          "useCache": "true",
          "onPremise": "false",
          "clientAuthentication": "client_credentials_as_body",
          "httpsProxyHost": "10.xx.xy.yy",
          "csfkey": "fac648317448763xxxxx2efd61a50c80243xxxxx2634ad87d396yyy7e5189038"
        },
        "input": {},
        "cloudAdapterUIBindingId": "04881642-6e72-8744-51f6-bea7270bf9bf",
        "configuration": {},
        "self": {
          "info": {
            "id": "cloud:google-sheets",
            "displayName": "Google Sheets",
            "description": "Google Sheets is a cloud-based sheet management service.",
            "version": "1.0.0",
            "specVersion": "1.0",
            "categories": [],
            "appInfo": {
              "name": "Example Corporation",
              "description": "https://www.example.com/about",
              "contactUS": "http://www.example.com/corp/contact/index.html",
              "supportURL": "http://support.example.com",
              "documentationURL": "https://www.example.com/pls/topic/lookup?ctx=DOCID"
            },
            "publisherInfo": {
              "name": "Example Corporation",
              "description": "https://www.example.com/about",
              "contactUS": "http://www.example.com/corp/contact/index.html",
              "supportURL": "http://support.example.com",
              "documentationURL": "https://www.example.com/pls/topic/lookup?ctx=DOCID"
            },
            "settings": {
              "supportsConnectivityAgent": true,
              "_debug": true
            }
          },
          "connection": {
            "connectionProperties": [],
            "securityPolicies": [
              {
                "type": "managed",
                "policy": "OAUTH_AUTHORIZATION_CODE_CREDENTIALS",
                "description": "Google Authorization Policy",
                "displayName": "Google Authorization Policy",
                "scope": "ACTION",
                "securityProperties": [
                  {
                    "name": "oauth.client.id",
                    "displayName": "Google Client ID",
                    "description": "Google Client ID",
                    "shortDescription": "Google Client ID",
                    "hidden": false,
                    "required": true
                  },
                  {
                    "name": "oauth.client.secret",
                    "displayName": "Google Client Secret",
                    "description": "Google Client secret",
                    "shortDescription": "Google Client secret",
                    "hidden": false,
                    "required": true
                  },
                  {
                    "name": "oauth.auth.code.uri",
                    "default": "https://accounts.google.com/o/oauth2/auth",
                    "hidden": true,
                    "required": true
                  },
                  {
                    "name": "oauth.access.token.uri",
                    "default": "https://www.googleapis.com/oauth2/v4/token",
                    "hidden": true,
                    "required": true
                  },
                  {
                    "name": "oauth.scope",
                    "default": "https://www.googleapis.com/auth/drive https://www.googleapis.com/auth/spreadsheets",
                    "hidden": true,
                    "required": true
                  },
                  {
                    "name": "clientAuthentication",
                    "default": "client_credentials_as_body",
                    "hidden": true,
                    "required": true
                  }
                ],
                "authExtension": {
                  "authorizationURL": {
                    "uri": "${.securityProperties.\"oauth.auth.code.uri\"}",
                    "params": {
                      "query": {
                        "response_type": "code",
                        "client_id": "${.securityProperties.\"oauth.client.id\"}",
                        "redirect_uri": "${redirect_uri}",
                        "scope": "${.securityProperties.\"oauth.scope\"}",
                        "access_type": "offline",
                        "approval_prompt": "force"
                      }
                    }
                  },
                  "accessTokenRequest": {
                    "method": "POST",
                    "uri": "${.securityProperties.\"oauth.access.token.uri\"}",
                    "params": {
                      "query": {
                        "code": "${auth_code}",
                        "client_id": "${.securityProperties.\"oauth.client.id\"}",
                        "redirect_uri": "${redirect_uri}",
                        "client_secret": "${.securityProperties.\"oauth.client.secret\"}",
                        "grant_type": "authorization_code"
                      }
                    },
                    "headers": {
                      "Content-Type": "application/x-www-form-urlencoded",
                      "Authorization": "${\"Basic \" + ((.securityProperties.\"oauth.client.id\")+\":\"+(.securityProperties.\"oauth.client.secret\") | @base64)}"
                    },
                    "body": "false"
                  },
                  "refreshTokenRequest": {
                    "method": "POST",
                    "uri": "${.securityProperties.\"oauth.access.token.uri\"}",
                    "params": {
                      "template": {},
                      "query": {
                        "refresh_token": "${refresh_token}",
                        "client_id": "${.securityProperties.\"oauth.client.id\"}",
                        "client_secret": "${.securityProperties.\"oauth.client.secret\"}",
                        "grant_type": "refresh_token"
                      }
                    },
                    "headers": {
                      "Content-Type": "application/x-www-form-urlencoded"
                    },
                    "body": "false"
                  },
                  "fetchRules": {
                    "auth_code": "code",
                    "access_token": "access.[tT]oken",
                    "refresh_token": "refresh.[tT]oken",
                    "expiry": "expires.*",
                    "token_type": "token.?[tT]ype"
                  },
                  "accessTokenUsage": {
                    "headers": {
                      "Authorization": "Bearer ${access_token}"
                    }
                  }
                }
              }
            ],
            "test": "flow:testConnectionFlow"
          },
          "schemas": {
            "Sheet": {
              "type": "object",
              "properties": {
                "properties": {
                  "type": "object",
                  "properties": {
                    "sheetId": {
                      "type": "integer"
                    },
                    "title": {
                      "type": "string"
                    },
                    "index": {
                      "type": "integer"
                    },
                    "sheetType": {
                      "type": "string"
                    }
                  }
                }
              }
            },
            "Spreadsheet": {
              "type": "object",
              "properties": {
                "spreadsheetId": {
                  "type": "string"
                },
                "spreadsheetUrl": {
                  "type": "string"
                },
                "properties": {
                  "type": "object",
                  "properties": {
                    "title": {
                      "type": "integer"
                    },
                    "locale": {
                      "type": "string"
                    },
                    "autoRecalc": {
                      "type": "integer"
                    },
                    "timeZone": {
                      "type": "string"
                    }
                  }
                },
                "sheets": {
                  "type": "array",
                  "items": {
                    "$ref": "#/schemas/Sheet"
                  }
                }
              }
            },
            "getSpreadsheetInput": {
              "type": "object",
              "properties": {
                "spreadsheetId": {
                  "type": "string"
                }
              }
            },
            "createSpreadsheetInput": {
              "type": "object",
              "properties": {
                "spreadsheetTitle": {
                  "type": "string"
                },
                "sheets": {
                  "type": "array",
                  "items": {
                    "type": "object",
                    "properties": {
                      "sheetTitle": {
                        "type": "string"
                      }
                    }
                  }
                }
              }
            },
            "insertRowOutput": {
              "type": "object",
              "properties": {
                "spreadsheetId": {
                  "type": "string"
                },
                "tableRange": {
                  "type": "string"
                },
                "updates": {
                  "type": "object",
                  "properties": {
                    "spreadsheetId": {
                      "type": "string"
                    },
                    "updatedRange": {
                      "type": "string"
                    },
                    "updatedRows": {
                      "type": "integer"
                    },
                    "updatedColumns": {
                      "type": "integer"
                    },
                    "updatedCells": {
                      "type": "integer"
                    }
                  }
                }
              }
            },
            "getRowInput": {
              "type": "object",
              "properties": {
                "rowNumber": {
                  "type": "integer"
                }
              }
            }
          },
          "actions": {
            "insertRowAction": {
              "displayName": "Insert Row Into Sheet",
              "description": "This action insert a new row into sheet.",
              "execute": "flow:insertRowFlow",
              "input": "flow:sheetSchemaFlow",
              "output": {
                "schemaType": "application/schema+json",
                "schema": {
                  "$ref": "#/schemas/insertRowOutput"
                }
              },
              "configuration": [
                {
                  "name": "spreadsheetId",
                  "displayName": "Spreadsheet Name",
                  "description": "",
                  "type": "COMBO_BOX",
                  "options": "flow:spreadsheetIdFlow",
                  "required": true
                },
                {
                  "name": "sheetId",
                  "displayName": "Sheet Name",
                  "description": "",
                  "type": "COMBO_BOX",
                  "options": "flow:sheetIdFlow",
                  "required": true,
                  "dependencies": {
                    "spreadsheetId": {
                      "values": []
                    }
                  }
                }
              ]
            },
            "getRowAction": {
              "displayName": "Get Row From Sheet",
              "description": "This action get a row from sheet.",
              "execute": "flow:getRowFlow",
              "input": {
                "schemaType": "application/schema+json",
                "schema": {
                  "$ref": "#/schemas/getRowInput"
                }
              },
              "output": "flow:sheetSchemaFlow",
              "configuration": [
                {
                  "name": "spreadsheetId",
                  "displayName": "Spreadsheet Name",
                  "description": "",
                  "type": "COMBO_BOX",
                  "options": "flow:spreadsheetIdFlow",
                  "required": true
                },
                {
                  "name": "sheetId",
                  "displayName": "Sheet Name",
                  "description": "",
                  "type": "COMBO_BOX",
                  "options": "flow:sheetIdFlow",
                  "required": true,
                  "dependencies": {
                    "spreadsheetId": {
                      "values": []
                    }
                  }
                },
                {
                  "name": "rowOperation",
                  "displayName": "Operation",
                  "description": "",
                  "type": "COMBO_BOX",
                  "required": true,
                  "options": [
                    {
                      "keyName": "currentRow",
                      "displayName": "Get Specific Row"
                    },
                    {
                      "keyName": "lastRow",
                      "displayName": "Get Last Row"
                    }
                  ]
                }
              ]
            },
            "createSpreadsheetAction": {
              "displayName": "Create Spreadsheet",
              "description": "This action creates a new spreadsheet.",
              "execute": "flow:createSpreadsheetFlow",
              "input": {
                "schemaType": "application/schema+json",
                "schema": {
                  "$ref": "#/schemas/createSpreadsheetInput"
                }
              },
              "output": {
                "schemaType": "application/schema+json",
                "schema": {
                  "$ref": "#/schemas/Spreadsheet"
                }
              }
            },
            "insertRowActionErrorEngine": {
              "displayName": "Insert Row Into Sheet(Engine Error for Demo)",
              "description": "This action insert a new row into sheet.",
              "execute": "flow:insertRowFlow",
              "input": "flow:sheetSchemaFlow",
              "output": {
                "schemaType": "application/schema+json",
                "schema": {
                  "$ref": "#/schemas/insertRowOutput"
                }
              },
              "configuration": [
                {
                  "name": "spreadsheetId",
                  "displayName": "Spreadsheet Name",
                  "description": "",
                  "type": "COMBO_BOX",
                  "options": "flow:spreadsheetIdFlow",
                  "required": true
                },
                {
                  "name": "sheetId",
                  "displayName": "Sheet Name",
                  "description": "",
                  "type": "COMBO_BOX",
                  "options": "flow:sheetIdFlowErrorEngine",
                  "required": true,
                  "dependencies": {
                    "spreadsheetId": {
                      "values": []
                    }
                  }
                }
              ]
            }
          },
          "flows": {
            "insertRowFlow": {
              "id": "insertRowFlow",
              "description": "insertRowFlow",
              "specVersion": "0.8",
              "version": "0.1",
              "start": "startState",
              "functions": [
                {
                  "name": "generalRestFunc",
                  "type": "custom",
                  "operation": "connectivity::rest"
                }
              ],
              "states": [
                {
                  "name": "startState",
                  "type": "operation",
                  "actions": [
                    {
                      "name": "insertRowAction",
                      "functionRef": {
                        "refName": "generalRestFunc",
                        "arguments": {
                          "uri": "https://sheets.googleapis.com/v4/spreadsheets/{spreadsheetId}/values/{range}:append",
                          "method": "POST",
                          "parameters": {
                            "spreadsheetId": "${ .configuration.spreadsheetId }",
                            "range": "${ .configuration.sheetId + \"!A1:Z1\" }",
                            "insertDataOption": "INSERT_ROWS",
                            "valueInputOption": "RAW"
                          },
                          "body": "${ {range: (.configuration.sheetId + \"!A1:Z1\"), majorDimension:\"ROWS\", values: .input | to_entries | [map(.value)] } }"
                        }
                      },
                      "actionDataFilter": {
                        "results": "${ .body }",
                        "toStateData": "${ .output }"
                      }
                    }
                  ],
                  "end": true
                }
              ]
            },
            "getRowFlow": {
              "id": "getRowFlow",
              "description": "getRowFlow",
              "specVersion": "0.8",
              "version": "0.1",
              "start": "startState",
              "functions": [
                {
                  "name": "generalRestFunc",
                  "type": "custom",
                  "operation": "connectivity::rest"
                },
                {
                  "name": "convertResult",
                  "type": "expression",
                  "operation": "(if .configuration.rowOperation == \"lastRow\" then (.lastLineNumber-1) else (.input.rowNumber-1) end) as $rowNum | .values | map({key:.[0], value:.[$rowNum]}) | from_entries"
                }
              ],
              "states": [
                {
                  "name": "startState",
                  "type": "operation",
                  "actions": [
                    {
                      "functionRef": {
                        "refName": "generalRestFunc",
                        "arguments": {
                          "uri": "https://sheets.googleapis.com/v4/spreadsheets/{spreadsheetId}/values/{range}",
                          "method": "GET",
                          "parameters": {
                            "spreadsheetId": "${ .configuration.spreadsheetId }",
                            "range": "${ .configuration.sheetId + \"!A1:Z40000\" }",
                            "majorDimension": "ROWS"
                          }
                        }
                      },
                      "actionDataFilter": {
                        "results": "${ .body.values | length }",
                        "toStateData": "${ .lastLineNumber }"
                      }
                    },
                    {
                      "functionRef": {
                        "refName": "generalRestFunc",
                        "arguments": {
                          "uri": "https://sheets.googleapis.com/v4/spreadsheets/{spreadsheetId}/values/{range}",
                          "method": "GET",
                          "parameters": {
                            "spreadsheetId": "${ .configuration.spreadsheetId }",
                            "range": "${ if .configuration.rowOperation == \"lastRow\" then .configuration.sheetId + \"!A1:Z\" + (.lastLineNumber|tostring) else .configuration.sheetId + \"!A1:Z\" + (.input.rowNumber|tostring) end }",
                            "majorDimension": "COLUMNS"
                          }
                        }
                      },
                      "actionDataFilter": {
                        "results": "${ .body.values }",
                        "toStateData": "${ .values }"
                      }
                    },
                    {
                      "functionRef": "convertResult",
                      "actionDataFilter": {
                        "toStateData": "${ .output }"
                      }
                    }
                  ],
                  "end": true
                }
              ]
            },
            "createSpreadsheetFlow": {
              "id": "createSpreadsheetFlow",
              "description": "createSpreadsheetFlow",
              "specVersion": "0.8",
              "version": "0.1",
              "start": "startState",
              "functions": [
                {
                  "name": "generalRestFunc",
                  "type": "custom",
                  "operation": "connectivity::rest"
                }
              ],
              "states": [
                {
                  "name": "startState",
                  "type": "operation",
                  "actions": [
                    {
                      "functionRef": {
                        "refName": "generalRestFunc",
                        "arguments": {
                          "uri": "https://sheets.googleapis.com/v4/spreadsheets",
                          "method": "POST",
                          "body": "${ {properties:{title:.input.spreadsheetTitle},sheets:.input.sheets|map({properties:{title:.sheetTitle}})} }"
                        }
                      },
                      "actionDataFilter": {
                        "results": "${ .body }",
                        "toStateData": "${ .output }"
                      }
                    }
                  ],
                  "end": true
                }
              ]
            },
            "testConnectionFlow": {
              "id": "testConnectionFlow",
              "description": "testConnectionFlow",
              "specVersion": "0.8",
              "version": "0.1",
              "start": "startState",
              "functions": [
                {
                  "name": "generalRestFunc",
                  "type": "custom",
                  "operation": "connectivity::rest"
                }
              ],
              "states": [
                {
                  "name": "startState",
                  "type": "operation",
                  "actions": [
                    {
                      "functionRef": {
                        "refName": "generalRestFunc",
                        "arguments": {
                          "uri": "https://www.googleapis.com/drive/v3/files",
                          "method": "GET"
                        }
                      },
                      "actionDataFilter": {
                        "results": "${ { success: (.status==200), message: .body.error.message } }",
                        "toStateData": "${ .output }"
                      }
                    }
                  ],
                  "end": true
                }
              ]
            },
            "spreadsheetIdFlow": {
              "id": "spreadsheetIdFlow",
              "description": "spreadsheetIdFlow",
              "specVersion": "0.8",
              "version": "0.1",
              "start": "startState",
              "functions": [
                {
                  "name": "generalRestFunc",
                  "type": "custom",
                  "operation": "connectivity::rest"
                }
              ],
              "states": [
                {
                  "name": "startState",
                  "type": "operation",
                  "actions": [
                    {
                      "name": "getAllSpreadsheetIDs",
                      "functionRef": {
                        "refName": "generalRestFunc",
                        "arguments": {
                          "uri": "https://www.googleapis.com/drive/v3/files",
                          "method": "GET",
                          "parameters": {
                            "q": "mimeType='application/vnd.google-apps.spreadsheet' and trashed=false",
                            "pageSize": 1000
                          }
                        }
                      },
                      "actionDataFilter": {
                        "results": "${ .body.files | map({keyName:.id, displayName:.name}) }",
                        "toStateData": "${ .output }"
                      }
                    }
                  ],
                  "end": true
                }
              ]
            },
            "sheetIdFlow": {
              "id": "sheetIdFlow",
              "description": "sheetIdFlow",
              "specVersion": "0.8",
              "version": "0.1",
              "start": "startState",
              "functions": [
                {
                  "name": "generalRestFunc",
                  "type": "custom",
                  "operation": "connectivity::rest"
                }
              ],
              "states": [
                {
                  "name": "startState",
                  "type": "operation",
                  "actions": [
                    {
                      "name": "getAllSheetIDsBySpreadsheetId",
                      "functionRef": {
                        "refName": "generalRestFunc",
                        "arguments": {
                          "uri": "https://sheets.googleapis.com/v4/spreadsheets/{spreadsheetId}",
                          "method": "GET",
                          "parameters": {
                            "spreadsheetId": "${ .configuration.spreadsheetId }"
                          }
                        }
                      },
                      "actionDataFilter": {
                        "results": "${ .body.sheets | map({keyName:.properties.title, displayName:.properties.title}) }",
                        "toStateData": "${ .output }"
                      }
                    }
                  ],
                  "end": true
                }
              ]
            },
            "sheetSchemaFlow": {
              "id": "sheetSchemaFlow",
              "description": "sheetSchemaFlow",
              "specVersion": "0.8",
              "version": "0.1",
              "start": "startState",
              "functions": [
                {
                  "name": "generalRestFunc",
                  "type": "custom",
                  "operation": "connectivity::rest"
                },
                {
                  "name": "constructReturnObject",
                  "type": "expression",
                  "operation": "{\"schemaType\": \"application/schema+json\", \"schema\": .schema}"
                }
              ],
              "states": [
                {
                  "name": "startState",
                  "type": "operation",
                  "actions": [
                    {
                      "name": "generateSchemaBySheetHeader",
                      "functionRef": {
                        "refName": "generalRestFunc",
                        "arguments": {
                          "uri": "https://sheets.googleapis.com/v4/spreadsheets/{spreadsheetId}/values/{range}",
                          "method": "GET",
                          "parameters": {
                            "spreadsheetId": "${ .configuration.spreadsheetId }",
                            "range": "${ .configuration.sheetId + \"!A1:Z1\" }",
                            "majorDimension": "ROWS"
                          }
                        }
                      },
                      "actionDataFilter": {
                        "results": "${ .body.values[0] | map({key:., value: {type:\"string\"}}) | from_entries | {type: \"object\", properties: .} }",
                        "toStateData": "${ .schema }"
                      }
                    },
                    {
                      "name": "addSchemaType",
                      "functionRef": "constructReturnObject",
                      "actionDataFilter": {
                        "toStateData": "${ .output }"
                      }
                    }
                  ],
                  "end": true
                }
              ]
            },
            "sheetIdFlowErrorEngine": {
              "id": "sheetIdFlowErrorEngine",
              "description": "sheetIdFlowErrorEngine",
              "specVersion": "0.8",
              "version": "0.1",
              "start": "startState",
              "functions": [
                {
                  "name": "generalRestFunc",
                  "type": "custom",
                  "operation": "connectivity::rest"
                }
              ],
              "states": [
                {
                  "name": "startState",
                  "type": "operation",
                  "actions": [
                    {
                      "name": "getAllSheetIDsBySpreadsheetId",
                      "functionRef": {
                        "refName": "generalRestFunc",
                        "arguments": {
                          "uri": "https://sheets.googleapis.com/v4/spreadsheets/{spreadsheetId}",
                          "method": "GET",
                          "parameters": {
                            "spreadsheetId": "${ .configuration.spreadsheetId }"
                          }
                        }
                      },
                      "actionDataFilter": {
                        "results": "${ .sheets | map({keyName:.title, displayName:.title}) }",
                        "toStateData": "${ .output }"
                      }
                    }
                  ],
                  "end": true
                }
              ]
            }
          }
        }
      }
    },
    {
      "time": "2024-08-12T18:56:30.605913431",
      "flow": "spreadsheetIdFlow",
      "state": "startState",
      "action": "getAllSpreadsheetIDs",
      "summary": "Action Execution Start",
      "input": {},
      "context": {
        "connectionProperties": {
          "applicationVersion": "1.0",
          "serviceInstanceOcid": "ocid5.exampleinstance.oc1.region.jjack",
          "pluginID": "cloud:google-sheets",
          "managedSecurity": "true",
          "integration_role": "TARGET",
          "oauth.scope": "https://www.googleapis.com/auth/drive https://www.googleapis.com/auth/spreadsheets",
          "useProxy": "true",
          "securityPolicy": "OAUTH_AUTHORIZATION_CODE_CREDENTIALS",
          "proxyHost": "10.xx.xy.yy",
          "oauth.client.id": "813090821001-uqpc1lsvauooc3lv8j3bh52cfs6kmfl4.apps.googleusercontent.com",
          "httpsProxyPort": "80",
          "oauth.client.secret": "gsYK8nYxxxxKx5p111188daJ",
          "oauth.auth.code.uri": "https://accounts.google.com/o/oauth2/auth",
          "oauth.access.token.uri": "https://www.googleapis.com/oauth2/v4/token",
          "proxyPort": "80",
          "RABEngineVersion": "24.10",
          "csfMap": "example.wsm.security",
          "useCache": "true",
          "onPremise": "false",
          "clientAuthentication": "client_credentials_as_body",
          "httpsProxyHost": "10.xx.xy.yy",
          "csfkey": "fac648317448763xxxxx2efd61a50c80243xxxxx2634ad87d396yyy7e5189038"
        },
        "input": {},
        "cloudAdapterUIBindingId": "04881642-6e72-8744-51f6-bea7270bf9bf",
        "configuration": {},
        "self": {
          "info": {
            "id": "cloud:google-sheets",
            "displayName": "Google Sheets",
            "description": "Google Sheets is a cloud-based sheet management service.",
            "version": "1.0.0",
            "specVersion": "1.0",
            "categories": [],
            "appInfo": {
              "name": "Example Corporation",
              "description": "https://www.example.com/about",
              "contactUS": "http://www.example.com/corp/contact/index.html",
              "supportURL": "http://support.example.com",
              "documentationURL": "https://www.example.com/pls/topic/lookup?ctx=DOCID"
            },
            "publisherInfo": {
              "name": "Example Corporation",
              "description": "https://www.example.com/about",
              "contactUS": "http://www.example.com/corp/contact/index.html",
              "supportURL": "http://support.example.com",
              "documentationURL": "https://www.example.com/pls/topic/lookup?ctx=DOCID"
            },
            "settings": {
              "supportsConnectivityAgent": true,
              "_debug": true
            }
          },
          "connection": {
            "connectionProperties": [],
            "securityPolicies": [
              {
                "type": "managed",
                "policy": "OAUTH_AUTHORIZATION_CODE_CREDENTIALS",
                "description": "Google Authorization Policy",
                "displayName": "Google Authorization Policy",
                "scope": "ACTION",
                "securityProperties": [
                  {
                    "name": "oauth.client.id",
                    "displayName": "Google Client ID",
                    "description": "Google Client ID",
                    "shortDescription": "Google Client ID",
                    "hidden": false,
                    "required": true
                  },
                  {
                    "name": "oauth.client.secret",
                    "displayName": "Google Client Secret",
                    "description": "Google Client secret",
                    "shortDescription": "Google Client secret",
                    "hidden": false,
                    "required": true
                  },
                  {
                    "name": "oauth.auth.code.uri",
                    "default": "https://accounts.google.com/o/oauth2/auth",
                    "hidden": true,
                    "required": true
                  },
                  {
                    "name": "oauth.access.token.uri",
                    "default": "https://www.googleapis.com/oauth2/v4/token",
                    "hidden": true,
                    "required": true
                  },
                  {
                    "name": "oauth.scope",
                    "default": "https://www.googleapis.com/auth/drive https://www.googleapis.com/auth/spreadsheets",
                    "hidden": true,
                    "required": true
                  },
                  {
                    "name": "clientAuthentication",
                    "default": "client_credentials_as_body",
                    "hidden": true,
                    "required": true
                  }
                ],
                "authExtension": {
                  "authorizationURL": {
                    "uri": "${.securityProperties.\"oauth.auth.code.uri\"}",
                    "params": {
                      "query": {
                        "response_type": "code",
                        "client_id": "${.securityProperties.\"oauth.client.id\"}",
                        "redirect_uri": "${redirect_uri}",
                        "scope": "${.securityProperties.\"oauth.scope\"}",
                        "access_type": "offline",
                        "approval_prompt": "force"
                      }
                    }
                  },
                  "accessTokenRequest": {
                    "method": "POST",
                    "uri": "${.securityProperties.\"oauth.access.token.uri\"}",
                    "params": {
                      "query": {
                        "code": "${auth_code}",
                        "client_id": "${.securityProperties.\"oauth.client.id\"}",
                        "redirect_uri": "${redirect_uri}",
                        "client_secret": "${.securityProperties.\"oauth.client.secret\"}",
                        "grant_type": "authorization_code"
                      }
                    },
                    "headers": {
                      "Content-Type": "application/x-www-form-urlencoded",
                      "Authorization": "${\"Basic \" + ((.securityProperties.\"oauth.client.id\")+\":\"+(.securityProperties.\"oauth.client.secret\") | @base64)}"
                    },
                    "body": "false"
                  },
                  "refreshTokenRequest": {
                    "method": "POST",
                    "uri": "${.securityProperties.\"oauth.access.token.uri\"}",
                    "params": {
                      "template": {},
                      "query": {
                        "refresh_token": "${refresh_token}",
                        "client_id": "${.securityProperties.\"oauth.client.id\"}",
                        "client_secret": "${.securityProperties.\"oauth.client.secret\"}",
                        "grant_type": "refresh_token"
                      }
                    },
                    "headers": {
                      "Content-Type": "application/x-www-form-urlencoded"
                    },
                    "body": "false"
                  },
                  "fetchRules": {
                    "auth_code": "code",
                    "access_token": "access.[tT]oken",
                    "refresh_token": "refresh.[tT]oken",
                    "expiry": "expires.*",
                    "token_type": "token.?[tT]ype"
                  },
                  "accessTokenUsage": {
                    "headers": {
                      "Authorization": "Bearer ${access_token}"
                    }
                  }
                }
              }
            ],
            "test": "flow:testConnectionFlow"
          },
          "schemas": {
            "Sheet": {
              "type": "object",
              "properties": {
                "properties": {
                  "type": "object",
                  "properties": {
                    "sheetId": {
                      "type": "integer"
                    },
                    "title": {
                      "type": "string"
                    },
                    "index": {
                      "type": "integer"
                    },
                    "sheetType": {
                      "type": "string"
                    }
                  }
                }
              }
            },
            "Spreadsheet": {
              "type": "object",
              "properties": {
                "spreadsheetId": {
                  "type": "string"
                },
                "spreadsheetUrl": {
                  "type": "string"
                },
                "properties": {
                  "type": "object",
                  "properties": {
                    "title": {
                      "type": "integer"
                    },
                    "locale": {
                      "type": "string"
                    },
                    "autoRecalc": {
                      "type": "integer"
                    },
                    "timeZone": {
                      "type": "string"
                    }
                  }
                },
                "sheets": {
                  "type": "array",
                  "items": {
                    "$ref": "#/schemas/Sheet"
                  }
                }
              }
            },
            "getSpreadsheetInput": {
              "type": "object",
              "properties": {
                "spreadsheetId": {
                  "type": "string"
                }
              }
            },
            "createSpreadsheetInput": {
              "type": "object",
              "properties": {
                "spreadsheetTitle": {
                  "type": "string"
                },
                "sheets": {
                  "type": "array",
                  "items": {
                    "type": "object",
                    "properties": {
                      "sheetTitle": {
                        "type": "string"
                      }
                    }
                  }
                }
              }
            },
            "insertRowOutput": {
              "type": "object",
              "properties": {
                "spreadsheetId": {
                  "type": "string"
                },
                "tableRange": {
                  "type": "string"
                },
                "updates": {
                  "type": "object",
                  "properties": {
                    "spreadsheetId": {
                      "type": "string"
                    },
                    "updatedRange": {
                      "type": "string"
                    },
                    "updatedRows": {
                      "type": "integer"
                    },
                    "updatedColumns": {
                      "type": "integer"
                    },
                    "updatedCells": {
                      "type": "integer"
                    }
                  }
                }
              }
            },
            "getRowInput": {
              "type": "object",
              "properties": {
                "rowNumber": {
                  "type": "integer"
                }
              }
            }
          },
          "actions": {
            "insertRowAction": {
              "displayName": "Insert Row Into Sheet",
              "description": "This action insert a new row into sheet.",
              "execute": "flow:insertRowFlow",
              "input": "flow:sheetSchemaFlow",
              "output": {
                "schemaType": "application/schema+json",
                "schema": {
                  "$ref": "#/schemas/insertRowOutput"
                }
              },
              "configuration": [
                {
                  "name": "spreadsheetId",
                  "displayName": "Spreadsheet Name",
                  "description": "",
                  "type": "COMBO_BOX",
                  "options": "flow:spreadsheetIdFlow",
                  "required": true
                },
                {
                  "name": "sheetId",
                  "displayName": "Sheet Name",
                  "description": "",
                  "type": "COMBO_BOX",
                  "options": "flow:sheetIdFlow",
                  "required": true,
                  "dependencies": {
                    "spreadsheetId": {
                      "values": []
                    }
                  }
                }
              ]
            },
            "getRowAction": {
              "displayName": "Get Row From Sheet",
              "description": "This action get a row from sheet.",
              "execute": "flow:getRowFlow",
              "input": {
                "schemaType": "application/schema+json",
                "schema": {
                  "$ref": "#/schemas/getRowInput"
                }
              },
              "output": "flow:sheetSchemaFlow",
              "configuration": [
                {
                  "name": "spreadsheetId",
                  "displayName": "Spreadsheet Name",
                  "description": "",
                  "type": "COMBO_BOX",
                  "options": "flow:spreadsheetIdFlow",
                  "required": true
                },
                {
                  "name": "sheetId",
                  "displayName": "Sheet Name",
                  "description": "",
                  "type": "COMBO_BOX",
                  "options": "flow:sheetIdFlow",
                  "required": true,
                  "dependencies": {
                    "spreadsheetId": {
                      "values": []
                    }
                  }
                },
                {
                  "name": "rowOperation",
                  "displayName": "Operation",
                  "description": "",
                  "type": "COMBO_BOX",
                  "required": true,
                  "options": [
                    {
                      "keyName": "currentRow",
                      "displayName": "Get Specific Row"
                    },
                    {
                      "keyName": "lastRow",
                      "displayName": "Get Last Row"
                    }
                  ]
                }
              ]
            },
            "createSpreadsheetAction": {
              "displayName": "Create Spreadsheet",
              "description": "This action creates a new spreadsheet.",
              "execute": "flow:createSpreadsheetFlow",
              "input": {
                "schemaType": "application/schema+json",
                "schema": {
                  "$ref": "#/schemas/createSpreadsheetInput"
                }
              },
              "output": {
                "schemaType": "application/schema+json",
                "schema": {
                  "$ref": "#/schemas/Spreadsheet"
                }
              }
            },
            "insertRowActionErrorEngine": {
              "displayName": "Insert Row Into Sheet(Engine Error for Demo)",
              "description": "This action insert a new row into sheet.",
              "execute": "flow:insertRowFlow",
              "input": "flow:sheetSchemaFlow",
              "output": {
                "schemaType": "application/schema+json",
                "schema": {
                  "$ref": "#/schemas/insertRowOutput"
                }
              },
              "configuration": [
                {
                  "name": "spreadsheetId",
                  "displayName": "Spreadsheet Name",
                  "description": "",
                  "type": "COMBO_BOX",
                  "options": "flow:spreadsheetIdFlow",
                  "required": true
                },
                {
                  "name": "sheetId",
                  "displayName": "Sheet Name",
                  "description": "",
                  "type": "COMBO_BOX",
                  "options": "flow:sheetIdFlowErrorEngine",
                  "required": true,
                  "dependencies": {
                    "spreadsheetId": {
                      "values": []
                    }
                  }
                }
              ]
            }
          },
          "flows": {
            "insertRowFlow": {
              "id": "insertRowFlow",
              "description": "insertRowFlow",
              "specVersion": "0.8",
              "version": "0.1",
              "start": "startState",
              "functions": [
                {
                  "name": "generalRestFunc",
                  "type": "custom",
                  "operation": "connectivity::rest"
                }
              ],
              "states": [
                {
                  "name": "startState",
                  "type": "operation",
                  "actions": [
                    {
                      "name": "insertRowAction",
                      "functionRef": {
                        "refName": "generalRestFunc",
                        "arguments": {
                          "uri": "https://sheets.googleapis.com/v4/spreadsheets/{spreadsheetId}/values/{range}:append",
                          "method": "POST",
                          "parameters": {
                            "spreadsheetId": "${ .configuration.spreadsheetId }",
                            "range": "${ .configuration.sheetId + \"!A1:Z1\" }",
                            "insertDataOption": "INSERT_ROWS",
                            "valueInputOption": "RAW"
                          },
                          "body": "${ {range: (.configuration.sheetId + \"!A1:Z1\"), majorDimension:\"ROWS\", values: .input | to_entries | [map(.value)] } }"
                        }
                      },
                      "actionDataFilter": {
                        "results": "${ .body }",
                        "toStateData": "${ .output }"
                      }
                    }
                  ],
                  "end": true
                }
              ]
            },
            "getRowFlow": {
              "id": "getRowFlow",
              "description": "getRowFlow",
              "specVersion": "0.8",
              "version": "0.1",
              "start": "startState",
              "functions": [
                {
                  "name": "generalRestFunc",
                  "type": "custom",
                  "operation": "connectivity::rest"
                },
                {
                  "name": "convertResult",
                  "type": "expression",
                  "operation": "(if .configuration.rowOperation == \"lastRow\" then (.lastLineNumber-1) else (.input.rowNumber-1) end) as $rowNum | .values | map({key:.[0], value:.[$rowNum]}) | from_entries"
                }
              ],
              "states": [
                {
                  "name": "startState",
                  "type": "operation",
                  "actions": [
                    {
                      "functionRef": {
                        "refName": "generalRestFunc",
                        "arguments": {
                          "uri": "https://sheets.googleapis.com/v4/spreadsheets/{spreadsheetId}/values/{range}",
                          "method": "GET",
                          "parameters": {
                            "spreadsheetId": "${ .configuration.spreadsheetId }",
                            "range": "${ .configuration.sheetId + \"!A1:Z40000\" }",
                            "majorDimension": "ROWS"
                          }
                        }
                      },
                      "actionDataFilter": {
                        "results": "${ .body.values | length }",
                        "toStateData": "${ .lastLineNumber }"
                      }
                    },
                    {
                      "functionRef": {
                        "refName": "generalRestFunc",
                        "arguments": {
                          "uri": "https://sheets.googleapis.com/v4/spreadsheets/{spreadsheetId}/values/{range}",
                          "method": "GET",
                          "parameters": {
                            "spreadsheetId": "${ .configuration.spreadsheetId }",
                            "range": "${ if .configuration.rowOperation == \"lastRow\" then .configuration.sheetId + \"!A1:Z\" + (.lastLineNumber|tostring) else .configuration.sheetId + \"!A1:Z\" + (.input.rowNumber|tostring) end }",
                            "majorDimension": "COLUMNS"
                          }
                        }
                      },
                      "actionDataFilter": {
                        "results": "${ .body.values }",
                        "toStateData": "${ .values }"
                      }
                    },
                    {
                      "functionRef": "convertResult",
                      "actionDataFilter": {
                        "toStateData": "${ .output }"
                      }
                    }
                  ],
                  "end": true
                }
              ]
            },
            "createSpreadsheetFlow": {
              "id": "createSpreadsheetFlow",
              "description": "createSpreadsheetFlow",
              "specVersion": "0.8",
              "version": "0.1",
              "start": "startState",
              "functions": [
                {
                  "name": "generalRestFunc",
                  "type": "custom",
                  "operation": "connectivity::rest"
                }
              ],
              "states": [
                {
                  "name": "startState",
                  "type": "operation",
                  "actions": [
                    {
                      "functionRef": {
                        "refName": "generalRestFunc",
                        "arguments": {
                          "uri": "https://sheets.googleapis.com/v4/spreadsheets",
                          "method": "POST",
                          "body": "${ {properties:{title:.input.spreadsheetTitle},sheets:.input.sheets|map({properties:{title:.sheetTitle}})} }"
                        }
                      },
                      "actionDataFilter": {
                        "results": "${ .body }",
                        "toStateData": "${ .output }"
                      }
                    }
                  ],
                  "end": true
                }
              ]
            },
            "testConnectionFlow": {
              "id": "testConnectionFlow",
              "description": "testConnectionFlow",
              "specVersion": "0.8",
              "version": "0.1",
              "start": "startState",
              "functions": [
                {
                  "name": "generalRestFunc",
                  "type": "custom",
                  "operation": "connectivity::rest"
                }
              ],
              "states": [
                {
                  "name": "startState",
                  "type": "operation",
                  "actions": [
                    {
                      "functionRef": {
                        "refName": "generalRestFunc",
                        "arguments": {
                          "uri": "https://www.googleapis.com/drive/v3/files",
                          "method": "GET"
                        }
                      },
                      "actionDataFilter": {
                        "results": "${ { success: (.status==200), message: .body.error.message } }",
                        "toStateData": "${ .output }"
                      }
                    }
                  ],
                  "end": true
                }
              ]
            },
            "spreadsheetIdFlow": {
              "id": "spreadsheetIdFlow",
              "description": "spreadsheetIdFlow",
              "specVersion": "0.8",
              "version": "0.1",
              "start": "startState",
              "functions": [
                {
                  "name": "generalRestFunc",
                  "type": "custom",
                  "operation": "connectivity::rest"
                }
              ],
              "states": [
                {
                  "name": "startState",
                  "type": "operation",
                  "actions": [
                    {
                      "name": "getAllSpreadsheetIDs",
                      "functionRef": {
                        "refName": "generalRestFunc",
                        "arguments": {
                          "uri": "https://www.googleapis.com/drive/v3/files",
                          "method": "GET",
                          "parameters": {
                            "q": "mimeType='application/vnd.google-apps.spreadsheet' and trashed=false",
                            "pageSize": 1000
                          }
                        }
                      },
                      "actionDataFilter": {
                        "results": "${ .body.files | map({keyName:.id, displayName:.name}) }",
                        "toStateData": "${ .output }"
                      }
                    }
                  ],
                  "end": true
                }
              ]
            },
            "sheetIdFlow": {
              "id": "sheetIdFlow",
              "description": "sheetIdFlow",
              "specVersion": "0.8",
              "version": "0.1",
              "start": "startState",
              "functions": [
                {
                  "name": "generalRestFunc",
                  "type": "custom",
                  "operation": "connectivity::rest"
                }
              ],
              "states": [
                {
                  "name": "startState",
                  "type": "operation",
                  "actions": [
                    {
                      "name": "getAllSheetIDsBySpreadsheetId",
                      "functionRef": {
                        "refName": "generalRestFunc",
                        "arguments": {
                          "uri": "https://sheets.googleapis.com/v4/spreadsheets/{spreadsheetId}",
                          "method": "GET",
                          "parameters": {
                            "spreadsheetId": "${ .configuration.spreadsheetId }"
                          }
                        }
                      },
                      "actionDataFilter": {
                        "results": "${ .body.sheets | map({keyName:.properties.title, displayName:.properties.title}) }",
                        "toStateData": "${ .output }"
                      }
                    }
                  ],
                  "end": true
                }
              ]
            },
            "sheetSchemaFlow": {
              "id": "sheetSchemaFlow",
              "description": "sheetSchemaFlow",
              "specVersion": "0.8",
              "version": "0.1",
              "start": "startState",
              "functions": [
                {
                  "name": "generalRestFunc",
                  "type": "custom",
                  "operation": "connectivity::rest"
                },
                {
                  "name": "constructReturnObject",
                  "type": "expression",
                  "operation": "{\"schemaType\": \"application/schema+json\", \"schema\": .schema}"
                }
              ],
              "states": [
                {
                  "name": "startState",
                  "type": "operation",
                  "actions": [
                    {
                      "name": "generateSchemaBySheetHeader",
                      "functionRef": {
                        "refName": "generalRestFunc",
                        "arguments": {
                          "uri": "https://sheets.googleapis.com/v4/spreadsheets/{spreadsheetId}/values/{range}",
                          "method": "GET",
                          "parameters": {
                            "spreadsheetId": "${ .configuration.spreadsheetId }",
                            "range": "${ .configuration.sheetId + \"!A1:Z1\" }",
                            "majorDimension": "ROWS"
                          }
                        }
                      },
                      "actionDataFilter": {
                        "results": "${ .body.values[0] | map({key:., value: {type:\"string\"}}) | from_entries | {type: \"object\", properties: .} }",
                        "toStateData": "${ .schema }"
                      }
                    },
                    {
                      "name": "addSchemaType",
                      "functionRef": "constructReturnObject",
                      "actionDataFilter": {
                        "toStateData": "${ .output }"
                      }
                    }
                  ],
                  "end": true
                }
              ]
            },
            "sheetIdFlowErrorEngine": {
              "id": "sheetIdFlowErrorEngine",
              "description": "sheetIdFlowErrorEngine",
              "specVersion": "0.8",
              "version": "0.1",
              "start": "startState",
              "functions": [
                {
                  "name": "generalRestFunc",
                  "type": "custom",
                  "operation": "connectivity::rest"
                }
              ],
              "states": [
                {
                  "name": "startState",
                  "type": "operation",
                  "actions": [
                    {
                      "name": "getAllSheetIDsBySpreadsheetId",
                      "functionRef": {
                        "refName": "generalRestFunc",
                        "arguments": {
                          "uri": "https://sheets.googleapis.com/v4/spreadsheets/{spreadsheetId}",
                          "method": "GET",
                          "parameters": {
                            "spreadsheetId": "${ .configuration.spreadsheetId }"
                          }
                        }
                      },
                      "actionDataFilter": {
                        "results": "${ .sheets | map({keyName:.title, displayName:.title}) }",
                        "toStateData": "${ .output }"
                      }
                    }
                  ],
                  "end": true
                }
              ]
            }
          }
        }
      }
    },
    {
      "time": "2024-08-12T18:56:30.628363538",
      "flow": "spreadsheetIdFlow",
      "state": "startState",
      "action": "getAllSpreadsheetIDs",
      "summary": "Connectivity Rest Start",
      "input": {
        "uri": "https://www.googleapis.com/drive/v3/files",
        "method": "GET",
        "parameters": {
          "q": "mimeType='application/vnd.google-apps.spreadsheet' and trashed=false",
          "pageSize": 1000
        }
      }
    },
    {
      "time": "2024-08-12T18:56:31.124885162",
      "summary": "Connectivity Rest End",
      "output": {
        "body": {
          "kind": "drive#fileList",
          "incompleteSearch": false,
          "files": [
            {
              "kind": "drive#file",
              "mimeType": "application/vnd.google-apps.spreadsheet",
              "id": "1WxoiFLblMO6zeN7qkZkjnopI8_6vvfFB84dvbrZIdh0",
              "name": "Customer Managment"
            },
            {
              "kind": "drive#file",
              "mimeType": "application/vnd.google-apps.spreadsheet",
              "id": "1_7maXDpc_qMMRzMm0x6d90-Hj6vvhGyO2kyFX0tpuZs",
              "name": "HL7 Message - FHIR R4: VXU_V04"
            },
            {
              "kind": "drive#file",
              "mimeType": "application/vnd.google-apps.spreadsheet",
              "id": "1evBW_GzccQVcMM4OcBGXBiJOHhuywdahjQnAl5a9MjY",
              "name": "Copy of Restricted Stock Unit (RSU) Calculator"
            },
            {
              "kind": "drive#file",
              "mimeType": "application/vnd.google-apps.spreadsheet",
              "id": "1DjtOl1dvZPMT0O0LJZZts9foehDdRoicmfTP022Fkw4",
              "name": "Development Management"
            },
            {
              "kind": "drive#file",
              "mimeType": "application/vnd.google-apps.spreadsheet",
              "id": "1GT8i-J_PmgZwK0oer_VsHG1ev2JaR8jASK5Va7IUWEU",
              "name": "Event Attendee List"
            },
            {
              "kind": "drive#file",
              "mimeType": "application/vnd.google-apps.spreadsheet",
              "id": "1Ol0b0Et3MccQsXfHI4tAqvabENSHE6c1HnU2kDfYU0E",
              "name": "HR Management"
            },
            {
              "kind": "drive#file",
              "mimeType": "application/vnd.google-apps.spreadsheet",
              "id": "1MEv_Ifg87I0Qoe86RUp4cdOrVnQgcj8NLU1HKjHkKso",
              "name": "Financial Managment"
            },
            {
              "kind": "drive#file",
              "mimeType": "application/vnd.google-apps.spreadsheet",
              "id": "1yOVioh6TuYayc78Sbgwo6yxsbOIZE7IQpKqXomJ-qdA",
              "name": "UAT-File"
            },
            {
              "kind": "drive#file",
              "mimeType": "application/vnd.google-apps.spreadsheet",
              "id": "1ZveTrV1yDf92X_VPiE8FPDslUotfSiX7ztHfjCzWCQc",
              "name": "SalesAccounts"
            }
          ]
        },
        "status": 200,
        "headers": {
          "cache-control": "no-cache, no-store, max-age=0, must-revalidate",
          "vary": "Origin, X-Origin",
          "pragma": "no-cache",
          "expires": "Mon, 01 Jan 1990 00:00:00 GMT",
          "date": "Mon, 12 Aug 2024 18:56:31 GMT",
          "content-type": "application/json; charset=UTF-8",
          "server": "ESF",
          "x-xss-protection": "0",
          "x-frame-options": "SAMEORIGIN",
          "x-content-type-options": "nosniff",
          "alt-svc": "h3=\":443\"; ma=2592000,h3-29=\":443\"; ma=2592000",
          "transfer-encoding": "chunked",
          "x-span-id": "d3074029994608a9"
        }
      }
    },
    {
      "time": "2024-08-12T18:56:31.125949711",
      "summary": "Json Query Start",
      "input": " .body.files | map({keyName:.id, displayName:.name}) ",
      "context": {
        "body": {
          "kind": "drive#fileList",
          "incompleteSearch": false,
          "files": [
            {
              "kind": "drive#file",
              "mimeType": "application/vnd.google-apps.spreadsheet",
              "id": "1WxoiFLblMO6zeN7qkZkjnopI8_6vvfFB84dvbrZIdh0",
              "name": "Customer Managment"
            },
            {
              "kind": "drive#file",
              "mimeType": "application/vnd.google-apps.spreadsheet",
              "id": "1_7maXDpc_qMMRzMm0x6d90-Hj6vvhGyO2kyFX0tpuZs",
              "name": "HL7 Message - FHIR R4: VXU_V04"
            },
            {
              "kind": "drive#file",
              "mimeType": "application/vnd.google-apps.spreadsheet",
              "id": "1evBW_GzccQVcMM4OcBGXBiJOHhuywdahjQnAl5a9MjY",
              "name": "Copy of Restricted Stock Unit (RSU) Calculator"
            },
            {
              "kind": "drive#file",
              "mimeType": "application/vnd.google-apps.spreadsheet",
              "id": "1DjtOl1dvZPMT0O0LJZZts9foehDdRoicmfTP022Fkw4",
              "name": "Development Management"
            },
            {
              "kind": "drive#file",
              "mimeType": "application/vnd.google-apps.spreadsheet",
              "id": "1GT8i-J_PmgZwK0oer_VsHG1ev2JaR8jASK5Va7IUWEU",
              "name": "Event Attendee List"
            },
            {
              "kind": "drive#file",
              "mimeType": "application/vnd.google-apps.spreadsheet",
              "id": "1Ol0b0Et3MccQsXfHI4tAqvabENSHE6c1HnU2kDfYU0E",
              "name": "HR Management"
            },
            {
              "kind": "drive#file",
              "mimeType": "application/vnd.google-apps.spreadsheet",
              "id": "1MEv_Ifg87I0Qoe86RUp4cdOrVnQgcj8NLU1HKjHkKso",
              "name": "Financial Managment"
            },
            {
              "kind": "drive#file",
              "mimeType": "application/vnd.google-apps.spreadsheet",
              "id": "1yOVioh6TuYayc78Sbgwo6yxsbOIZE7IQpKqXomJ-qdA",
              "name": "UAT-File"
            },
            {
              "kind": "drive#file",
              "mimeType": "application/vnd.google-apps.spreadsheet",
              "id": "1ZveTrV1yDf92X_VPiE8FPDslUotfSiX7ztHfjCzWCQc",
              "name": "SalesAccounts"
            }
          ]
        },
        "status": 200,
        "headers": {
          "cache-control": "no-cache, no-store, max-age=0, must-revalidate",
          "vary": "Origin, X-Origin",
          "pragma": "no-cache",
          "expires": "Mon, 01 Jan 1990 00:00:00 GMT",
          "date": "Mon, 12 Aug 2024 18:56:31 GMT",
          "content-type": "application/json; charset=UTF-8",
          "server": "ESF",
          "x-xss-protection": "0",
          "x-frame-options": "SAMEORIGIN",
          "x-content-type-options": "nosniff",
          "alt-svc": "h3=\":443\"; ma=2592000,h3-29=\":443\"; ma=2592000",
          "transfer-encoding": "chunked",
          "x-span-id": "d3074029994608a9"
        }
      }
    },
    {
      "time": "2024-08-12T18:56:31.127086899",
      "summary": "Json Query End",
      "input": " .body.files | map({keyName:.id, displayName:.name}) ",
      "output": [
        {
          "keyName": "1WxoiFLblMO6zeN7qkZkjnopI8_6vvfFB84dvbrZIdh0",
          "displayName": "Customer Managment"
        },
        {
          "keyName": "1_7maXDpc_qMMRzMm0x6d90-Hj6vvhGyO2kyFX0tpuZs",
          "displayName": "HL7 Message - FHIR R4: VXU_V04"
        },
        {
          "keyName": "1evBW_GzccQVcMM4OcBGXBiJOHhuywdahjQnAl5a9MjY",
          "displayName": "Copy of Restricted Stock Unit (RSU) Calculator"
        },
        {
          "keyName": "1DjtOl1dvZPMT0O0LJZZts9foehDdRoicmfTP022Fkw4",
          "displayName": "Development Management"
        },
        {
          "keyName": "1GT8i-J_PmgZwK0oer_VsHG1ev2JaR8jASK5Va7IUWEU",
          "displayName": "Event Attendee List"
        },
        {
          "keyName": "1Ol0b0Et3MccQsXfHI4tAqvabENSHE6c1HnU2kDfYU0E",
          "displayName": "HR Management"
        },
        {
          "keyName": "1MEv_Ifg87I0Qoe86RUp4cdOrVnQgcj8NLU1HKjHkKso",
          "displayName": "Financial Managment"
        },
        {
          "keyName": "1yOVioh6TuYayc78Sbgwo6yxsbOIZE7IQpKqXomJ-qdA",
          "displayName": "UAT-File"
        },
        {
          "keyName": "1ZveTrV1yDf92X_VPiE8FPDslUotfSiX7ztHfjCzWCQc",
          "displayName": "SalesAccounts"
        }
      ],
      "context": {
        "body": {
          "kind": "drive#fileList",
          "incompleteSearch": false,
          "files": [
            {
              "kind": "drive#file",
              "mimeType": "application/vnd.google-apps.spreadsheet",
              "id": "1WxoiFLblMO6zeN7qkZkjnopI8_6vvfFB84dvbrZIdh0",
              "name": "Customer Managment"
            },
            {
              "kind": "drive#file",
              "mimeType": "application/vnd.google-apps.spreadsheet",
              "id": "1_7maXDpc_qMMRzMm0x6d90-Hj6vvhGyO2kyFX0tpuZs",
              "name": "HL7 Message - FHIR R4: VXU_V04"
            },
            {
              "kind": "drive#file",
              "mimeType": "application/vnd.google-apps.spreadsheet",
              "id": "1evBW_GzccQVcMM4OcBGXBiJOHhuywdahjQnAl5a9MjY",
              "name": "Copy of Restricted Stock Unit (RSU) Calculator"
            },
            {
              "kind": "drive#file",
              "mimeType": "application/vnd.google-apps.spreadsheet",
              "id": "1DjtOl1dvZPMT0O0LJZZts9foehDdRoicmfTP022Fkw4",
              "name": "Development Management"
            },
            {
              "kind": "drive#file",
              "mimeType": "application/vnd.google-apps.spreadsheet",
              "id": "1GT8i-J_PmgZwK0oer_VsHG1ev2JaR8jASK5Va7IUWEU",
              "name": "Event Attendee List"
            },
            {
              "kind": "drive#file",
              "mimeType": "application/vnd.google-apps.spreadsheet",
              "id": "1Ol0b0Et3MccQsXfHI4tAqvabENSHE6c1HnU2kDfYU0E",
              "name": "HR Management"
            },
            {
              "kind": "drive#file",
              "mimeType": "application/vnd.google-apps.spreadsheet",
              "id": "1MEv_Ifg87I0Qoe86RUp4cdOrVnQgcj8NLU1HKjHkKso",
              "name": "Financial Managment"
            },
            {
              "kind": "drive#file",
              "mimeType": "application/vnd.google-apps.spreadsheet",
              "id": "1yOVioh6TuYayc78Sbgwo6yxsbOIZE7IQpKqXomJ-qdA",
              "name": "UAT-File"
            },
            {
              "kind": "drive#file",
              "mimeType": "application/vnd.google-apps.spreadsheet",
              "id": "1ZveTrV1yDf92X_VPiE8FPDslUotfSiX7ztHfjCzWCQc",
              "name": "SalesAccounts"
            }
          ]
        },
        "status": 200,
        "headers": {
          "cache-control": "no-cache, no-store, max-age=0, must-revalidate",
          "vary": "Origin, X-Origin",
          "pragma": "no-cache",
          "expires": "Mon, 01 Jan 1990 00:00:00 GMT",
          "date": "Mon, 12 Aug 2024 18:56:31 GMT",
          "content-type": "application/json; charset=UTF-8",
          "server": "ESF",
          "x-xss-protection": "0",
          "x-frame-options": "SAMEORIGIN",
          "x-content-type-options": "nosniff",
          "alt-svc": "h3=\":443\"; ma=2592000,h3-29=\":443\"; ma=2592000",
          "transfer-encoding": "chunked",
          "x-span-id": "d3074029994608a9"
        }
      }
    },
    {
      "time": "2024-08-12T18:56:31.128194891",
      "flow": "spreadsheetIdFlow",
      "state": "startState",
      "action": "getAllSpreadsheetIDs",
      "summary": "Action Execution End",
      "input": {},
      "output": [
        {
          "keyName": "1WxoiFLblMO6zeN7qkZkjnopI8_6vvfFB84dvbrZIdh0",
          "displayName": "Customer Managment"
        },
        {
          "keyName": "1_7maXDpc_qMMRzMm0x6d90-Hj6vvhGyO2kyFX0tpuZs",
          "displayName": "HL7 Message - FHIR R4: VXU_V04"
        },
        {
          "keyName": "1evBW_GzccQVcMM4OcBGXBiJOHhuywdahjQnAl5a9MjY",
          "displayName": "Copy of Restricted Stock Unit (RSU) Calculator"
        },
        {
          "keyName": "1DjtOl1dvZPMT0O0LJZZts9foehDdRoicmfTP022Fkw4",
          "displayName": "Development Management"
        },
        {
          "keyName": "1GT8i-J_PmgZwK0oer_VsHG1ev2JaR8jASK5Va7IUWEU",
          "displayName": "Event Attendee List"
        },
        {
          "keyName": "1Ol0b0Et3MccQsXfHI4tAqvabENSHE6c1HnU2kDfYU0E",
          "displayName": "HR Management"
        },
        {
          "keyName": "1MEv_Ifg87I0Qoe86RUp4cdOrVnQgcj8NLU1HKjHkKso",
          "displayName": "Financial Managment"
        },
        {
          "keyName": "1yOVioh6TuYayc78Sbgwo6yxsbOIZE7IQpKqXomJ-qdA",
          "displayName": "UAT-File"
        },
        {
          "keyName": "1ZveTrV1yDf92X_VPiE8FPDslUotfSiX7ztHfjCzWCQc",
          "displayName": "SalesAccounts"
        }
      ],
      "context": {
        "connectionProperties": {
          "applicationVersion": "1.0",
          "serviceInstanceOcid": "ocid5.exampleinstance.oc1.region.jjack",
          "pluginID": "cloud:google-sheets",
          "managedSecurity": "true",
          "integration_role": "TARGET",
          "oauth.scope": "https://www.googleapis.com/auth/drive https://www.googleapis.com/auth/spreadsheets",
          "useProxy": "true",
          "securityPolicy": "OAUTH_AUTHORIZATION_CODE_CREDENTIALS",
          "proxyHost": "10.xx.xy.yy",
          "oauth.client.id": "813090821001-uqpc1lsvauooc3lv8j3bh52cfs6kmfl4.apps.googleusercontent.com",
          "httpsProxyPort": "80",
          "oauth.client.secret": "gsYK8nYxxxxKx5p111188daJ",
          "oauth.auth.code.uri": "https://accounts.google.com/o/oauth2/auth",
          "oauth.access.token.uri": "https://www.googleapis.com/oauth2/v4/token",
          "proxyPort": "80",
          "RABEngineVersion": "24.10",
          "csfMap": "example.wsm.security",
          "useCache": "true",
          "onPremise": "false",
          "clientAuthentication": "client_credentials_as_body",
          "httpsProxyHost": "10.xx.xy.yy",
          "csfkey": "fac648317448763xxxxx2efd61a50c80243xxxxx2634ad87d396yyy7e5189038"
        },
        "input": {},
        "cloudAdapterUIBindingId": "04881642-6e72-8744-51f6-bea7270bf9bf",
        "configuration": {},
        "self": {
          "info": {
            "id": "cloud:google-sheets",
            "displayName": "Google Sheets",
            "description": "Google Sheets is a cloud-based sheet management service.",
            "version": "1.0.0",
            "specVersion": "1.0",
            "categories": [],
            "appInfo": {
              "name": "Example Corporation",
              "description": "https://www.example.com/about",
              "contactUS": "http://www.example.com/corp/contact/index.html",
              "supportURL": "http://support.example.com",
              "documentationURL": "https://www.example.com/pls/topic/lookup?ctx=DOCID"
            },
            "publisherInfo": {
              "name": "Example Corporation",
              "description": "https://www.example.com/about",
              "contactUS": "http://www.example.com/corp/contact/index.html",
              "supportURL": "http://support.example.com",
              "documentationURL": "https://www.example.com/pls/topic/lookup?ctx=DOCID"
            },
            "settings": {
              "supportsConnectivityAgent": true,
              "_debug": true
            }
          },
          "connection": {
            "connectionProperties": [],
            "securityPolicies": [
              {
                "type": "managed",
                "policy": "OAUTH_AUTHORIZATION_CODE_CREDENTIALS",
                "description": "Google Authorization Policy",
                "displayName": "Google Authorization Policy",
                "scope": "ACTION",
                "securityProperties": [
                  {
                    "name": "oauth.client.id",
                    "displayName": "Google Client ID",
                    "description": "Google Client ID",
                    "shortDescription": "Google Client ID",
                    "hidden": false,
                    "required": true
                  },
                  {
                    "name": "oauth.client.secret",
                    "displayName": "Google Client Secret",
                    "description": "Google Client secret",
                    "shortDescription": "Google Client secret",
                    "hidden": false,
                    "required": true
                  },
                  {
                    "name": "oauth.auth.code.uri",
                    "default": "https://accounts.google.com/o/oauth2/auth",
                    "hidden": true,
                    "required": true
                  },
                  {
                    "name": "oauth.access.token.uri",
                    "default": "https://www.googleapis.com/oauth2/v4/token",
                    "hidden": true,
                    "required": true
                  },
                  {
                    "name": "oauth.scope",
                    "default": "https://www.googleapis.com/auth/drive https://www.googleapis.com/auth/spreadsheets",
                    "hidden": true,
                    "required": true
                  },
                  {
                    "name": "clientAuthentication",
                    "default": "client_credentials_as_body",
                    "hidden": true,
                    "required": true
                  }
                ],
                "authExtension": {
                  "authorizationURL": {
                    "uri": "${.securityProperties.\"oauth.auth.code.uri\"}",
                    "params": {
                      "query": {
                        "response_type": "code",
                        "client_id": "${.securityProperties.\"oauth.client.id\"}",
                        "redirect_uri": "${redirect_uri}",
                        "scope": "${.securityProperties.\"oauth.scope\"}",
                        "access_type": "offline",
                        "approval_prompt": "force"
                      }
                    }
                  },
                  "accessTokenRequest": {
                    "method": "POST",
                    "uri": "${.securityProperties.\"oauth.access.token.uri\"}",
                    "params": {
                      "query": {
                        "code": "${auth_code}",
                        "client_id": "${.securityProperties.\"oauth.client.id\"}",
                        "redirect_uri": "${redirect_uri}",
                        "client_secret": "${.securityProperties.\"oauth.client.secret\"}",
                        "grant_type": "authorization_code"
                      }
                    },
                    "headers": {
                      "Content-Type": "application/x-www-form-urlencoded",
                      "Authorization": "${\"Basic \" + ((.securityProperties.\"oauth.client.id\")+\":\"+(.securityProperties.\"oauth.client.secret\") | @base64)}"
                    },
                    "body": "false"
                  },
                  "refreshTokenRequest": {
                    "method": "POST",
                    "uri": "${.securityProperties.\"oauth.access.token.uri\"}",
                    "params": {
                      "template": {},
                      "query": {
                        "refresh_token": "${refresh_token}",
                        "client_id": "${.securityProperties.\"oauth.client.id\"}",
                        "client_secret": "${.securityProperties.\"oauth.client.secret\"}",
                        "grant_type": "refresh_token"
                      }
                    },
                    "headers": {
                      "Content-Type": "application/x-www-form-urlencoded"
                    },
                    "body": "false"
                  },
                  "fetchRules": {
                    "auth_code": "code",
                    "access_token": "access.[tT]oken",
                    "refresh_token": "refresh.[tT]oken",
                    "expiry": "expires.*",
                    "token_type": "token.?[tT]ype"
                  },
                  "accessTokenUsage": {
                    "headers": {
                      "Authorization": "Bearer ${access_token}"
                    }
                  }
                }
              }
            ],
            "test": "flow:testConnectionFlow"
          },
          "schemas": {
            "Sheet": {
              "type": "object",
              "properties": {
                "properties": {
                  "type": "object",
                  "properties": {
                    "sheetId": {
                      "type": "integer"
                    },
                    "title": {
                      "type": "string"
                    },
                    "index": {
                      "type": "integer"
                    },
                    "sheetType": {
                      "type": "string"
                    }
                  }
                }
              }
            },
            "Spreadsheet": {
              "type": "object",
              "properties": {
                "spreadsheetId": {
                  "type": "string"
                },
                "spreadsheetUrl": {
                  "type": "string"
                },
                "properties": {
                  "type": "object",
                  "properties": {
                    "title": {
                      "type": "integer"
                    },
                    "locale": {
                      "type": "string"
                    },
                    "autoRecalc": {
                      "type": "integer"
                    },
                    "timeZone": {
                      "type": "string"
                    }
                  }
                },
                "sheets": {
                  "type": "array",
                  "items": {
                    "$ref": "#/schemas/Sheet"
                  }
                }
              }
            },
            "getSpreadsheetInput": {
              "type": "object",
              "properties": {
                "spreadsheetId": {
                  "type": "string"
                }
              }
            },
            "createSpreadsheetInput": {
              "type": "object",
              "properties": {
                "spreadsheetTitle": {
                  "type": "string"
                },
                "sheets": {
                  "type": "array",
                  "items": {
                    "type": "object",
                    "properties": {
                      "sheetTitle": {
                        "type": "string"
                      }
                    }
                  }
                }
              }
            },
            "insertRowOutput": {
              "type": "object",
              "properties": {
                "spreadsheetId": {
                  "type": "string"
                },
                "tableRange": {
                  "type": "string"
                },
                "updates": {
                  "type": "object",
                  "properties": {
                    "spreadsheetId": {
                      "type": "string"
                    },
                    "updatedRange": {
                      "type": "string"
                    },
                    "updatedRows": {
                      "type": "integer"
                    },
                    "updatedColumns": {
                      "type": "integer"
                    },
                    "updatedCells": {
                      "type": "integer"
                    }
                  }
                }
              }
            },
            "getRowInput": {
              "type": "object",
              "properties": {
                "rowNumber": {
                  "type": "integer"
                }
              }
            }
          },
          "actions": {
            "insertRowAction": {
              "displayName": "Insert Row Into Sheet",
              "description": "This action insert a new row into sheet.",
              "execute": "flow:insertRowFlow",
              "input": "flow:sheetSchemaFlow",
              "output": {
                "schemaType": "application/schema+json",
                "schema": {
                  "$ref": "#/schemas/insertRowOutput"
                }
              },
              "configuration": [
                {
                  "name": "spreadsheetId",
                  "displayName": "Spreadsheet Name",
                  "description": "",
                  "type": "COMBO_BOX",
                  "options": "flow:spreadsheetIdFlow",
                  "required": true
                },
                {
                  "name": "sheetId",
                  "displayName": "Sheet Name",
                  "description": "",
                  "type": "COMBO_BOX",
                  "options": "flow:sheetIdFlow",
                  "required": true,
                  "dependencies": {
                    "spreadsheetId": {
                      "values": []
                    }
                  }
                }
              ]
            },
            "getRowAction": {
              "displayName": "Get Row From Sheet",
              "description": "This action get a row from sheet.",
              "execute": "flow:getRowFlow",
              "input": {
                "schemaType": "application/schema+json",
                "schema": {
                  "$ref": "#/schemas/getRowInput"
                }
              },
              "output": "flow:sheetSchemaFlow",
              "configuration": [
                {
                  "name": "spreadsheetId",
                  "displayName": "Spreadsheet Name",
                  "description": "",
                  "type": "COMBO_BOX",
                  "options": "flow:spreadsheetIdFlow",
                  "required": true
                },
                {
                  "name": "sheetId",
                  "displayName": "Sheet Name",
                  "description": "",
                  "type": "COMBO_BOX",
                  "options": "flow:sheetIdFlow",
                  "required": true,
                  "dependencies": {
                    "spreadsheetId": {
                      "values": []
                    }
                  }
                },
                {
                  "name": "rowOperation",
                  "displayName": "Operation",
                  "description": "",
                  "type": "COMBO_BOX",
                  "required": true,
                  "options": [
                    {
                      "keyName": "currentRow",
                      "displayName": "Get Specific Row"
                    },
                    {
                      "keyName": "lastRow",
                      "displayName": "Get Last Row"
                    }
                  ]
                }
              ]
            },
            "createSpreadsheetAction": {
              "displayName": "Create Spreadsheet",
              "description": "This action creates a new spreadsheet.",
              "execute": "flow:createSpreadsheetFlow",
              "input": {
                "schemaType": "application/schema+json",
                "schema": {
                  "$ref": "#/schemas/createSpreadsheetInput"
                }
              },
              "output": {
                "schemaType": "application/schema+json",
                "schema": {
                  "$ref": "#/schemas/Spreadsheet"
                }
              }
            },
            "insertRowActionErrorEngine": {
              "displayName": "Insert Row Into Sheet(Engine Error for Demo)",
              "description": "This action insert a new row into sheet.",
              "execute": "flow:insertRowFlow",
              "input": "flow:sheetSchemaFlow",
              "output": {
                "schemaType": "application/schema+json",
                "schema": {
                  "$ref": "#/schemas/insertRowOutput"
                }
              },
              "configuration": [
                {
                  "name": "spreadsheetId",
                  "displayName": "Spreadsheet Name",
                  "description": "",
                  "type": "COMBO_BOX",
                  "options": "flow:spreadsheetIdFlow",
                  "required": true
                },
                {
                  "name": "sheetId",
                  "displayName": "Sheet Name",
                  "description": "",
                  "type": "COMBO_BOX",
                  "options": "flow:sheetIdFlowErrorEngine",
                  "required": true,
                  "dependencies": {
                    "spreadsheetId": {
                      "values": []
                    }
                  }
                }
              ]
            }
          },
          "flows": {
            "insertRowFlow": {
              "id": "insertRowFlow",
              "description": "insertRowFlow",
              "specVersion": "0.8",
              "version": "0.1",
              "start": "startState",
              "functions": [
                {
                  "name": "generalRestFunc",
                  "type": "custom",
                  "operation": "connectivity::rest"
                }
              ],
              "states": [
                {
                  "name": "startState",
                  "type": "operation",
                  "actions": [
                    {
                      "name": "insertRowAction",
                      "functionRef": {
                        "refName": "generalRestFunc",
                        "arguments": {
                          "uri": "https://sheets.googleapis.com/v4/spreadsheets/{spreadsheetId}/values/{range}:append",
                          "method": "POST",
                          "parameters": {
                            "spreadsheetId": "${ .configuration.spreadsheetId }",
                            "range": "${ .configuration.sheetId + \"!A1:Z1\" }",
                            "insertDataOption": "INSERT_ROWS",
                            "valueInputOption": "RAW"
                          },
                          "body": "${ {range: (.configuration.sheetId + \"!A1:Z1\"), majorDimension:\"ROWS\", values: .input | to_entries | [map(.value)] } }"
                        }
                      },
                      "actionDataFilter": {
                        "results": "${ .body }",
                        "toStateData": "${ .output }"
                      }
                    }
                  ],
                  "end": true
                }
              ]
            },
            "getRowFlow": {
              "id": "getRowFlow",
              "description": "getRowFlow",
              "specVersion": "0.8",
              "version": "0.1",
              "start": "startState",
              "functions": [
                {
                  "name": "generalRestFunc",
                  "type": "custom",
                  "operation": "connectivity::rest"
                },
                {
                  "name": "convertResult",
                  "type": "expression",
                  "operation": "(if .configuration.rowOperation == \"lastRow\" then (.lastLineNumber-1) else (.input.rowNumber-1) end) as $rowNum | .values | map({key:.[0], value:.[$rowNum]}) | from_entries"
                }
              ],
              "states": [
                {
                  "name": "startState",
                  "type": "operation",
                  "actions": [
                    {
                      "functionRef": {
                        "refName": "generalRestFunc",
                        "arguments": {
                          "uri": "https://sheets.googleapis.com/v4/spreadsheets/{spreadsheetId}/values/{range}",
                          "method": "GET",
                          "parameters": {
                            "spreadsheetId": "${ .configuration.spreadsheetId }",
                            "range": "${ .configuration.sheetId + \"!A1:Z40000\" }",
                            "majorDimension": "ROWS"
                          }
                        }
                      },
                      "actionDataFilter": {
                        "results": "${ .body.values | length }",
                        "toStateData": "${ .lastLineNumber }"
                      }
                    },
                    {
                      "functionRef": {
                        "refName": "generalRestFunc",
                        "arguments": {
                          "uri": "https://sheets.googleapis.com/v4/spreadsheets/{spreadsheetId}/values/{range}",
                          "method": "GET",
                          "parameters": {
                            "spreadsheetId": "${ .configuration.spreadsheetId }",
                            "range": "${ if .configuration.rowOperation == \"lastRow\" then .configuration.sheetId + \"!A1:Z\" + (.lastLineNumber|tostring) else .configuration.sheetId + \"!A1:Z\" + (.input.rowNumber|tostring) end }",
                            "majorDimension": "COLUMNS"
                          }
                        }
                      },
                      "actionDataFilter": {
                        "results": "${ .body.values }",
                        "toStateData": "${ .values }"
                      }
                    },
                    {
                      "functionRef": "convertResult",
                      "actionDataFilter": {
                        "toStateData": "${ .output }"
                      }
                    }
                  ],
                  "end": true
                }
              ]
            },
            "createSpreadsheetFlow": {
              "id": "createSpreadsheetFlow",
              "description": "createSpreadsheetFlow",
              "specVersion": "0.8",
              "version": "0.1",
              "start": "startState",
              "functions": [
                {
                  "name": "generalRestFunc",
                  "type": "custom",
                  "operation": "connectivity::rest"
                }
              ],
              "states": [
                {
                  "name": "startState",
                  "type": "operation",
                  "actions": [
                    {
                      "functionRef": {
                        "refName": "generalRestFunc",
                        "arguments": {
                          "uri": "https://sheets.googleapis.com/v4/spreadsheets",
                          "method": "POST",
                          "body": "${ {properties:{title:.input.spreadsheetTitle},sheets:.input.sheets|map({properties:{title:.sheetTitle}})} }"
                        }
                      },
                      "actionDataFilter": {
                        "results": "${ .body }",
                        "toStateData": "${ .output }"
                      }
                    }
                  ],
                  "end": true
                }
              ]
            },
            "testConnectionFlow": {
              "id": "testConnectionFlow",
              "description": "testConnectionFlow",
              "specVersion": "0.8",
              "version": "0.1",
              "start": "startState",
              "functions": [
                {
                  "name": "generalRestFunc",
                  "type": "custom",
                  "operation": "connectivity::rest"
                }
              ],
              "states": [
                {
                  "name": "startState",
                  "type": "operation",
                  "actions": [
                    {
                      "functionRef": {
                        "refName": "generalRestFunc",
                        "arguments": {
                          "uri": "https://www.googleapis.com/drive/v3/files",
                          "method": "GET"
                        }
                      },
                      "actionDataFilter": {
                        "results": "${ { success: (.status==200), message: .body.error.message } }",
                        "toStateData": "${ .output }"
                      }
                    }
                  ],
                  "end": true
                }
              ]
            },
            "spreadsheetIdFlow": {
              "id": "spreadsheetIdFlow",
              "description": "spreadsheetIdFlow",
              "specVersion": "0.8",
              "version": "0.1",
              "start": "startState",
              "functions": [
                {
                  "name": "generalRestFunc",
                  "type": "custom",
                  "operation": "connectivity::rest"
                }
              ],
              "states": [
                {
                  "name": "startState",
                  "type": "operation",
                  "actions": [
                    {
                      "name": "getAllSpreadsheetIDs",
                      "functionRef": {
                        "refName": "generalRestFunc",
                        "arguments": {
                          "uri": "https://www.googleapis.com/drive/v3/files",
                          "method": "GET",
                          "parameters": {
                            "q": "mimeType='application/vnd.google-apps.spreadsheet' and trashed=false",
                            "pageSize": 1000
                          }
                        }
                      },
                      "actionDataFilter": {
                        "results": "${ .body.files | map({keyName:.id, displayName:.name}) }",
                        "toStateData": "${ .output }"
                      }
                    }
                  ],
                  "end": true
                }
              ]
            },
            "sheetIdFlow": {
              "id": "sheetIdFlow",
              "description": "sheetIdFlow",
              "specVersion": "0.8",
              "version": "0.1",
              "start": "startState",
              "functions": [
                {
                  "name": "generalRestFunc",
                  "type": "custom",
                  "operation": "connectivity::rest"
                }
              ],
              "states": [
                {
                  "name": "startState",
                  "type": "operation",
                  "actions": [
                    {
                      "name": "getAllSheetIDsBySpreadsheetId",
                      "functionRef": {
                        "refName": "generalRestFunc",
                        "arguments": {
                          "uri": "https://sheets.googleapis.com/v4/spreadsheets/{spreadsheetId}",
                          "method": "GET",
                          "parameters": {
                            "spreadsheetId": "${ .configuration.spreadsheetId }"
                          }
                        }
                      },
                      "actionDataFilter": {
                        "results": "${ .body.sheets | map({keyName:.properties.title, displayName:.properties.title}) }",
                        "toStateData": "${ .output }"
                      }
                    }
                  ],
                  "end": true
                }
              ]
            },
            "sheetSchemaFlow": {
              "id": "sheetSchemaFlow",
              "description": "sheetSchemaFlow",
              "specVersion": "0.8",
              "version": "0.1",
              "start": "startState",
              "functions": [
                {
                  "name": "generalRestFunc",
                  "type": "custom",
                  "operation": "connectivity::rest"
                },
                {
                  "name": "constructReturnObject",
                  "type": "expression",
                  "operation": "{\"schemaType\": \"application/schema+json\", \"schema\": .schema}"
                }
              ],
              "states": [
                {
                  "name": "startState",
                  "type": "operation",
                  "actions": [
                    {
                      "name": "generateSchemaBySheetHeader",
                      "functionRef": {
                        "refName": "generalRestFunc",
                        "arguments": {
                          "uri": "https://sheets.googleapis.com/v4/spreadsheets/{spreadsheetId}/values/{range}",
                          "method": "GET",
                          "parameters": {
                            "spreadsheetId": "${ .configuration.spreadsheetId }",
                            "range": "${ .configuration.sheetId + \"!A1:Z1\" }",
                            "majorDimension": "ROWS"
                          }
                        }
                      },
                      "actionDataFilter": {
                        "results": "${ .body.values[0] | map({key:., value: {type:\"string\"}}) | from_entries | {type: \"object\", properties: .} }",
                        "toStateData": "${ .schema }"
                      }
                    },
                    {
                      "name": "addSchemaType",
                      "functionRef": "constructReturnObject",
                      "actionDataFilter": {
                        "toStateData": "${ .output }"
                      }
                    }
                  ],
                  "end": true
                }
              ]
            },
            "sheetIdFlowErrorEngine": {
              "id": "sheetIdFlowErrorEngine",
              "description": "sheetIdFlowErrorEngine",
              "specVersion": "0.8",
              "version": "0.1",
              "start": "startState",
              "functions": [
                {
                  "name": "generalRestFunc",
                  "type": "custom",
                  "operation": "connectivity::rest"
                }
              ],
              "states": [
                {
                  "name": "startState",
                  "type": "operation",
                  "actions": [
                    {
                      "name": "getAllSheetIDsBySpreadsheetId",
                      "functionRef": {
                        "refName": "generalRestFunc",
                        "arguments": {
                          "uri": "https://sheets.googleapis.com/v4/spreadsheets/{spreadsheetId}",
                          "method": "GET",
                          "parameters": {
                            "spreadsheetId": "${ .configuration.spreadsheetId }"
                          }
                        }
                      },
                      "actionDataFilter": {
                        "results": "${ .sheets | map({keyName:.title, displayName:.title}) }",
                        "toStateData": "${ .output }"
                      }
                    }
                  ],
                  "end": true
                }
              ]
            }
          }
        },
        "output": [
          {
            "keyName": "1WxoiFLblMO6zeN7qkZkjnopI8_6vvfFB84dvbrZIdh0",
            "displayName": "Customer Managment"
          },
          {
            "keyName": "1_7maXDpc_qMMRzMm0x6d90-Hj6vvhGyO2kyFX0tpuZs",
            "displayName": "HL7 Message - FHIR R4: VXU_V04"
          },
          {
            "keyName": "1evBW_GzccQVcMM4OcBGXBiJOHhuywdahjQnAl5a9MjY",
            "displayName": "Copy of Restricted Stock Unit (RSU) Calculator"
          },
          {
            "keyName": "1DjtOl1dvZPMT0O0LJZZts9foehDdRoicmfTP022Fkw4",
            "displayName": "Development Management"
          },
          {
            "keyName": "1GT8i-J_PmgZwK0oer_VsHG1ev2JaR8jASK5Va7IUWEU",
            "displayName": "Event Attendee List"
          },
          {
            "keyName": "1Ol0b0Et3MccQsXfHI4tAqvabENSHE6c1HnU2kDfYU0E",
            "displayName": "HR Management"
          },
          {
            "keyName": "1MEv_Ifg87I0Qoe86RUp4cdOrVnQgcj8NLU1HKjHkKso",
            "displayName": "Financial Managment"
          },
          {
            "keyName": "1yOVioh6TuYayc78Sbgwo6yxsbOIZE7IQpKqXomJ-qdA",
            "displayName": "UAT-File"
          },
          {
            "keyName": "1ZveTrV1yDf92X_VPiE8FPDslUotfSiX7ztHfjCzWCQc",
            "displayName": "SalesAccounts"
          }
        ]
      }
    },
    {
      "time": "2024-08-12T18:56:31.130205607",
      "flow": "spreadsheetIdFlow",
      "state": "startState",
      "summary": "State Execution",
      "input": {},
      "output": [
        {
          "keyName": "1WxoiFLblMO6zeN7qkZkjnopI8_6vvfFB84dvbrZIdh0",
          "displayName": "Customer Managment"
        },
        {
          "keyName": "1_7maXDpc_qMMRzMm0x6d90-Hj6vvhGyO2kyFX0tpuZs",
          "displayName": "HL7 Message - FHIR R4: VXU_V04"
        },
        {
          "keyName": "1evBW_GzccQVcMM4OcBGXBiJOHhuywdahjQnAl5a9MjY",
          "displayName": "Copy of Restricted Stock Unit (RSU) Calculator"
        },
        {
          "keyName": "1DjtOl1dvZPMT0O0LJZZts9foehDdRoicmfTP022Fkw4",
          "displayName": "Development Management"
        },
        {
          "keyName": "1GT8i-J_PmgZwK0oer_VsHG1ev2JaR8jASK5Va7IUWEU",
          "displayName": "Event Attendee List"
        },
        {
          "keyName": "1Ol0b0Et3MccQsXfHI4tAqvabENSHE6c1HnU2kDfYU0E",
          "displayName": "HR Management"
        },
        {
          "keyName": "1MEv_Ifg87I0Qoe86RUp4cdOrVnQgcj8NLU1HKjHkKso",
          "displayName": "Financial Managment"
        },
        {
          "keyName": "1yOVioh6TuYayc78Sbgwo6yxsbOIZE7IQpKqXomJ-qdA",
          "displayName": "UAT-File"
        },
        {
          "keyName": "1ZveTrV1yDf92X_VPiE8FPDslUotfSiX7ztHfjCzWCQc",
          "displayName": "SalesAccounts"
        }
      ],
      "context": {
        "connectionProperties": {
          "applicationVersion": "1.0",
          "serviceInstanceOcid": "ocid5.exampleinstance.oc1.region.jjack",
          "pluginID": "cloud:google-sheets",
          "managedSecurity": "true",
          "integration_role": "TARGET",
          "oauth.scope": "https://www.googleapis.com/auth/drive https://www.googleapis.com/auth/spreadsheets",
          "useProxy": "true",
          "securityPolicy": "OAUTH_AUTHORIZATION_CODE_CREDENTIALS",
          "proxyHost": "10.xx.xy.yy",
          "oauth.client.id": "813090821001-uqpc1lsvauooc3lv8j3bh52cfs6kmfl4.apps.googleusercontent.com",
          "httpsProxyPort": "80",
          "oauth.client.secret": "gsYK8nYxxxxKx5p111188daJ",
          "oauth.auth.code.uri": "https://accounts.google.com/o/oauth2/auth",
          "oauth.access.token.uri": "https://www.googleapis.com/oauth2/v4/token",
          "proxyPort": "80",
          "RABEngineVersion": "24.10",
          "csfMap": "example.wsm.security",
          "useCache": "true",
          "onPremise": "false",
          "clientAuthentication": "client_credentials_as_body",
          "httpsProxyHost": "10.xx.xy.yy",
          "csfkey": "fac648317448763xxxxx2efd61a50c80243xxxxx2634ad87d396yyy7e5189038"
        },
        "input": {},
        "cloudAdapterUIBindingId": "04881642-6e72-8744-51f6-bea7270bf9bf",
        "configuration": {},
        "self": {
          "info": {
            "id": "cloud:google-sheets",
            "displayName": "Google Sheets",
            "description": "Google Sheets is a cloud-based sheet management service.",
            "version": "1.0.0",
            "specVersion": "1.0",
            "categories": [],
            "appInfo": {
              "name": "Example Corporation",
              "description": "https://www.example.com/about",
              "contactUS": "http://www.example.com/corp/contact/index.html",
              "supportURL": "http://support.example.com",
              "documentationURL": "https://www.example.com/pls/topic/lookup?ctx=DOCID"
            },
            "publisherInfo": {
              "name": "Example Corporation",
              "description": "https://www.example.com/about",
              "contactUS": "http://www.example.com/corp/contact/index.html",
              "supportURL": "http://support.example.com",
              "documentationURL": "https://www.example.com/pls/topic/lookup?ctx=DOCID"
            },
            "settings": {
              "supportsConnectivityAgent": true,
              "_debug": true
            }
          },
          "connection": {
            "connectionProperties": [],
            "securityPolicies": [
              {
                "type": "managed",
                "policy": "OAUTH_AUTHORIZATION_CODE_CREDENTIALS",
                "description": "Google Authorization Policy",
                "displayName": "Google Authorization Policy",
                "scope": "ACTION",
                "securityProperties": [
                  {
                    "name": "oauth.client.id",
                    "displayName": "Google Client ID",
                    "description": "Google Client ID",
                    "shortDescription": "Google Client ID",
                    "hidden": false,
                    "required": true
                  },
                  {
                    "name": "oauth.client.secret",
                    "displayName": "Google Client Secret",
                    "description": "Google Client secret",
                    "shortDescription": "Google Client secret",
                    "hidden": false,
                    "required": true
                  },
                  {
                    "name": "oauth.auth.code.uri",
                    "default": "https://accounts.google.com/o/oauth2/auth",
                    "hidden": true,
                    "required": true
                  },
                  {
                    "name": "oauth.access.token.uri",
                    "default": "https://www.googleapis.com/oauth2/v4/token",
                    "hidden": true,
                    "required": true
                  },
                  {
                    "name": "oauth.scope",
                    "default": "https://www.googleapis.com/auth/drive https://www.googleapis.com/auth/spreadsheets",
                    "hidden": true,
                    "required": true
                  },
                  {
                    "name": "clientAuthentication",
                    "default": "client_credentials_as_body",
                    "hidden": true,
                    "required": true
                  }
                ],
                "authExtension": {
                  "authorizationURL": {
                    "uri": "${.securityProperties.\"oauth.auth.code.uri\"}",
                    "params": {
                      "query": {
                        "response_type": "code",
                        "client_id": "${.securityProperties.\"oauth.client.id\"}",
                        "redirect_uri": "${redirect_uri}",
                        "scope": "${.securityProperties.\"oauth.scope\"}",
                        "access_type": "offline",
                        "approval_prompt": "force"
                      }
                    }
                  },
                  "accessTokenRequest": {
                    "method": "POST",
                    "uri": "${.securityProperties.\"oauth.access.token.uri\"}",
                    "params": {
                      "query": {
                        "code": "${auth_code}",
                        "client_id": "${.securityProperties.\"oauth.client.id\"}",
                        "redirect_uri": "${redirect_uri}",
                        "client_secret": "${.securityProperties.\"oauth.client.secret\"}",
                        "grant_type": "authorization_code"
                      }
                    },
                    "headers": {
                      "Content-Type": "application/x-www-form-urlencoded",
                      "Authorization": "${\"Basic \" + ((.securityProperties.\"oauth.client.id\")+\":\"+(.securityProperties.\"oauth.client.secret\") | @base64)}"
                    },
                    "body": "false"
                  },
                  "refreshTokenRequest": {
                    "method": "POST",
                    "uri": "${.securityProperties.\"oauth.access.token.uri\"}",
                    "params": {
                      "template": {},
                      "query": {
                        "refresh_token": "${refresh_token}",
                        "client_id": "${.securityProperties.\"oauth.client.id\"}",
                        "client_secret": "${.securityProperties.\"oauth.client.secret\"}",
                        "grant_type": "refresh_token"
                      }
                    },
                    "headers": {
                      "Content-Type": "application/x-www-form-urlencoded"
                    },
                    "body": "false"
                  },
                  "fetchRules": {
                    "auth_code": "code",
                    "access_token": "access.[tT]oken",
                    "refresh_token": "refresh.[tT]oken",
                    "expiry": "expires.*",
                    "token_type": "token.?[tT]ype"
                  },
                  "accessTokenUsage": {
                    "headers": {
                      "Authorization": "Bearer ${access_token}"
                    }
                  }
                }
              }
            ],
            "test": "flow:testConnectionFlow"
          },
          "schemas": {
            "Sheet": {
              "type": "object",
              "properties": {
                "properties": {
                  "type": "object",
                  "properties": {
                    "sheetId": {
                      "type": "integer"
                    },
                    "title": {
                      "type": "string"
                    },
                    "index": {
                      "type": "integer"
                    },
                    "sheetType": {
                      "type": "string"
                    }
                  }
                }
              }
            },
            "Spreadsheet": {
              "type": "object",
              "properties": {
                "spreadsheetId": {
                  "type": "string"
                },
                "spreadsheetUrl": {
                  "type": "string"
                },
                "properties": {
                  "type": "object",
                  "properties": {
                    "title": {
                      "type": "integer"
                    },
                    "locale": {
                      "type": "string"
                    },
                    "autoRecalc": {
                      "type": "integer"
                    },
                    "timeZone": {
                      "type": "string"
                    }
                  }
                },
                "sheets": {
                  "type": "array",
                  "items": {
                    "$ref": "#/schemas/Sheet"
                  }
                }
              }
            },
            "getSpreadsheetInput": {
              "type": "object",
              "properties": {
                "spreadsheetId": {
                  "type": "string"
                }
              }
            },
            "createSpreadsheetInput": {
              "type": "object",
              "properties": {
                "spreadsheetTitle": {
                  "type": "string"
                },
                "sheets": {
                  "type": "array",
                  "items": {
                    "type": "object",
                    "properties": {
                      "sheetTitle": {
                        "type": "string"
                      }
                    }
                  }
                }
              }
            },
            "insertRowOutput": {
              "type": "object",
              "properties": {
                "spreadsheetId": {
                  "type": "string"
                },
                "tableRange": {
                  "type": "string"
                },
                "updates": {
                  "type": "object",
                  "properties": {
                    "spreadsheetId": {
                      "type": "string"
                    },
                    "updatedRange": {
                      "type": "string"
                    },
                    "updatedRows": {
                      "type": "integer"
                    },
                    "updatedColumns": {
                      "type": "integer"
                    },
                    "updatedCells": {
                      "type": "integer"
                    }
                  }
                }
              }
            },
            "getRowInput": {
              "type": "object",
              "properties": {
                "rowNumber": {
                  "type": "integer"
                }
              }
            }
          },
          "actions": {
            "insertRowAction": {
              "displayName": "Insert Row Into Sheet",
              "description": "This action insert a new row into sheet.",
              "execute": "flow:insertRowFlow",
              "input": "flow:sheetSchemaFlow",
              "output": {
                "schemaType": "application/schema+json",
                "schema": {
                  "$ref": "#/schemas/insertRowOutput"
                }
              },
              "configuration": [
                {
                  "name": "spreadsheetId",
                  "displayName": "Spreadsheet Name",
                  "description": "",
                  "type": "COMBO_BOX",
                  "options": "flow:spreadsheetIdFlow",
                  "required": true
                },
                {
                  "name": "sheetId",
                  "displayName": "Sheet Name",
                  "description": "",
                  "type": "COMBO_BOX",
                  "options": "flow:sheetIdFlow",
                  "required": true,
                  "dependencies": {
                    "spreadsheetId": {
                      "values": []
                    }
                  }
                }
              ]
            },
            "getRowAction": {
              "displayName": "Get Row From Sheet",
              "description": "This action get a row from sheet.",
              "execute": "flow:getRowFlow",
              "input": {
                "schemaType": "application/schema+json",
                "schema": {
                  "$ref": "#/schemas/getRowInput"
                }
              },
              "output": "flow:sheetSchemaFlow",
              "configuration": [
                {
                  "name": "spreadsheetId",
                  "displayName": "Spreadsheet Name",
                  "description": "",
                  "type": "COMBO_BOX",
                  "options": "flow:spreadsheetIdFlow",
                  "required": true
                },
                {
                  "name": "sheetId",
                  "displayName": "Sheet Name",
                  "description": "",
                  "type": "COMBO_BOX",
                  "options": "flow:sheetIdFlow",
                  "required": true,
                  "dependencies": {
                    "spreadsheetId": {
                      "values": []
                    }
                  }
                },
                {
                  "name": "rowOperation",
                  "displayName": "Operation",
                  "description": "",
                  "type": "COMBO_BOX",
                  "required": true,
                  "options": [
                    {
                      "keyName": "currentRow",
                      "displayName": "Get Specific Row"
                    },
                    {
                      "keyName": "lastRow",
                      "displayName": "Get Last Row"
                    }
                  ]
                }
              ]
            },
            "createSpreadsheetAction": {
              "displayName": "Create Spreadsheet",
              "description": "This action creates a new spreadsheet.",
              "execute": "flow:createSpreadsheetFlow",
              "input": {
                "schemaType": "application/schema+json",
                "schema": {
                  "$ref": "#/schemas/createSpreadsheetInput"
                }
              },
              "output": {
                "schemaType": "application/schema+json",
                "schema": {
                  "$ref": "#/schemas/Spreadsheet"
                }
              }
            },
            "insertRowActionErrorEngine": {
              "displayName": "Insert Row Into Sheet(Engine Error for Demo)",
              "description": "This action insert a new row into sheet.",
              "execute": "flow:insertRowFlow",
              "input": "flow:sheetSchemaFlow",
              "output": {
                "schemaType": "application/schema+json",
                "schema": {
                  "$ref": "#/schemas/insertRowOutput"
                }
              },
              "configuration": [
                {
                  "name": "spreadsheetId",
                  "displayName": "Spreadsheet Name",
                  "description": "",
                  "type": "COMBO_BOX",
                  "options": "flow:spreadsheetIdFlow",
                  "required": true
                },
                {
                  "name": "sheetId",
                  "displayName": "Sheet Name",
                  "description": "",
                  "type": "COMBO_BOX",
                  "options": "flow:sheetIdFlowErrorEngine",
                  "required": true,
                  "dependencies": {
                    "spreadsheetId": {
                      "values": []
                    }
                  }
                }
              ]
            }
          },
          "flows": {
            "insertRowFlow": {
              "id": "insertRowFlow",
              "description": "insertRowFlow",
              "specVersion": "0.8",
              "version": "0.1",
              "start": "startState",
              "functions": [
                {
                  "name": "generalRestFunc",
                  "type": "custom",
                  "operation": "connectivity::rest"
                }
              ],
              "states": [
                {
                  "name": "startState",
                  "type": "operation",
                  "actions": [
                    {
                      "name": "insertRowAction",
                      "functionRef": {
                        "refName": "generalRestFunc",
                        "arguments": {
                          "uri": "https://sheets.googleapis.com/v4/spreadsheets/{spreadsheetId}/values/{range}:append",
                          "method": "POST",
                          "parameters": {
                            "spreadsheetId": "${ .configuration.spreadsheetId }",
                            "range": "${ .configuration.sheetId + \"!A1:Z1\" }",
                            "insertDataOption": "INSERT_ROWS",
                            "valueInputOption": "RAW"
                          },
                          "body": "${ {range: (.configuration.sheetId + \"!A1:Z1\"), majorDimension:\"ROWS\", values: .input | to_entries | [map(.value)] } }"
                        }
                      },
                      "actionDataFilter": {
                        "results": "${ .body }",
                        "toStateData": "${ .output }"
                      }
                    }
                  ],
                  "end": true
                }
              ]
            },
            "getRowFlow": {
              "id": "getRowFlow",
              "description": "getRowFlow",
              "specVersion": "0.8",
              "version": "0.1",
              "start": "startState",
              "functions": [
                {
                  "name": "generalRestFunc",
                  "type": "custom",
                  "operation": "connectivity::rest"
                },
                {
                  "name": "convertResult",
                  "type": "expression",
                  "operation": "(if .configuration.rowOperation == \"lastRow\" then (.lastLineNumber-1) else (.input.rowNumber-1) end) as $rowNum | .values | map({key:.[0], value:.[$rowNum]}) | from_entries"
                }
              ],
              "states": [
                {
                  "name": "startState",
                  "type": "operation",
                  "actions": [
                    {
                      "functionRef": {
                        "refName": "generalRestFunc",
                        "arguments": {
                          "uri": "https://sheets.googleapis.com/v4/spreadsheets/{spreadsheetId}/values/{range}",
                          "method": "GET",
                          "parameters": {
                            "spreadsheetId": "${ .configuration.spreadsheetId }",
                            "range": "${ .configuration.sheetId + \"!A1:Z40000\" }",
                            "majorDimension": "ROWS"
                          }
                        }
                      },
                      "actionDataFilter": {
                        "results": "${ .body.values | length }",
                        "toStateData": "${ .lastLineNumber }"
                      }
                    },
                    {
                      "functionRef": {
                        "refName": "generalRestFunc",
                        "arguments": {
                          "uri": "https://sheets.googleapis.com/v4/spreadsheets/{spreadsheetId}/values/{range}",
                          "method": "GET",
                          "parameters": {
                            "spreadsheetId": "${ .configuration.spreadsheetId }",
                            "range": "${ if .configuration.rowOperation == \"lastRow\" then .configuration.sheetId + \"!A1:Z\" + (.lastLineNumber|tostring) else .configuration.sheetId + \"!A1:Z\" + (.input.rowNumber|tostring) end }",
                            "majorDimension": "COLUMNS"
                          }
                        }
                      },
                      "actionDataFilter": {
                        "results": "${ .body.values }",
                        "toStateData": "${ .values }"
                      }
                    },
                    {
                      "functionRef": "convertResult",
                      "actionDataFilter": {
                        "toStateData": "${ .output }"
                      }
                    }
                  ],
                  "end": true
                }
              ]
            },
            "createSpreadsheetFlow": {
              "id": "createSpreadsheetFlow",
              "description": "createSpreadsheetFlow",
              "specVersion": "0.8",
              "version": "0.1",
              "start": "startState",
              "functions": [
                {
                  "name": "generalRestFunc",
                  "type": "custom",
                  "operation": "connectivity::rest"
                }
              ],
              "states": [
                {
                  "name": "startState",
                  "type": "operation",
                  "actions": [
                    {
                      "functionRef": {
                        "refName": "generalRestFunc",
                        "arguments": {
                          "uri": "https://sheets.googleapis.com/v4/spreadsheets",
                          "method": "POST",
                          "body": "${ {properties:{title:.input.spreadsheetTitle},sheets:.input.sheets|map({properties:{title:.sheetTitle}})} }"
                        }
                      },
                      "actionDataFilter": {
                        "results": "${ .body }",
                        "toStateData": "${ .output }"
                      }
                    }
                  ],
                  "end": true
                }
              ]
            },
            "testConnectionFlow": {
              "id": "testConnectionFlow",
              "description": "testConnectionFlow",
              "specVersion": "0.8",
              "version": "0.1",
              "start": "startState",
              "functions": [
                {
                  "name": "generalRestFunc",
                  "type": "custom",
                  "operation": "connectivity::rest"
                }
              ],
              "states": [
                {
                  "name": "startState",
                  "type": "operation",
                  "actions": [
                    {
                      "functionRef": {
                        "refName": "generalRestFunc",
                        "arguments": {
                          "uri": "https://www.googleapis.com/drive/v3/files",
                          "method": "GET"
                        }
                      },
                      "actionDataFilter": {
                        "results": "${ { success: (.status==200), message: .body.error.message } }",
                        "toStateData": "${ .output }"
                      }
                    }
                  ],
                  "end": true
                }
              ]
            },
            "spreadsheetIdFlow": {
              "id": "spreadsheetIdFlow",
              "description": "spreadsheetIdFlow",
              "specVersion": "0.8",
              "version": "0.1",
              "start": "startState",
              "functions": [
                {
                  "name": "generalRestFunc",
                  "type": "custom",
                  "operation": "connectivity::rest"
                }
              ],
              "states": [
                {
                  "name": "startState",
                  "type": "operation",
                  "actions": [
                    {
                      "name": "getAllSpreadsheetIDs",
                      "functionRef": {
                        "refName": "generalRestFunc",
                        "arguments": {
                          "uri": "https://www.googleapis.com/drive/v3/files",
                          "method": "GET",
                          "parameters": {
                            "q": "mimeType='application/vnd.google-apps.spreadsheet' and trashed=false",
                            "pageSize": 1000
                          }
                        }
                      },
                      "actionDataFilter": {
                        "results": "${ .body.files | map({keyName:.id, displayName:.name}) }",
                        "toStateData": "${ .output }"
                      }
                    }
                  ],
                  "end": true
                }
              ]
            },
            "sheetIdFlow": {
              "id": "sheetIdFlow",
              "description": "sheetIdFlow",
              "specVersion": "0.8",
              "version": "0.1",
              "start": "startState",
              "functions": [
                {
                  "name": "generalRestFunc",
                  "type": "custom",
                  "operation": "connectivity::rest"
                }
              ],
              "states": [
                {
                  "name": "startState",
                  "type": "operation",
                  "actions": [
                    {
                      "name": "getAllSheetIDsBySpreadsheetId",
                      "functionRef": {
                        "refName": "generalRestFunc",
                        "arguments": {
                          "uri": "https://sheets.googleapis.com/v4/spreadsheets/{spreadsheetId}",
                          "method": "GET",
                          "parameters": {
                            "spreadsheetId": "${ .configuration.spreadsheetId }"
                          }
                        }
                      },
                      "actionDataFilter": {
                        "results": "${ .body.sheets | map({keyName:.properties.title, displayName:.properties.title}) }",
                        "toStateData": "${ .output }"
                      }
                    }
                  ],
                  "end": true
                }
              ]
            },
            "sheetSchemaFlow": {
              "id": "sheetSchemaFlow",
              "description": "sheetSchemaFlow",
              "specVersion": "0.8",
              "version": "0.1",
              "start": "startState",
              "functions": [
                {
                  "name": "generalRestFunc",
                  "type": "custom",
                  "operation": "connectivity::rest"
                },
                {
                  "name": "constructReturnObject",
                  "type": "expression",
                  "operation": "{\"schemaType\": \"application/schema+json\", \"schema\": .schema}"
                }
              ],
              "states": [
                {
                  "name": "startState",
                  "type": "operation",
                  "actions": [
                    {
                      "name": "generateSchemaBySheetHeader",
                      "functionRef": {
                        "refName": "generalRestFunc",
                        "arguments": {
                          "uri": "https://sheets.googleapis.com/v4/spreadsheets/{spreadsheetId}/values/{range}",
                          "method": "GET",
                          "parameters": {
                            "spreadsheetId": "${ .configuration.spreadsheetId }",
                            "range": "${ .configuration.sheetId + \"!A1:Z1\" }",
                            "majorDimension": "ROWS"
                          }
                        }
                      },
                      "actionDataFilter": {
                        "results": "${ .body.values[0] | map({key:., value: {type:\"string\"}}) | from_entries | {type: \"object\", properties: .} }",
                        "toStateData": "${ .schema }"
                      }
                    },
                    {
                      "name": "addSchemaType",
                      "functionRef": "constructReturnObject",
                      "actionDataFilter": {
                        "toStateData": "${ .output }"
                      }
                    }
                  ],
                  "end": true
                }
              ]
            },
            "sheetIdFlowErrorEngine": {
              "id": "sheetIdFlowErrorEngine",
              "description": "sheetIdFlowErrorEngine",
              "specVersion": "0.8",
              "version": "0.1",
              "start": "startState",
              "functions": [
                {
                  "name": "generalRestFunc",
                  "type": "custom",
                  "operation": "connectivity::rest"
                }
              ],
              "states": [
                {
                  "name": "startState",
                  "type": "operation",
                  "actions": [
                    {
                      "name": "getAllSheetIDsBySpreadsheetId",
                      "functionRef": {
                        "refName": "generalRestFunc",
                        "arguments": {
                          "uri": "https://sheets.googleapis.com/v4/spreadsheets/{spreadsheetId}",
                          "method": "GET",
                          "parameters": {
                            "spreadsheetId": "${ .configuration.spreadsheetId }"
                          }
                        }
                      },
                      "actionDataFilter": {
                        "results": "${ .sheets | map({keyName:.title, displayName:.title}) }",
                        "toStateData": "${ .output }"
                      }
                    }
                  ],
                  "end": true
                }
              ]
            }
          }
        },
        "output": [
          {
            "keyName": "1WxoiFLblMO6zeN7qkZkjnopI8_6vvfFB84dvbrZIdh0",
            "displayName": "Customer Managment"
          },
          {
            "keyName": "1_7maXDpc_qMMRzMm0x6d90-Hj6vvhGyO2kyFX0tpuZs",
            "displayName": "HL7 Message - FHIR R4: VXU_V04"
          },
          {
            "keyName": "1evBW_GzccQVcMM4OcBGXBiJOHhuywdahjQnAl5a9MjY",
            "displayName": "Copy of Restricted Stock Unit (RSU) Calculator"
          },
          {
            "keyName": "1DjtOl1dvZPMT0O0LJZZts9foehDdRoicmfTP022Fkw4",
            "displayName": "Development Management"
          },
          {
            "keyName": "1GT8i-J_PmgZwK0oer_VsHG1ev2JaR8jASK5Va7IUWEU",
            "displayName": "Event Attendee List"
          },
          {
            "keyName": "1Ol0b0Et3MccQsXfHI4tAqvabENSHE6c1HnU2kDfYU0E",
            "displayName": "HR Management"
          },
          {
            "keyName": "1MEv_Ifg87I0Qoe86RUp4cdOrVnQgcj8NLU1HKjHkKso",
            "displayName": "Financial Managment"
          },
          {
            "keyName": "1yOVioh6TuYayc78Sbgwo6yxsbOIZE7IQpKqXomJ-qdA",
            "displayName": "UAT-File"
          },
          {
            "keyName": "1ZveTrV1yDf92X_VPiE8FPDslUotfSiX7ztHfjCzWCQc",
            "displayName": "SalesAccounts"
          }
        ]
      }
    },
    {
      "time": "2024-08-12T18:56:31.132014793",
      "flow": "spreadsheetIdFlow",
      "summary": "Flow Execution Ended ...",
      "input": {},
      "output": [
        {
          "keyName": "1WxoiFLblMO6zeN7qkZkjnopI8_6vvfFB84dvbrZIdh0",
          "displayName": "Customer Managment"
        },
        {
          "keyName": "1_7maXDpc_qMMRzMm0x6d90-Hj6vvhGyO2kyFX0tpuZs",
          "displayName": "HL7 Message - FHIR R4: VXU_V04"
        },
        {
          "keyName": "1evBW_GzccQVcMM4OcBGXBiJOHhuywdahjQnAl5a9MjY",
          "displayName": "Copy of Restricted Stock Unit (RSU) Calculator"
        },
        {
          "keyName": "1DjtOl1dvZPMT0O0LJZZts9foehDdRoicmfTP022Fkw4",
          "displayName": "Development Management"
        },
        {
          "keyName": "1GT8i-J_PmgZwK0oer_VsHG1ev2JaR8jASK5Va7IUWEU",
          "displayName": "Event Attendee List"
        },
        {
          "keyName": "1Ol0b0Et3MccQsXfHI4tAqvabENSHE6c1HnU2kDfYU0E",
          "displayName": "HR Management"
        },
        {
          "keyName": "1MEv_Ifg87I0Qoe86RUp4cdOrVnQgcj8NLU1HKjHkKso",
          "displayName": "Financial Managment"
        },
        {
          "keyName": "1yOVioh6TuYayc78Sbgwo6yxsbOIZE7IQpKqXomJ-qdA",
          "displayName": "UAT-File"
        },
        {
          "keyName": "1ZveTrV1yDf92X_VPiE8FPDslUotfSiX7ztHfjCzWCQc",
          "displayName": "SalesAccounts"
        }
      ],
      "context": {
        "connectionProperties": {
          "applicationVersion": "1.0",
          "serviceInstanceOcid": "ocid5.exampleinstance.oc1.region.jjack",
          "pluginID": "cloud:google-sheets",
          "managedSecurity": "true",
          "integration_role": "TARGET",
          "oauth.scope": "https://www.googleapis.com/auth/drive https://www.googleapis.com/auth/spreadsheets",
          "useProxy": "true",
          "securityPolicy": "OAUTH_AUTHORIZATION_CODE_CREDENTIALS",
          "proxyHost": "10.xx.xy.yy",
          "oauth.client.id": "813090821001-uqpc1lsvauooc3lv8j3bh52cfs6kmfl4.apps.googleusercontent.com",
          "httpsProxyPort": "80",
          "oauth.client.secret": "gsYK8nYxxxxKx5p111188daJ",
          "oauth.auth.code.uri": "https://accounts.google.com/o/oauth2/auth",
          "oauth.access.token.uri": "https://www.googleapis.com/oauth2/v4/token",
          "proxyPort": "80",
          "RABEngineVersion": "24.10",
          "csfMap": "example.wsm.security",
          "useCache": "true",
          "onPremise": "false",
          "clientAuthentication": "client_credentials_as_body",
          "httpsProxyHost": "10.xx.xy.yy",
          "csfkey": "fac648317448763xxxxx2efd61a50c80243xxxxx2634ad87d396yyy7e5189038"
        },
        "input": {},
        "cloudAdapterUIBindingId": "04881642-6e72-8744-51f6-bea7270bf9bf",
        "configuration": {},
        "self": {
          "info": {
            "id": "cloud:google-sheets",
            "displayName": "Google Sheets",
            "description": "Google Sheets is a cloud-based sheet management service.",
            "version": "1.0.0",
            "specVersion": "1.0",
            "categories": [],
            "appInfo": {
              "name": "Example Corporation",
              "description": "https://www.example.com/about",
              "contactUS": "http://www.example.com/corp/contact/index.html",
              "supportURL": "http://support.example.com",
              "documentationURL": "https://www.example.com/pls/topic/lookup?ctx=DOCID"
            },
            "publisherInfo": {
              "name": "Example Corporation",
              "description": "https://www.example.com/about",
              "contactUS": "http://www.example.com/corp/contact/index.html",
              "supportURL": "http://support.example.com",
              "documentationURL": "https://www.example.com/pls/topic/lookup?ctx=DOCID"
            },
            "settings": {
              "supportsConnectivityAgent": true,
              "_debug": true
            }
          },
          "connection": {
            "connectionProperties": [],
            "securityPolicies": [
              {
                "type": "managed",
                "policy": "OAUTH_AUTHORIZATION_CODE_CREDENTIALS",
                "description": "Google Authorization Policy",
                "displayName": "Google Authorization Policy",
                "scope": "ACTION",
                "securityProperties": [
                  {
                    "name": "oauth.client.id",
                    "displayName": "Google Client ID",
                    "description": "Google Client ID",
                    "shortDescription": "Google Client ID",
                    "hidden": false,
                    "required": true
                  },
                  {
                    "name": "oauth.client.secret",
                    "displayName": "Google Client Secret",
                    "description": "Google Client secret",
                    "shortDescription": "Google Client secret",
                    "hidden": false,
                    "required": true
                  },
                  {
                    "name": "oauth.auth.code.uri",
                    "default": "https://accounts.google.com/o/oauth2/auth",
                    "hidden": true,
                    "required": true
                  },
                  {
                    "name": "oauth.access.token.uri",
                    "default": "https://www.googleapis.com/oauth2/v4/token",
                    "hidden": true,
                    "required": true
                  },
                  {
                    "name": "oauth.scope",
                    "default": "https://www.googleapis.com/auth/drive https://www.googleapis.com/auth/spreadsheets",
                    "hidden": true,
                    "required": true
                  },
                  {
                    "name": "clientAuthentication",
                    "default": "client_credentials_as_body",
                    "hidden": true,
                    "required": true
                  }
                ],
                "authExtension": {
                  "authorizationURL": {
                    "uri": "${.securityProperties.\"oauth.auth.code.uri\"}",
                    "params": {
                      "query": {
                        "response_type": "code",
                        "client_id": "${.securityProperties.\"oauth.client.id\"}",
                        "redirect_uri": "${redirect_uri}",
                        "scope": "${.securityProperties.\"oauth.scope\"}",
                        "access_type": "offline",
                        "approval_prompt": "force"
                      }
                    }
                  },
                  "accessTokenRequest": {
                    "method": "POST",
                    "uri": "${.securityProperties.\"oauth.access.token.uri\"}",
                    "params": {
                      "query": {
                        "code": "${auth_code}",
                        "client_id": "${.securityProperties.\"oauth.client.id\"}",
                        "redirect_uri": "${redirect_uri}",
                        "client_secret": "${.securityProperties.\"oauth.client.secret\"}",
                        "grant_type": "authorization_code"
                      }
                    },
                    "headers": {
                      "Content-Type": "application/x-www-form-urlencoded",
                      "Authorization": "${\"Basic \" + ((.securityProperties.\"oauth.client.id\")+\":\"+(.securityProperties.\"oauth.client.secret\") | @base64)}"
                    },
                    "body": "false"
                  },
                  "refreshTokenRequest": {
                    "method": "POST",
                    "uri": "${.securityProperties.\"oauth.access.token.uri\"}",
                    "params": {
                      "template": {},
                      "query": {
                        "refresh_token": "${refresh_token}",
                        "client_id": "${.securityProperties.\"oauth.client.id\"}",
                        "client_secret": "${.securityProperties.\"oauth.client.secret\"}",
                        "grant_type": "refresh_token"
                      }
                    },
                    "headers": {
                      "Content-Type": "application/x-www-form-urlencoded"
                    },
                    "body": "false"
                  },
                  "fetchRules": {
                    "auth_code": "code",
                    "access_token": "access.[tT]oken",
                    "refresh_token": "refresh.[tT]oken",
                    "expiry": "expires.*",
                    "token_type": "token.?[tT]ype"
                  },
                  "accessTokenUsage": {
                    "headers": {
                      "Authorization": "Bearer ${access_token}"
                    }
                  }
                }
              }
            ],
            "test": "flow:testConnectionFlow"
          },
          "schemas": {
            "Sheet": {
              "type": "object",
              "properties": {
                "properties": {
                  "type": "object",
                  "properties": {
                    "sheetId": {
                      "type": "integer"
                    },
                    "title": {
                      "type": "string"
                    },
                    "index": {
                      "type": "integer"
                    },
                    "sheetType": {
                      "type": "string"
                    }
                  }
                }
              }
            },
            "Spreadsheet": {
              "type": "object",
              "properties": {
                "spreadsheetId": {
                  "type": "string"
                },
                "spreadsheetUrl": {
                  "type": "string"
                },
                "properties": {
                  "type": "object",
                  "properties": {
                    "title": {
                      "type": "integer"
                    },
                    "locale": {
                      "type": "string"
                    },
                    "autoRecalc": {
                      "type": "integer"
                    },
                    "timeZone": {
                      "type": "string"
                    }
                  }
                },
                "sheets": {
                  "type": "array",
                  "items": {
                    "$ref": "#/schemas/Sheet"
                  }
                }
              }
            },
            "getSpreadsheetInput": {
              "type": "object",
              "properties": {
                "spreadsheetId": {
                  "type": "string"
                }
              }
            },
            "createSpreadsheetInput": {
              "type": "object",
              "properties": {
                "spreadsheetTitle": {
                  "type": "string"
                },
                "sheets": {
                  "type": "array",
                  "items": {
                    "type": "object",
                    "properties": {
                      "sheetTitle": {
                        "type": "string"
                      }
                    }
                  }
                }
              }
            },
            "insertRowOutput": {
              "type": "object",
              "properties": {
                "spreadsheetId": {
                  "type": "string"
                },
                "tableRange": {
                  "type": "string"
                },
                "updates": {
                  "type": "object",
                  "properties": {
                    "spreadsheetId": {
                      "type": "string"
                    },
                    "updatedRange": {
                      "type": "string"
                    },
                    "updatedRows": {
                      "type": "integer"
                    },
                    "updatedColumns": {
                      "type": "integer"
                    },
                    "updatedCells": {
                      "type": "integer"
                    }
                  }
                }
              }
            },
            "getRowInput": {
              "type": "object",
              "properties": {
                "rowNumber": {
                  "type": "integer"
                }
              }
            }
          },
          "actions": {
            "insertRowAction": {
              "displayName": "Insert Row Into Sheet",
              "description": "This action insert a new row into sheet.",
              "execute": "flow:insertRowFlow",
              "input": "flow:sheetSchemaFlow",
              "output": {
                "schemaType": "application/schema+json",
                "schema": {
                  "$ref": "#/schemas/insertRowOutput"
                }
              },
              "configuration": [
                {
                  "name": "spreadsheetId",
                  "displayName": "Spreadsheet Name",
                  "description": "",
                  "type": "COMBO_BOX",
                  "options": "flow:spreadsheetIdFlow",
                  "required": true
                },
                {
                  "name": "sheetId",
                  "displayName": "Sheet Name",
                  "description": "",
                  "type": "COMBO_BOX",
                  "options": "flow:sheetIdFlow",
                  "required": true,
                  "dependencies": {
                    "spreadsheetId": {
                      "values": []
                    }
                  }
                }
              ]
            },
            "getRowAction": {
              "displayName": "Get Row From Sheet",
              "description": "This action get a row from sheet.",
              "execute": "flow:getRowFlow",
              "input": {
                "schemaType": "application/schema+json",
                "schema": {
                  "$ref": "#/schemas/getRowInput"
                }
              },
              "output": "flow:sheetSchemaFlow",
              "configuration": [
                {
                  "name": "spreadsheetId",
                  "displayName": "Spreadsheet Name",
                  "description": "",
                  "type": "COMBO_BOX",
                  "options": "flow:spreadsheetIdFlow",
                  "required": true
                },
                {
                  "name": "sheetId",
                  "displayName": "Sheet Name",
                  "description": "",
                  "type": "COMBO_BOX",
                  "options": "flow:sheetIdFlow",
                  "required": true,
                  "dependencies": {
                    "spreadsheetId": {
                      "values": []
                    }
                  }
                },
                {
                  "name": "rowOperation",
                  "displayName": "Operation",
                  "description": "",
                  "type": "COMBO_BOX",
                  "required": true,
                  "options": [
                    {
                      "keyName": "currentRow",
                      "displayName": "Get Specific Row"
                    },
                    {
                      "keyName": "lastRow",
                      "displayName": "Get Last Row"
                    }
                  ]
                }
              ]
            },
            "createSpreadsheetAction": {
              "displayName": "Create Spreadsheet",
              "description": "This action creates a new spreadsheet.",
              "execute": "flow:createSpreadsheetFlow",
              "input": {
                "schemaType": "application/schema+json",
                "schema": {
                  "$ref": "#/schemas/createSpreadsheetInput"
                }
              },
              "output": {
                "schemaType": "application/schema+json",
                "schema": {
                  "$ref": "#/schemas/Spreadsheet"
                }
              }
            },
            "insertRowActionErrorEngine": {
              "displayName": "Insert Row Into Sheet(Engine Error for Demo)",
              "description": "This action insert a new row into sheet.",
              "execute": "flow:insertRowFlow",
              "input": "flow:sheetSchemaFlow",
              "output": {
                "schemaType": "application/schema+json",
                "schema": {
                  "$ref": "#/schemas/insertRowOutput"
                }
              },
              "configuration": [
                {
                  "name": "spreadsheetId",
                  "displayName": "Spreadsheet Name",
                  "description": "",
                  "type": "COMBO_BOX",
                  "options": "flow:spreadsheetIdFlow",
                  "required": true
                },
                {
                  "name": "sheetId",
                  "displayName": "Sheet Name",
                  "description": "",
                  "type": "COMBO_BOX",
                  "options": "flow:sheetIdFlowErrorEngine",
                  "required": true,
                  "dependencies": {
                    "spreadsheetId": {
                      "values": []
                    }
                  }
                }
              ]
            }
          },
          "flows": {
            "insertRowFlow": {
              "id": "insertRowFlow",
              "description": "insertRowFlow",
              "specVersion": "0.8",
              "version": "0.1",
              "start": "startState",
              "functions": [
                {
                  "name": "generalRestFunc",
                  "type": "custom",
                  "operation": "connectivity::rest"
                }
              ],
              "states": [
                {
                  "name": "startState",
                  "type": "operation",
                  "actions": [
                    {
                      "name": "insertRowAction",
                      "functionRef": {
                        "refName": "generalRestFunc",
                        "arguments": {
                          "uri": "https://sheets.googleapis.com/v4/spreadsheets/{spreadsheetId}/values/{range}:append",
                          "method": "POST",
                          "parameters": {
                            "spreadsheetId": "${ .configuration.spreadsheetId }",
                            "range": "${ .configuration.sheetId + \"!A1:Z1\" }",
                            "insertDataOption": "INSERT_ROWS",
                            "valueInputOption": "RAW"
                          },
                          "body": "${ {range: (.configuration.sheetId + \"!A1:Z1\"), majorDimension:\"ROWS\", values: .input | to_entries | [map(.value)] } }"
                        }
                      },
                      "actionDataFilter": {
                        "results": "${ .body }",
                        "toStateData": "${ .output }"
                      }
                    }
                  ],
                  "end": true
                }
              ]
            },
            "getRowFlow": {
              "id": "getRowFlow",
              "description": "getRowFlow",
              "specVersion": "0.8",
              "version": "0.1",
              "start": "startState",
              "functions": [
                {
                  "name": "generalRestFunc",
                  "type": "custom",
                  "operation": "connectivity::rest"
                },
                {
                  "name": "convertResult",
                  "type": "expression",
                  "operation": "(if .configuration.rowOperation == \"lastRow\" then (.lastLineNumber-1) else (.input.rowNumber-1) end) as $rowNum | .values | map({key:.[0], value:.[$rowNum]}) | from_entries"
                }
              ],
              "states": [
                {
                  "name": "startState",
                  "type": "operation",
                  "actions": [
                    {
                      "functionRef": {
                        "refName": "generalRestFunc",
                        "arguments": {
                          "uri": "https://sheets.googleapis.com/v4/spreadsheets/{spreadsheetId}/values/{range}",
                          "method": "GET",
                          "parameters": {
                            "spreadsheetId": "${ .configuration.spreadsheetId }",
                            "range": "${ .configuration.sheetId + \"!A1:Z40000\" }",
                            "majorDimension": "ROWS"
                          }
                        }
                      },
                      "actionDataFilter": {
                        "results": "${ .body.values | length }",
                        "toStateData": "${ .lastLineNumber }"
                      }
                    },
                    {
                      "functionRef": {
                        "refName": "generalRestFunc",
                        "arguments": {
                          "uri": "https://sheets.googleapis.com/v4/spreadsheets/{spreadsheetId}/values/{range}",
                          "method": "GET",
                          "parameters": {
                            "spreadsheetId": "${ .configuration.spreadsheetId }",
                            "range": "${ if .configuration.rowOperation == \"lastRow\" then .configuration.sheetId + \"!A1:Z\" + (.lastLineNumber|tostring) else .configuration.sheetId + \"!A1:Z\" + (.input.rowNumber|tostring) end }",
                            "majorDimension": "COLUMNS"
                          }
                        }
                      },
                      "actionDataFilter": {
                        "results": "${ .body.values }",
                        "toStateData": "${ .values }"
                      }
                    },
                    {
                      "functionRef": "convertResult",
                      "actionDataFilter": {
                        "toStateData": "${ .output }"
                      }
                    }
                  ],
                  "end": true
                }
              ]
            },
            "createSpreadsheetFlow": {
              "id": "createSpreadsheetFlow",
              "description": "createSpreadsheetFlow",
              "specVersion": "0.8",
              "version": "0.1",
              "start": "startState",
              "functions": [
                {
                  "name": "generalRestFunc",
                  "type": "custom",
                  "operation": "connectivity::rest"
                }
              ],
              "states": [
                {
                  "name": "startState",
                  "type": "operation",
                  "actions": [
                    {
                      "functionRef": {
                        "refName": "generalRestFunc",
                        "arguments": {
                          "uri": "https://sheets.googleapis.com/v4/spreadsheets",
                          "method": "POST",
                          "body": "${ {properties:{title:.input.spreadsheetTitle},sheets:.input.sheets|map({properties:{title:.sheetTitle}})} }"
                        }
                      },
                      "actionDataFilter": {
                        "results": "${ .body }",
                        "toStateData": "${ .output }"
                      }
                    }
                  ],
                  "end": true
                }
              ]
            },
            "testConnectionFlow": {
              "id": "testConnectionFlow",
              "description": "testConnectionFlow",
              "specVersion": "0.8",
              "version": "0.1",
              "start": "startState",
              "functions": [
                {
                  "name": "generalRestFunc",
                  "type": "custom",
                  "operation": "connectivity::rest"
                }
              ],
              "states": [
                {
                  "name": "startState",
                  "type": "operation",
                  "actions": [
                    {
                      "functionRef": {
                        "refName": "generalRestFunc",
                        "arguments": {
                          "uri": "https://www.googleapis.com/drive/v3/files",
                          "method": "GET"
                        }
                      },
                      "actionDataFilter": {
                        "results": "${ { success: (.status==200), message: .body.error.message } }",
                        "toStateData": "${ .output }"
                      }
                    }
                  ],
                  "end": true
                }
              ]
            },
            "spreadsheetIdFlow": {
              "id": "spreadsheetIdFlow",
              "description": "spreadsheetIdFlow",
              "specVersion": "0.8",
              "version": "0.1",
              "start": "startState",
              "functions": [
                {
                  "name": "generalRestFunc",
                  "type": "custom",
                  "operation": "connectivity::rest"
                }
              ],
              "states": [
                {
                  "name": "startState",
                  "type": "operation",
                  "actions": [
                    {
                      "name": "getAllSpreadsheetIDs",
                      "functionRef": {
                        "refName": "generalRestFunc",
                        "arguments": {
                          "uri": "https://www.googleapis.com/drive/v3/files",
                          "method": "GET",
                          "parameters": {
                            "q": "mimeType='application/vnd.google-apps.spreadsheet' and trashed=false",
                            "pageSize": 1000
                          }
                        }
                      },
                      "actionDataFilter": {
                        "results": "${ .body.files | map({keyName:.id, displayName:.name}) }",
                        "toStateData": "${ .output }"
                      }
                    }
                  ],
                  "end": true
                }
              ]
            },
            "sheetIdFlow": {
              "id": "sheetIdFlow",
              "description": "sheetIdFlow",
              "specVersion": "0.8",
              "version": "0.1",
              "start": "startState",
              "functions": [
                {
                  "name": "generalRestFunc",
                  "type": "custom",
                  "operation": "connectivity::rest"
                }
              ],
              "states": [
                {
                  "name": "startState",
                  "type": "operation",
                  "actions": [
                    {
                      "name": "getAllSheetIDsBySpreadsheetId",
                      "functionRef": {
                        "refName": "generalRestFunc",
                        "arguments": {
                          "uri": "https://sheets.googleapis.com/v4/spreadsheets/{spreadsheetId}",
                          "method": "GET",
                          "parameters": {
                            "spreadsheetId": "${ .configuration.spreadsheetId }"
                          }
                        }
                      },
                      "actionDataFilter": {
                        "results": "${ .body.sheets | map({keyName:.properties.title, displayName:.properties.title}) }",
                        "toStateData": "${ .output }"
                      }
                    }
                  ],
                  "end": true
                }
              ]
            },
            "sheetSchemaFlow": {
              "id": "sheetSchemaFlow",
              "description": "sheetSchemaFlow",
              "specVersion": "0.8",
              "version": "0.1",
              "start": "startState",
              "functions": [
                {
                  "name": "generalRestFunc",
                  "type": "custom",
                  "operation": "connectivity::rest"
                },
                {
                  "name": "constructReturnObject",
                  "type": "expression",
                  "operation": "{\"schemaType\": \"application/schema+json\", \"schema\": .schema}"
                }
              ],
              "states": [
                {
                  "name": "startState",
                  "type": "operation",
                  "actions": [
                    {
                      "name": "generateSchemaBySheetHeader",
                      "functionRef": {
                        "refName": "generalRestFunc",
                        "arguments": {
                          "uri": "https://sheets.googleapis.com/v4/spreadsheets/{spreadsheetId}/values/{range}",
                          "method": "GET",
                          "parameters": {
                            "spreadsheetId": "${ .configuration.spreadsheetId }",
                            "range": "${ .configuration.sheetId + \"!A1:Z1\" }",
                            "majorDimension": "ROWS"
                          }
                        }
                      },
                      "actionDataFilter": {
                        "results": "${ .body.values[0] | map({key:., value: {type:\"string\"}}) | from_entries | {type: \"object\", properties: .} }",
                        "toStateData": "${ .schema }"
                      }
                    },
                    {
                      "name": "addSchemaType",
                      "functionRef": "constructReturnObject",
                      "actionDataFilter": {
                        "toStateData": "${ .output }"
                      }
                    }
                  ],
                  "end": true
                }
              ]
            },
            "sheetIdFlowErrorEngine": {
              "id": "sheetIdFlowErrorEngine",
              "description": "sheetIdFlowErrorEngine",
              "specVersion": "0.8",
              "version": "0.1",
              "start": "startState",
              "functions": [
                {
                  "name": "generalRestFunc",
                  "type": "custom",
                  "operation": "connectivity::rest"
                }
              ],
              "states": [
                {
                  "name": "startState",
                  "type": "operation",
                  "actions": [
                    {
                      "name": "getAllSheetIDsBySpreadsheetId",
                      "functionRef": {
                        "refName": "generalRestFunc",
                        "arguments": {
                          "uri": "https://sheets.googleapis.com/v4/spreadsheets/{spreadsheetId}",
                          "method": "GET",
                          "parameters": {
                            "spreadsheetId": "${ .configuration.spreadsheetId }"
                          }
                        }
                      },
                      "actionDataFilter": {
                        "results": "${ .sheets | map({keyName:.title, displayName:.title}) }",
                        "toStateData": "${ .output }"
                      }
                    }
                  ],
                  "end": true
                }
              ]
            }
          }
        },
        "output": [
          {
            "keyName": "1WxoiFLblMO6zeN7qkZkjnopI8_6vvfFB84dvbrZIdh0",
            "displayName": "Customer Managment"
          },
          {
            "keyName": "1_7maXDpc_qMMRzMm0x6d90-Hj6vvhGyO2kyFX0tpuZs",
            "displayName": "HL7 Message - FHIR R4: VXU_V04"
          },
          {
            "keyName": "1evBW_GzccQVcMM4OcBGXBiJOHhuywdahjQnAl5a9MjY",
            "displayName": "Copy of Restricted Stock Unit (RSU) Calculator"
          },
          {
            "keyName": "1DjtOl1dvZPMT0O0LJZZts9foehDdRoicmfTP022Fkw4",
            "displayName": "Development Management"
          },
          {
            "keyName": "1GT8i-J_PmgZwK0oer_VsHG1ev2JaR8jASK5Va7IUWEU",
            "displayName": "Event Attendee List"
          },
          {
            "keyName": "1Ol0b0Et3MccQsXfHI4tAqvabENSHE6c1HnU2kDfYU0E",
            "displayName": "HR Management"
          },
          {
            "keyName": "1MEv_Ifg87I0Qoe86RUp4cdOrVnQgcj8NLU1HKjHkKso",
            "displayName": "Financial Managment"
          },
          {
            "keyName": "1yOVioh6TuYayc78Sbgwo6yxsbOIZE7IQpKqXomJ-qdA",
            "displayName": "UAT-File"
          },
          {
            "keyName": "1ZveTrV1yDf92X_VPiE8FPDslUotfSiX7ztHfjCzWCQc",
            "displayName": "SalesAccounts"
          }
        ]
      }
    }
  ]
}