camow7

@drjdpowell Any plans to include a "Set Null to Default" feature?

Tested this and it worked well. Had no idea you could add the <JSON> tag to parse complex data types like dictionaries. Super handy. This looks likes it's solved my problems. Thanks!

@drjdpowell Also if you go through and set the comment fields to empty strings, the next parsing error hit is this: This is replicated using the same VI shared above by first setting the comment keys to actual strings

No problem. Thanks for following it up so quickly. Until a fix is done I could precheck specific fields that may error and set them to empty strings before passing into your conversion vi.

@drjdpowell I have attached the vi with the cluster I'm trying to parse it too. I have put the text in as a constant. Let me know if you have trouble running it. JSON Parsing Error.vi

I'm trying to parse this JSON data: { "id":"fb66aaec-f713-424c-ba04-386d0986fb12", "planId":"4c7cbe9c-ba67-4d8b-b731-32d3de0de700", "name":"AJ3", "redrillOfHoleId":null, "design":{ "angle":0.0, "bearing":4.376555, "comment":null, "decks":[ { "number":1, "horizon":25.0, "length":5.0, "productId":"f3fb75ac-1065-4d9c-bd6a-fdf01c34837b", "weight":0.0, "isVariable":false, "isBackfill":false }, { "number":2, "horizon":20.0, "length":5.0, "productId":"5800171c-e16e-48e7-9431-ac9b88f4852f", "weight":441.786469, "isVariable":false, "isBackfill":false }, { "number":3, "horizon":15.0, "length":5.0, "productId":"f3fb75ac-1065-4d9c-bd6a-fdf01c34837b", "weight":0.0, "isVariable":false, "isBackfill":false }, { "number":4, "horizon":10.0, "length":5.0, "productId":"0fa2dd6d-6b0c-4bfd-998b-e0b50ee64481", "weight":353.429169, "isVariable":false, "isBackfill":false }, { "number":5, "horizon":5.0, "length":5.0, "productId":"f3fb75ac-1065-4d9c-bd6a-fdf01c34837b", "weight":0.0, "isVariable":true, "isBackfill":false }, { "number":6, "horizon":0.0, "length":5.0, "productId":"5800171c-e16e-48e7-9431-ac9b88f4852f", "weight":441.786469, "isVariable":false, "isBackfill":false } ], "diameter":300.0, "length":30.0, "x":-194.97681394419092, "y":67.241148799992772, "z":0.0, "whenCreated":"2020-01-28T01:51:43.4065706Z", "whenUpdated":"2020-01-28T01:51:43.4065706Z" }, "adjustedDesign":{ "angle":0.0, "bearing":4.376555, "comment":null, "decks":[ { "number":1, "horizon":25.0, "length":5.0, "productId":"0fa2dd6d-6b0c-4bfd-998b-e0b50ee64481", "weight":353.429, "isVariable":false, "isBackfill":false }, { "number":2, "horizon":20.0, "length":5.0, "productId":"f3fb75ac-1065-4d9c-bd6a-fdf01c34837b", "weight":0.0, "isVariable":false, "isBackfill":false }, { "number":3, "horizon":15.0, "length":5.0, "productId":"5800171c-e16e-48e7-9431-ac9b88f4852f", "weight":441.786, "isVariable":false, "isBackfill":false }, { "number":4, "horizon":10.0, "length":5.0, "productId":"f3fb75ac-1065-4d9c-bd6a-fdf01c34837b", "weight":0.0, "isVariable":false, "isBackfill":false }, { "number":5, "horizon":5.0, "length":5.0, "productId":"0fa2dd6d-6b0c-4bfd-998b-e0b50ee64481", "weight":353.429, "isVariable":false, "isBackfill":false }, { "number":6, "horizon":0.0, "length":5.0, "productId":"5800171c-e16e-48e7-9431-ac9b88f4852f", "weight":441.786, "isVariable":false, "isBackfill":false } ], "diameter":300.0, "length":30.0, "x":-194.97681394419092, "y":67.241148799992772, "z":0.0, "whenCreated":"2020-01-28T02:04:07.6143372Z" }, "actual":{ "angle":null, "bearing":null, "calculatedDecks":[], "comment":null, "depthToWater":null, "diameter":null, "expectedDeckCount":null, "length":null, "accessories":[], "measuredDecks":[], "notDrilled":false, "userName":null, "x":null, "y":null, "z":null }, "drillAdjustedDesign":null, "drillActual":null, "holeType":"Hole type 1", "materialType":null, "isDeleted":false, "isNonDesignedHole":false, "allowTruncatedDesign":false, "disableChangeDesignRules":false, "scaleDepthOfBurial":null, "strataIntercepts":{}, "tags":["drilling_designed","loading_designed"], "whenCreated":"2020-01-28T01:51:43.4065706Z", "whenUpdated":"2020-01-28T01:51:43.4065706Z" } But am currently getting this error: