HI
But the response is a premium connector. Which my client is not ready to use. Can we have any other approach.
I tried using below code.
Set(varResponse,Split('Copyof-Temp456_editing_array'.Run(noi,noi).complete,";"));
ForAll(varResponse.Result,Collect(colGridData,{
Affected_Item:Last(FirstN(Split(Last(FirstN(Split(Result,",").Result,1).Result).Result,":").Result,2).Result).Result,
Affected_Revision:Last(FirstN(Split(Last(FirstN(Split(Result,",").Result,2).Result).Result,":").Result,2).Result).Result,
Effective_date:Last(FirstN(Split(Last(FirstN(Split(Result,",").Result,3).Result).Result,":").Result,2).Result).Result-1
}
)
);

I need to remove the "" in the collection and date is also not coming.
I need the collection in below format.
