Help to Get data from API and with KEY

[nordicdust]

Hi

I am trying to pull information from an API but I can't work out how to do the coding.
We use workbook connection with Power Query now to get the data, But I think it reads 100 or 200 rows at a time and it takes quiet some time.
We would like to use it in a VBA application wee already have, so I was asked to get this part done.
I have never used API to get data before, so I am a bit lost.
I have looked online and found som templates, but I am still a bit lost.

I have been provided the below in relation to the API and I have my API key to add in but would appreciate it if someone could assist with how I need to code it.

Please Login or Register  to view this content.

I have attaced a sample WB with Sheet ("Rooms") and the table in it.

The WB with template code I found online is this also attaced, (TEMPLATE)

[nordicdust]

I have changed the title as there has been no responce. I thought that it might have been a poor title.

Is there anything else I can show if my problem is not clear.

I would realy appriciate some help.

[Marc L]

Hi,

as we can't obviously try so difficult to help …

[nordicdust]

Thanks Marc

I will try and write the code and se witch errors I get, and maybe someone can help with the errors or syntax.

[nordicdust]

Hi,

I can get data now, but I need to paste it in my table, I will need help for that.
I have attaced a Text file where you can see the data i get, and the picture shows the table.

My code as is now.

Please Login or Register  to view this content.

can I provide any other information to get a litle help.

[Marc L]

I have no clue where comes your 'JsonConverter' but it seems to convert nothing !
And obviously the request status must be checked before to convert anything …

Different ways to extract Json data, a sample in this thread …

[mogul]

You might want to check out this Youtube video

[nordicdust]

Thanks, I have seen that.

[nordicdust]

Ok, so now I kan get all the data from the api
This is my code, and please feel free to come with improvements :-)

Please Login or Register  to view this content.

Can someone help with getting the nextBookmark value from the metadata from the api?
This is the metadata from the api:

Please Login or Register  to view this content.