json data

  1. P

    Make an api call to geoTab to get current location of the vehicle in VBA. Tried few codes but nothing seem to work. Any help is appreciated.

    I am trying to make an API call to Geotab website in VBA. Geotab provides a DeviceStatusInfo Object that can be used to get the current Latitude and Longitude. (MyGeotab API Reference) I have been trying for a while in VBA but having no success. Hoping someone can help me out here. Used...
  2. C

    Need help with JSON in Power Query

    Hello all, Please forgive me if my post does not sound very professiona as I am quite proficient in Power Query when I extract data from local sources, but this time I have faced a REST API and got a bit lost. I have connected through a REST API and receive data in JSON format. Surprisingly...
  3. R

    Unable to automatically pull data and perform custom modifications to a table from a query whose source is a dynamically changing link

    * I posted this on the excel forum, but since this also relates to power query I also am making a post here. Hey there, I am trying to make excel get automatically get data from a link (however the link changes based on certain inputs like ticker symbol, time intervals, to/from time) instead...
    • rohanrao_1
    • Thread
    • json data macro power bi desktop power query
    • Replies: 0
    • Forum: Power Tools
  4. R

    How to find a maximum value from a list of json pairs using Excel vba ?

    Hi Experts, I am totally new in VBA and coding. Suppose i have a json string like this: jsonstr =...

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top