IBM host files action : Running trigger failed by showing server failure message and format of Input.Json contents copied in Rows parameters of the Action is getting changed

vgouth commented 1 year ago

Describe the Bug with repro steps

1.Create a new workflow app using VS Code. 2.Create a stateful workflow 3.Add a HTTP trigger to the workflow and save the workflow 4.Add a "Generate Host File Contents" (from the IBM Host File SP) Action after the trigger 5.The Connection Parameters can (should) be left unchanged - or, if you like: 37 and unchecked. 6.For the first 2 parameters of the Action, enter: redefines.hidx (for the HIDX Name), "CUSTOMER_FILE_ROW" (for the Schema Name). 7.Open the attachment named InputJson.txt, copy the contents. In VS Code - the third Parameter Rows, has a button on the right enabling you to fill out all Input as a single value, click this. Delete the contents of the text box ("[ null ]" or similar) and then paste in the copied Input.Json contents. 8. Add a "Parse Host File Contents" Action, and fill out the first 2 Parameters as above (step 6). For the "Binary Contents" select the Dynamic content "Binary Contents" (which is the output of the previous step). 9.Add a response action as well - Http Response - for the Body, use the Dynamic content "Rows" (the output from the previous step). 10.Click on "Artifacts/Maps", right click - reveal in file explorer. Download the attachment "Redefines.hidx" into that directory. 11.Press F5/Run the Workflow

Get the trigger URL by going to the "overview" page for the workflow.
Expected Result : Run trigger should succeed and format of Input.Json contents copied in Rows parameters of the Action is should not change. Actual Result : Run trigger getting failed by showing server failure message and the format of Input.Json contents copied in Rows parameters of the Action is getting changed.

Input.Json contents. [ { "CUSTOMER_TYPE": "B", "SIMPLE_REDEFINITION1": { "BUSINESS": { "NAME": "ABC" } } }, { "CUSTOMER_TYPE": "P", "SIMPLE_REDEFINITION1": { "PERSONAL": { "NAME": { "FIRST_NAME": "Rob", "LAST_NAME": "BEA" } } } } ]

What type of Logic App Is this happening in?

Standard (Portal)

Are you using Preview Designer or GA Designer

Preview

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

No

Workflow JSON

{
  "definition": {
    "$schema": "https://schema.management.azure.com/providers/Microsoft.Logic/schemas/2016-06-01/workflowdefinition.json#",
    "actions": {
      "Generate_Host_File_Contents": {
        "type": "ServiceProvider",
        "inputs": {
          "parameters": {
            "hidx": "redefines.hidx",
            "schema": "CUSTOMER_FILE_ROW",
            "rows": [
              [
                {
                  "CUSTOMER_TYPE": "B",
                  "SIMPLE_REDEFINITION1": {
                    "BUSINESS": {
                      "NAME": "ABC"
                    }
                  }
                },
                {
                  "CUSTOMER_TYPE": "P",
                  "SIMPLE_REDEFINITION1": {
                    "PERSONAL": {
                      "NAME": {
                        "FIRST_NAME": "Rob",
                        "LAST_NAME": "BEA"
                      }
                    }
                  }
                }
              ]
            ]
          },
          "serviceProviderConfiguration": {
            "connectionName": "hostfile",
            "operationId": "generateFileContents",
            "serviceProviderId": "/serviceProviders/hostfile"
          }
        },
        "runAfter": {}
      },
      "Parse_Host_File_Contents": {
        "type": "ServiceProvider",
        "inputs": {
          "parameters": {
            "hidx": "redefines.hidx",
            "schema": "CUSTOMER_FILE_ROW",
            "contents": "@body('Generate_Host_File_Contents')?['contents']"
          },
          "serviceProviderConfiguration": {
            "connectionName": "hostfile",
            "operationId": "parseFileContents",
            "serviceProviderId": "/serviceProviders/hostfile"
          }
        },
        "runAfter": {
          "Generate_Host_File_Contents": [
            "SUCCEEDED"
          ]
        }
      },
      "Response": {
        "type": "Response",
        "kind": "Http",
        "inputs": {
          "statusCode": 200,
          "body": "@body('Parse_Host_File_Contents')?['rows']"
        },
        "runAfter": {
          "Parse_Host_File_Contents": [
            "SUCCEEDED"
          ]
        }
      }
    },
    "contentVersion": "1.0.0.0",
    "outputs": {},
    "triggers": {
      "When_a_HTTP_request_is_received": {
        "type": "Request",
        "kind": "Http"
      }
    }
  },
  "connectionReferences": {
    "hostfile": {
      "connection": {
        "id": "/serviceProviders/hostfile/connections/hostfile"
      },
      "connectionName": "abc",
      "api": {
        "id": "/serviceProviders/hostfile"
      }
    }
  },
  "parameters": {}
}

Screenshots or Videos

{ "code": "ServiceProviderActionFailed", "message": "The service provider action failed with error code 'ServiceOperationInvalidParameter' and error message 'The flat file processor based on HIDX: 'C:\home\site\wwwroot\Artifacts\Maps\redefines.hidx', and Schema: 'CUSTOMER_FILE_ROW' could not parse the input binary data. Error: 'Creation of record number: 0 failed. Description: 'HISMAGJ0044 When converting to host format parameter CUSTOMER_FILE_ROW in method PackIndependentStructure structure CUSTOMER_FILE_ROW was not of the expected type.'.'.'." }