Integer parameters - how to?

[RibeyeOnTheBone]

Tim,

Thanks for writing Excel-Rest, I am finding it great.

I have run into an issue, I hope you can point me in the right direction.

I want to set a parameter that is an integer, but

postRequest.AddParameter "myInteger", myInteger

gives a ByRef type compile error, since postRequest is expecting strings as parameters.

If I pass myInteger as a string the web service says it cant convert test to number.

I see you have an example of

postRequest.AddParameter "myInteger", 20

This compiles for me also (dont understand how this can work, but I have stopped asking "why" questions of Microsoft) but obviously a hard coded value is only useful in some cases.

Can you advise how to set a non string parameter?

[timhall]

Good question Greg, let me see if I can modify the source to be a little more flexible with the parameters that are accepted. My guess is that quotes are being added to your integer value when it is sent to your service and that's why it's being rejected. I could see this being an issue with Double and Boolean as well so I'll see if I can adjust it for all of those cases.

With the library expecting strings, it will currently convert your parameter to the following for a POST request: "myInteger":"20", which is not the desired behavior. Instead it should be "myInteger":20 so this is definitely something missing from the library and I'll add it right away.

[timhall]

I've updated the RestRequest class to allow Variant parameters for AddParameter() and AddQuerystringParameter() and have successfully tried it with the following example:

Dim PostRequest As New RestRequest
PostRequest.Method = httpPOST

PostRequest.AddParameter "Integer", 20
PostRequest.AddParameter "Double", 3.14
PostRequest.AddParameter "Boolean", True

Debug.Print PostRequest.Body
' -> {"Integer":20,"Double":3.14,"Boolean":true}

PostRequest.Method = httpGET
Debug.Print PostRequest.FormattedResource
' -> ?Integer=20&Double=3.14&Boolean=True

To update your spreadsheet, remove the existing RestRequest class and add the updated version (1.0.2). Seems to be working better now, but let me know if you have any other issues.

[RibeyeOnTheBone]

Tim,

Not only helpful software but helpful support as well! If you are ever in London I owe you a pint.

I will test that now and revert is there are any problems.

Greg