Not able to convert HTTP request output to datatable or array

Hi All,
Can you please help me to figure out how to do this.

Hi @sachin.lather,

A more info of the format of the Json String retrieved could be helpful for us to analyse and provide a suggestion on the correction.\

A Sample Json String as text file corresponding to the data you have would be helpful as well for us to check from our end.

Hi @supermanPunch ,

Output json is as follow,
"[{"attributes":{"type":"Enquiry__c","url":"/services/data/v57.0/sobjects/Enquiry__c/a0Dp0000007fMLfEAM"},"Name":"E-0110","Id":"a0Dp0000007fMLfEAM","Sales_Consultant__c":"005p0000004d06xAAA","Account__c":"001p0000011MXekAAG","Demand_Structure__c":"First Time","Site__c":"Toyota Noida","Main_Source__c":"Dealer Digital","Data_Source__c":"Manual","Sales_Consultant__r":{"attributes":{"type":"User","url":"/services/data/v57.0/sobjects/User/005p0000004d06xAAA"},"Id":"005p0000004d06xAAA","Name":"Meenu Rawat"},"Account__r":{"attributes":{"type":"Account","url":"/services/data/v57.0/sobjects/Account/001p0000011MXekAAG"},"Id":"001p0000011MXekAAG","Name":"Abhi Singh","Phone":"+911123843000"}},{"attributes":{"type":"Enquiry__c","url":"/services/data/v57.0/sobjects/Enquiry__c/a0Dp0000007fJTPEA2"},"Name":"E-0079","Id":"a0Dp0000007fJTPEA2","Sales_Consultant__c":"005p0000004d06xAAA","Account__c":"001p00000110tCPAAY","Demand_Structure__c":"First Time","Site__c":"Toyota Noida","Main_Source__c":"Dealer Digital","Data_Source__c":"Manual","Sales_Consultant__r":{"attributes":{"type":"User","url":"/services/data/v57.0/sobjects/User/005p0000004d06xAAA"},"Id":"005p0000004d06xAAA","Name":"Meenu Rawat"},"Account__r":{"attributes":{"type":"Account","url":"/services/data/v57.0/sobjects/Account/001p00000110tCPAAY"},"Id":"001p00000110tCPAAY","Name":"Demo"}},{"attributes":{"type":"Enquiry__c","url":"/services/data/v57.0/sobjects/Enquiry__c/a0Dp0000007ftCSEAY"},"Name":"E-0218","Id":"a0Dp0000007ftCSEAY","Sales_Consultant__c":"0055g00000AaDNLAA3","Account__c":"001p000000tHNTIAA4","Demand_Structure__c":"First Time","Site__c":"Toyota Delhi","Suffix__c":"VN","Exterior_Colourr__c":"ATTITUDE BLACK","Main_Source__c":"Dealer Digital","Sub_source__c":"Third Party Website/Car Wale","Data_Source__c":"Manual","Sales_Consultant__r":{"attributes":{"type":"User","url":"/services/data/v57.0/sobjects/User/0055g00000AaDNLAA3"},"Id":"0055g00000AaDNLAA3","Name":"Simran Panwar"},"Account__r":{"attributes":{"type":"Account","url":"/services/data/v57.0/sobjects/Account/001p000000tHNTIAA4"},"Id":"001p000000tHNTIAA4","Name":"RD COTTON INDUSTRIES","Phone":"9811963626"}},{"attributes":{"type":"Enquiry__c","url":"/services/data/v57.0/sobjects/Enquiry__c/a0Dp0000007aAB7EAM"},"Name":"E-0005","Id":"a0Dp0000007aAB7EAM","Sales_Consultant__c":"005p0000004d06xAAA","Account__c":"001p000000xTRFmAAO","Modell__c":"FORTUNER","Demand_Structure__c":"Replacement","Site__c":"Toyota Noida","Suffix__c":"VP","Main_Source__c":"Dealer Digital","Sub_source__c":"Third Party Website/Car Portal","Sales_Consultant__r":{"attributes":{"type":"User","url":"/services/data/v57.0/sobjects/User/005p0000004d06xAAA"},"Id":"005p0000004d06xAAA","Name":"Meenu Rawat"},"Account__r":{"attributes":{"type":"Account","url":"/services/data/v57.0/sobjects/Account/001p000000xTRFmAAO"},"Id":"001p000000xTRFmAAO","Name":"MR. GOVIND RAM MISHRA","Phone":"9682900577"}},{"attributes":{"type":"Enquiry__c","url":"/services/data/v57.0/sobjects/Enquiry__c/a0Dp0000007cAOtEAM"},"Name":"E-0062","Id":"a0Dp0000007cAOtEAM","Sales_Consultant__c":"005p0000004ftNVAAY","Account__c":"001p00000109APKAA2","Modell__c":"GLANZA","Demand_Structure__c":"Additional","Site__c":"Toyota Noida","Varient__c":"Innova Crysta 2.4 Gpackage X 7 Seater XD","Suffix__c":"VN","Exterior_Colourr__c":"AVANT GARDE BRONZE","Main_Source__c":"Dealer Digital","Sub_source__c":"Third Party Website/Car Wale","Data_Source__c":"Manual","Sales_Consultant__r":{"attributes":{"type":"User","url":"/services/data/v57.0/sobjects/User/005p0000004ftNVAAY"},"Id":"005p0000004ftNVAAY","Name":"Toyota Sales Consultant"},"Account__r":{"attributes":{"type":"Account","url":"/services/data/v57.0/sobjects/Account/001p00000109APKAA2"},"Id":"001p00000109APKAA2","Name":"Servoline Vinimay Pvt Ltd","Phone":"9831822222"}},{"attributes":{"type":"Enquiry__c","url":"/services/data/v57.0/sobjects/Enquiry__c/a0Dp0000007cAOoEAM"},"Name":"E-0061","Id":"a0Dp0000007cAOoEAM","Sales_Consultant__c":"005p0000004ftNVAAY","Account__c":"001p00000109APKAA2","Modell__c":"INNOVA","Demand_Structure__c":"Additional","Site__c":"Toyota Delhi","Varient__c":"Innova Crysta 2.4 Gpackage X 7 Seater XD","Suffix__c":"VN","Exterior_Colourr__c":"AVANT GARDE BRONZE","Main_Source__c":"Dealer Digital","Sub_source__c":"Third Party Website/Car Wale","Data_Source__c":"Manual","Sales_Consultant__r":{"attributes":{"type":"User","url":"/services/data/v57.0/sobjects/User/005p0000004ftNVAAY"},"Id":"005p0000004ftNVAAY","Name":"Toyota Sales Consultant"},"Account__r":{"attributes":{"type":"Account","url":"/services/data/v57.0/sobjects/Account/001p00000109APKAA2"},"Id":"001p00000109APKAA2","Name":"Servoline Vinimay Pvt Ltd","Phone":"9831822222"}},{"attributes":{"type":"Enquiry__c","url":"/services/data/v57.0/sobjects/Enquiry__c/a0Dp0000007dFtgEAE"},"Name":"E-0069","Id":"a0Dp0000007dFtgEAE","Sales_Consultant__c":"005p0000004d06xAAA","Account__c":"001p0000011BlbXAAS","Modell__c":"Lodgy","Demand_Structure__c":"Replacement","Site__c":"Toyota Noida","Main_Source__c":"Dealer Digital","Data_Source__c":"Manual","Sales_Consultant__r":{"attributes":{"type":"User","url":"/services/data/v57.0/sobjects/User/005p0000004d06xAAA"},"Id":"005p0000004d06xAAA","Name":"Meenu Rawat"},"Account__r":{"attributes":{"type":"Account","url":"/services/data/v57.0/sobjects/Account/001p0000011BlbXAAS"},"Id":"001p0000011BlbXAAS","Name":"mukul.malik@motherson.com","Phone":"Charanjeet Singh"}},{"attributes":{"type":"Enquiry__c","url":"/services/data/v57.0/sobjects/Enquiry__c/a0Dp0000007cAyDEAU"},"Name":"E-0063","Id":"a0Dp0000007cAyDEAU","Sales_Consultant__c":"005p0000004ftNVAAY","Account__c":"001p0000010ZWGCAA4","Modell__c":"INNOVA","Demand_Structure__c":"First Time","Site__c":"Toyota Noida","Varient__c":"Innova Crysta 2.8 Gpackage: X 7 Seater","Main_Source__c":"Dealer Digital","Data_Source__c":"Manual","Sales_Consultant__r":{"attributes":{"type":"User","url":"/services/data/v57.0/sobjects/User/005p0000004ftNVAAY"},"Id":"005p0000004ftNVAAY","Name":"Toyota Sales Consultant"},"Account__r":{"attributes":{"type":"Account","url":"/services/data/v57.0/sobjects/Account/001p0000010ZWGCAA4"},"Id":"001p0000010ZWGCAA4","Name":"mukul.malik@motherson.com","Phone":"Priya Tyagi"}},{"attributes":{"type":"Enquiry__c","url":"/services/data/v57.0/sobjects/Enquiry__c/a0Dp0000007fJsOEAU"},"Name":"E-0082","Id":"a0Dp0000007fJsOEAU","Sales_Consultant__c":"005p0000004d06xAAA","Account__c":"001p00000110tCPAAY","Demand_Structure__c":"First Time","Site__c":"Toyota Noida","Main_Source__c":"Dealer Digital","Data_Source__c":"Manual","Sales_Consultant__r":{"attributes":{"type":"User","url":"/services/data/v57.0/sobjects/User/005p0000004d06xAAA"},"Id":"005p0000004d06xAAA","Name":"Meenu Rawat"},"Account__r":{"attributes":{"type":"Account","url":"/services/data/v57.0/sobjects/Account/001p00000110tCPAAY"},"Id":"001p00000110tCPAAY","Name":"Demo"}},{"attributes":{"type":"Enquiry__c","url":"/services/data/v57.0/sobjects/Enquiry__c/a0Dp0000007fJNZEA2"},"Name":"E-0075","Id":"a0Dp0000007fJNZEA2","Sales_Consultant__c":"005p0000004d06xAAA","Account__c":"001p000000zrM9zAAE","Demand_Structure__c":"First Time","Site__c":"Toyota Noida","Main_Source__c":"Dealer Digital","Data_Source__c":"Manual","Sales_Consultant__r":{"attributes":{"type":"User","url":"/services/data/v57.0/sobjects/User/005p0000004d06xAAA"},"Id":"005p0000004d06xAAA","Name":"Meenu Rawat"},"Account__r":{"attributes":{"type":"Account","url":"/services/data/v57.0/sobjects/Account/001p000000zrM9zAAE"},"Id":"001p000000zrM9zAAE","Name":"Manuj Saxena","Phone":"+919818739425"}},{"attributes":{"type":"Enquiry__c","url":"/services/data/v57.0/sobjects/Enquiry__c/a0Dp0000007fJTKEA2"},"Name":"E-0078","Id":"a0Dp0000007fJTKEA2","Sales_Consultant__c":"005p0000004OhEQAA0","Account__c":"001p000000zrM9zAAE","Demand_Structure__c":"Additional","Site__c":"Toyota Noida","Main_Source__c":"Dealer Digital","Data_Source__c":"Manual","Sales_Consultant__r":{"attributes":{"type":"User","url":"/services/data/v57.0/sobjects/User/005p0000004OhEQAA0"},"Id":"005p0000004OhEQAA0","Name":"Abhishek"},"Account__r":{"attributes":{"type":"Account","url":"/services/data/v57.0/sobjects/Account/001p000000zrM9zAAE"},"Id":"001p000000zrM9zAAE","Name":"Manuj Saxena","Phone":"+919818739425"}},{"attributes":{"type":"Enquiry__c","url":"/services/data/v57.0/sobjects/Enquiry__c/a0Dp0000007fJSzEAM"},"Name":"E-0077","Id":"a0Dp0000007fJSzEAM","Sales_Consultant__c":"005p0000004d06xAAA","Account__c":"001p000000zrM9zAAE","Demand_Structure__c":"Replacement","Site__c":"Toyota Noida","Main_Source__c":"Online","Data_Source__c":"Manual","Sales_Consultant__r":{"attributes":{"type":"User","url":"/services/data/v57.0/sobjects/User/005p0000004d06xAAA"},"Id":"005p0000004d06xAAA","Name":"Meenu Rawat"},"Account__r":{"attributes":{"type":"Account","url":"/services/data/v57.0/sobjects/Account/001p000000zrM9zAAE"},"Id":"001p000000zrM9zAAE","Name":"Manuj Saxena",.…

Looks like a JArray - Deserialize JSON Array Activity can be used