JumboCactuar
Well-known Member
- Joined
- Nov 16, 2016
- Messages
- 788
- Office Version
- 365
- Platform
- Windows
Hi,
i have used the VBA-JSON before and understand how to use it for GET requests, but for POST i am unsure of the best route to take.
e.g:
How would i build that in VBA? I dont see a simple way due to the way double quotes are handled.
Is it possible to have a TXT file with this as a template, and edit that TXT file before POST
Thanks in advance
i have used the VBA-JSON before and understand how to use it for GET requests, but for POST i am unsure of the best route to take.
e.g:
JSON:
POST /orders/markasshipped HTTP/1.1
Host: ssapi.shipstation.com
Authorization: __YOUR_AUTH_HERE__
Content-Type: application/json
{
"orderId": 93348442,
"carrierCode": "usps",
"shipDate": "2014-04-01",
"trackingNumber": "913492493294329421",
"notifyCustomer": true,
"notifySalesChannel": true
}
How would i build that in VBA? I dont see a simple way due to the way double quotes are handled.
Is it possible to have a TXT file with this as a template, and edit that TXT file before POST
Thanks in advance