chargemopa.blogg.se

#"Expanded Value" = Table.

I also fixed one of them to work properly but the result was a call stack overflow because of to many recursion of the doProcess function.

My JSON has nested objects so suggested solution like VBJSON and vba-json do not work for me. #"Converted to Table" = Record.ToTable(Source), I have the same issue as in Excel VBA: Parsed JSON Object Loop but cannot find any solution. Source = Json.Document(Web.Contents("")), Here's the full code to get to a table - each step was generated by clicking on the UI. Your exact steps may vary, depending on your JSON input and your output requirements. Note there is more depth to this particular JSON layout - see the Value.prizes column at the far right. Expand the record to get the columns of data in a tabular format. This returns multiple rows, with each second column (Value) now containing a Record. UPDATE 2 (Oct 1 '16) However if you do want to parse JSON on 64-bit Office with ScriptControl, then this answer may help you to get ScriptControl to work on 64-bit. Click the expand button next to "Value" to expand the List. Import JSON.bas module into the VBA project for JSON processing. This returns a single row, with the second column (Value) containing a List. You can usually use the PQ UI to expand those objects without writing code.Īfter running the PQ "From Web", the next step is to click the Record Tools / Convert / Into Table button in the PQ ribbon. JSON data often appears as Records within Lists within Records (and other variations).