Gontran Harvey
asked on
Modify json result and send it back, VBA
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:
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",
}
I need to send back the exact same thing but with some change. Exemple, I would like to change the "firstname" to something else.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
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?
If it doesn't are there any errors or parts that don't work the way you would like them to?
ASKER
yes work perfectly!!
thanks
thanks
ASKER
Because there is no real solution exept the code I just posted
ASKER