json - passing userid and password in xml request -

i have potential client wants pull data website via vba. new xml , json.

i found link somewhere provides following code uses msxml return data single item particular website.

public function getitemsaleprice(item string) double dim dblitem long createobject("msxml2.xmlhttp")     .open "get", "http://www.gw2spidy.com/api/v0.9/json/item/" & item, false     .send     dblitem = split(split(.responsetext, "min_sale_unit_price"":")(1), ",")(0)     getitemsaleprice = dblitem / 100 end end function 

however, data client wants return comes in pages of 500 records @ time. indicates wants pass in date ranges, , page number, similar following.

https://api.appfigures.com/v2/reviews?client_key=xxxxxxxf&start=2015-01-01&end=2016-01-21&page=1

but because https site, wants userid , password. can reformat string include userid , password? or there method or property of msxml object can set authentication?

the client indicates return value looks like:

{ "total": 140, "pages": 28, "this_page": 1, "reviews": [{     "author": "developertodeveloper",     "title": "just spectacular",     "review": "finally able remove ads! description hilarious!! thanks!!!",     "original_title": null,     "original_review": null,     "stars": "5.00",     "iso": "us",     "version": "1.2",     "date": "2012-09-19t17:05:00",     "product": 6567539,     "weight": 0,     "id": "5561747l7xnbsmru8ubpvy7a71dv6a==" }] } 

but multiple records returned, many 500 @ time. there efficient way of reading data in format table? 1 or more records @ time? can write text parser assume has done leg work.

thanks bob. if figured out authentication issue, popup dialog used enter userid , password , client satisfied that.

and given structure of returned string, able parse data myself without difficulty.