How to Determine how many data items returned from a Web Activity in a pipeline?

Question

Hello! @Nasreen Akter @MartinJaffer-MSFT

I have run into a road block. I get the following back from a web activity call. Usually it is one data item, but sometimes like this case it is 2. In the pipeline if it is 2, I need to do a ifelse or switch or something for how many accounts are returned, but how do I know to loop through twice if there is more than one account in the Data items?
Thanks,

Mike

{
"Data": [
{
"AccountNumber": "xxxxxxxx",
"BankName": "<Not Applicable>",
"DepositNumber": 1,
"DepositValue": 100,
"PayMethod": {
"XRefCode": "CHECKING",
"ShortName": "Checking",
"LongName": "Checking"
},
"IsDeleted": false,
"IsPercentage": false,
"IsRemainder": false,
"NumberOfPreNoteDays": 0,
"RequiresPreNote": false,
"RoutingTransitNumber": "xxxxxxxx",
"LastModifiedTimestamp": "2021-01-26T21:29:02Z"
},
{
"AccountNumber": "xxxxxxxx",
"BankName": "<Not Applicable>",
"DepositNumber": 2,
"PayMethod": {
"XRefCode": "CHECKING",
"ShortName": "Checking",
"LongName": "Checking"
},
"IsDeleted": false,
"IsPercentage": false,
"IsRemainder": true,
"NumberOfPreNoteDays": 0,
"RequiresPreNote": false,
"RoutingTransitNumber": "xxxxxxxxxxx",
"LastModifiedTimestamp": "2021-01-26T21:29:02Z"

Answer 1

Hi @Mike Kiser ,

You can try length() function. Thanks!