Deserialize JSON - String is not a valid number

[AshwinS2 (Ashwin S)]

Hi @SoqedHozi

Check this

How to extract the data from Json to Excel

Hi @leewe01 You provided incorrect json string, I’m going to assume you meant: {"data":[{"id": 0111, "name": "xxx", "status": "C","address":"xxx"},{"id": 0112, "name": "xxx", "status": "C","address":"xxx"},{"id": 0113, "name": "xxx", "status": "C","address":"xxx"}]} I would do it that way: Create DataTable with necessary columns and headers Use ‘Deserialize json’ activity on string (I will refer to Output JsonObject as json) Loop throug json.Item(“data”) as per below screenshot[image][image…

Thanks
Ashwin S