WINHTTP / JSON post body to include search array from excel

Hi all,

first of all - my apologies for this question and perhaps my follow up. I'm just dabbling with this first and do not have a thorough background in javascript/jquery (or is this PHP?).

However, my question is this: I pull data from a website via a winhttp request in excel. This website gives me a json from parameters I send in the body.

I found that I can add parameters by defining them - for example, I add #31 by adding as below into the body:

Please Login or Register  to view this content.

Now, I want to define which countries to pull. I can pull one by saying:

Please Login or Register  to view this content.

(this would include Sweden).

I can pull multiple by leaving the search empty, but adding:

Please Login or Register  to view this content.

which would give me all the country codes between "A" and "C".

However, what would I have to add if I wanted to look for an array of countries, let's say "SE, FI, NO, DE, UK" ? I have no clue how to add that in (or if it's possible at all).

Again, apologies for my question and limited knowledge, but I'm hoping that someone is able to help

Thanks!

Jasper

ps - crossposted here

JasperD's desperately yet full of hope glancing at Kyle123 from across the board...

Yes, Kyle is awesome generally. He's virtually saved my life on many occasions.

I've gone over your thread - doesn't look like you had the same issue, so I guess you just meant you needed something from him, not specifically this

I've been digging deeper and it seems like my correct question should be:
"Get DATATABLES JSON with OR search on a column via VBA HTML request body"

I cannot do anything server side, just client side, but seems like it's not possible to do an OR search....

Hi, I believe that if you pass an empty string it will return unfiltered results. Searching for multiples like that in datatables isn't supported, so I'd be surprised if it's possible, though it's not being the reasons of possibility that whoever's created the service has implemented this. Is there any way to do that on the page? If not I suspect you're out of luck.

If you want to read up on the params you can pass, the site is using server side processing, explicitly using the legacy version of datatables

Hi Kyle,

many thanks for your reply - sadly this was not what I was hoping for, but I did fear it was that way.
There's no way to do it on the site, so I guess I'm out of luck. My approach now will be to send several XML requests with just one filter (IF I can get them to work with cookies) at once and just wait until they're all done instead of one by one. Hopefully that will work.

I'm looking at http://www.datatables.net at server side processing part, but don't find a list of parameters there.
Am I (my usual) blind or should I look somewhere else? Also, would there be a way to find the code on our site and pick all the possible parameters from there?

Thanks,

Jasper

XMLHTTP doesn't seem to carry forward the cookie / authentication information as needed (+ it won't work with SetAutoLogonPolicy AutoLogonPolicy_Always) - so is there a way to not wait for a WinHTTP request to be completed in VBA?

Seems there is no difference between
.Open "GET", url, False
and
.Open "GET", url

In XMLHTTP the latter would continue the VBA and I could test for it being ready by checking all readystates...
Can I do the same somehow with WinHTTP?

A quick google turned this up: https://stagesolutions.wordpress.com...http-with-vba/

RE the parameters: http://legacy.datatables.net/usage/server-side

Hi Kyle,

awesome!
Regarding the parameters - I don't see the ones I found I can use as well (sRangeStart, sRangeType and sRangeEnd) so there might be custom ones if I'm not mistaken. But how would I find out what are all parameters available from our site?
Thanks,

Jasper

You can't really, ask the person who made it?