Use vba access to get particle status

Hello,

I have a core particle that is working, I created the variable “status” and I can see the stored value when using link

https://api.particle.io/v1/devices/54ff6d06667252387/status/?access_token=052fb0dc0f3ad48skdjfhsdkjfhsl

Now for what I need.

I want microsoft access only take the value of the variable “status” result = 1. I searched on the internet but only found how to turn on and off pins.

I hope some of you help me.

Thank you

Roberto