Complex Iterator - Advance Loop

Hi,
I have quite a few doubts in the Complex Iterator->Advance Loop section.
The doc doesn’t have details about all the fields and I didn’t find any walkthrough video for these activities.
Is there any demo bot available for all the activities within Advance Loop. If yes, please share.

For reference, here are few challenges which we are facing:

  1. For Loop Type ‘Excel’, although I’d installed ‘Microsoft Access Database Engine 2010’ in system. I’m still getting error as ‘microsoft.ace.oledb.12.0 provider not registered on local machine

  2. For Loop Type ‘JSON’, in Preview and Filter settings page, getting the error as ‘Object reference not set to an instance of an Object’.

Please help us in getting resolve these issue.

Thanks

Hi,

  1. To check whether the 32-bit Microsoft Access Database Engine drivers are installed and search for file odbcad32.exe

  2. What is the json that you are using for loop. You can iterate over stringified json

Regards,
Amit

Hi,
I’d installed 64 bit Access database engine, as upon installing 32 bit getting popup message as below:
AccessDb32bitIssue

JSON I’m using:
{
“employees”: {
“employee”: [
{
“id”: “1”,
“firstName”: “Tom”,
“lastName”: “Cruise”
},
{
“id”: “2”,
“firstName”: “Maria”,
“lastName”: “Sharapova”
},
{
“id”: “3”,
“firstName”: “James”,
“lastName”: “Bond”
}
]
}
}

JSON Path: employees\employee

Regards
Vinod

Hi,

You need to install AccessDatabaseEngine 2007.

I will check with json and revert

Hi @amit_anand15

Complex Loop_Excel issue has been resolve after installation of AccessDatabaseEngine 2007.

WRT JSON, please check and revert as issue still persist.

Thanks

Hi @amit_anand15,

is there any update for issue regarding JSON iteration.

Thanks

The json youhave posted is not correct JSOn format. check you json on https://jsoneditoronline.org/

Hi,
I’d rectified the json and checked using https://jsoneditoronline.org/ tool to fix the json.
But now I’m getting different error as:
Cannot select token using jsonpath.Please check log for more details’.

JSON for reference:
{
“employees”: {
“employee”: [
{
“id”: “1”,
“firstName”: “Tom”,
“lastName”: “Cruise”
},
{
“id”: “2”,
“firstName”: “Maria”,
“lastName”: “Sharapova”
},
{
“id”: “3”,
“firstName”: “James”,
“lastName”: “Bond”
}
]
}
}

JSONPATH: “employees[employee]”
Evaluation Result:
[
[
{
“id”: “1”,
“firstName”: “Tom”,
“lastName”: “Cruise”
},
{
“id”: “2”,
“firstName”: “Maria”,
“lastName”: “Sharapova”
},
{
“id”: “3”,
“firstName”: “James”,
“lastName”: “Bond”
}
]
]

Hi @amit_anand15

Any update on following issue.

Thanks

Hi,

Your json is still not correct:

image