PxPlus User Forum

Twitter Twitter Twitter

Author Topic: Json labels  (Read 1357 times)

johanwichgers

  • New Member
  • *
  • Posts: 1
    • View Profile
Json labels
« on: July 17, 2019, 10:14:54 AM »
The filter labels in the json data below are dynamic and i dont know what to expect.
Is there a way to determine what labels(example vat_number) are present in my json so i can find the values ?

{
  "filter": {
    "vat_number": {
      "callbackValue": "The input is not valid"
    }
  },
  "trace": "#0 /home/test.identity.transferro.com/code/src/module/Controller/Api/V1/CustomerController.php(123): Transferro\\IdentityService\\Controller\\Api\\V1\\CustomerController->doCreate(Array)\n#1 /home/test.identity.transferro.com/code/vendor/locosoft/component/src/module/Controller/Api/AbstractApiController.php(393): Transferro\\IdentityService\\Controller\\Api\\V1\\CustomerController->create(Array)\n#2 /home/test.identity.transferro.com/code/vendor/zendframework/zend-mvc/src/Controller/AbstractRestfulController.php(429): Locosoft\\Component\\Controller\\Api\\AbstractApiController->processPostData(Object(Zend\\Http\\PhpEnvironment\\Request))\n#3 /home/test.identity.transferro.com/code/vendor/zendframework/zend-eventmanager/src/EventManager.php(322): Zend\\Mvc\\Controller\\AbstractRestfulController->onDispatch(Object(Zend\\Mvc\\MvcEvent))\n#4 /home/test.identity.transferro.com/code/vendor/zendframework/zend-eventmanager/src/EventManager.php(179): Zend\\EventManager\\EventManager->triggerListeners(Object(Zend\\Mvc\\MvcEvent), Object(Closure))\n#5 /home/test.identity.transferro.com/code/vendor/zendframework/zend-mvc/src/Controller/AbstractController.php(106): Zend\\EventManager\\EventManager->triggerEventUntil(Object(Closure), Object(Zend\\Mvc\\MvcEvent))\n#6 /home/test.identity.transferro.com/code/vendor/zendframework/zend-mvc/src/Controller/AbstractRestfulController.php(313): Zend\\Mvc\\Controller\\AbstractController->dispatch(Object(Zend\\Http\\PhpEnvironment\\Request), Object(Zend\\Http\\PhpEnvironment\\Response))\n#7 /home/test.identity.transferro.com/code/vendor/zendframework/zend-mvc/src/DispatchListener.php(138): Zend\\Mvc\\Controller\\AbstractRestfulController->dispatch(Object(Zend\\Http\\PhpEnvironment\\Request), Object(Zend\\Http\\PhpEnvironment\\Response))\n#8 /home/test.identity.transferro.com/code/vendor/zendframework/zend-eventmanager/src/EventManager.php(322): Zend\\Mvc\\DispatchListener->onDispatch(Object(Zend\\Mvc\\MvcEvent))\n#9 /home/test.identity.transferro.com/code/vendor/zendframework/zend-eventmanager/src/EventManager.php(179): Zend\\EventManager\\EventManager->triggerListeners(Object(Zend\\Mvc\\MvcEvent), Object(Closure))\n#10 /home/test.identity.transferro.com/code/vendor/zendframework/zend-mvc/src/Application.php(332): Zend\\EventManager\\EventManager->triggerEventUntil(Object(Closure), Object(Zend\\Mvc\\MvcEvent))\n#11 /home/test.identity.transferro.com/code/public/index.php(19): Zend\\Mvc\\Application->run()\n#12 {main}",
  "type": "http://www.w3.org/Protocols/rfc2616/rfc2616-sec10.html",
  "title": "Bad Request",
  "status": 400,
  "detail": "Your request parameters didn't validate"
}

Mike King

  • Diamond Member
  • *****
  • Posts: 3811
  • Mike King
    • View Profile
    • BBSysco Consulting
Re: Json labels
« Reply #1 on: July 17, 2019, 11:08:43 AM »
You can simply load the JSON into an array then spin through all the array indexes.

For example I copied your JSON to the clipboard directly from your posting and ran the following

0010 CLIP_BOARD READ json$
0020 DIM LOAD array${ALL}=json$
0040 FOR n$ INDEX array${ALL}
0050 PRINT n$
0060 NEXT
-:run
title
type
status
detail
trace
filter.vat_number.callbackValue



As you can see it showed all the labels found in the JSON.
Mike King
President - BBSysco Consulting
eMail: mike.king@bbsysco.com