json

{ "data": { "trackings": [ { "tracking_number": "3A5V198427201", "shipment_pickup_date": "2016-10-31T23:49:00", "tag": "InTransit", "title": "3531", "checkpoints": [ { "created_at": "2016-11-01T16:09:23+00:00"...

I have a JSON text result from an API, given below. {"visit":"1","paid":"0","repeatPat":0} I need the numbers to be extracted in 3 separate cells. Please assist.

Hi, I am trying to convert the following 13 digit json number -> 1452002465000 to date/time. I am using this formula ->=D7/1000/86400. This is giving me 03/01/1946/ 12:28 PM. The time is correct but the date is wrong (should be 05/01/2016)

Hi anvg/all, I'm facing another issue in one of my feeds. ThI'm facing another issue in one of my feeds. This is also due to mix of list and text value in a single column. Please note that this is related to...

I'm trying to transform a (I'm a newbie in power query transformation) json data. Our aim is to merge and transform a few json files to create a report. The json files are provided by different feed exposed by our web application. As part of learning, we tried to transform a single json file...

Good morning all, Im in a real pickle and in need of some help from some experts out there, Im trying to get a web API through vb(done) then get the data from it into cells. The data is returned in JSON, which is where im stuck. Its basically a Q&A database, each question has a ref no...

Hi Experts, I have a excel spreadheet with around 60K addresses all around UK. I was finding for a solution that will receive these addresses as input and provide the output with the coresponding address GPS coordinates "Longtitudes and Lattitudes". I have found a VB code on stackoverflow that...

I dont know if this is possible in excel and need your advice. If I enter the below url in the browser,I get a Json object with a "is_verified" parameter either true or false. https://graph.facebook.com/fql?q=SELECT%20is_verified%20FROM%20page%20WHERE%20username=%22nokia%22 This is what i get...

Hi, I'm trading crypto's and want to build an Excel spreadsheet to monitor marketmovements for analyzing. I can do so by using the API offered by the exchange; https://api.mintpal.com/v1/market/trades/MINT/BTC. Now I have never used VBA and find it really hard to find any tutorials for...

Hi everybody, I would like to parse a json string in VBA using this library : VB JSON Parser Library for VB6 (BSD Licensed) - Visual Basic, JSON here is an example of the json string I receive from a Web Service and want to parse: { "total": [[10000,1]], "periods": [1399852800000]...

I got a requirement to do on VBA Excel. No coding expertise here. It's about converting array data into another array. (The bullet points are just to represent a process to do) For each cell, columnAnsDesc, data is like a 3-dimension array each with a field name (Label/Num/Use), like this <code...

Hey, I have successfully parsed a few strings by following the very helpfuls posts in this forum. These one are all working well. My data looks a bit different than in the threads here so I would like some input from you if possible. I have imported the "JSON.bas", "cJSONScript.cls" and...