We help IT Professionals succeed at work.

Modify json result and send it back, VBA

Gontran Harvey
on
90 Views
Last Modified: 2017-03-21
I have a result from an API and the way this API work, to modify even only one field, I have to send back all fields.
What I whant is to modify the fields I whant and send back the info to the API.
I know I can use string function to do that, but I whant to know if theres a library or sommething more simple that I can use to just change some part of the result.
Here what I receive from the API:

{
  "id": "a05b0aa4-d622-4bda-8a0d-0b287bc43c7a",
  "idStatus": null,
  "isUser": false,
  "company": null,
  "department": null,
  "companyID": "",
  "contactType": "Contact",
  "firstName": "test302",
  "lastName": "test2",
  "lastResults": null,
  "messengerID": null,
  "middleName": null,
  "nameSuffix": null,
  "namePrefix": null,
  "fullName": "test302 test2",
  "referredBy": null,
  "salutation": "test302",
  "jobTitle": null,
  "emailAddress": "dfgfdg£g.com",
  }

Open in new window

I need to send back the exact same thing but with some change. Exemple, I would like to change the "firstname" to something else.
Comment
Watch Question

Mike in ITIT System Administrator
Distinguished Expert 2017
Commented:
This problem has been solved!
(Unlock this solution with a 7-day Free Trial)
UNLOCK SOLUTION

Author

Commented:
I did not want to go there, but if I have to I will!! thanks.
This problem has been solved!
(Unlock this solution with a 7-day Free Trial)
UNLOCK SOLUTION
Mike in ITIT System Administrator
Distinguished Expert 2017

Commented:
Does the code you wrote solve the problem?

If it doesn't are there any errors or parts that don't work the way you would like them to?

Author

Commented:
yes work perfectly!!
thanks

Author

Commented:
Because there is no real solution exept the code I just posted