Getting exchange rates from a JSON web service in Business Central

[@michaelkraithat4852]

Thanks Erik, always wanted to know how to obtain data from JSON external web services… now I can apply this format to other area of BC as needed. Awesome video. 👏🏽

[@stevet.7218]

The content is on point as always - thanks so much Erik! Regards from Austria

[@eduschimu]

Thank you for this video! Very helpful.

[@oldsing-a-longsongs965]

Good video. One question. Can this also be done in the normal Business Central GUI using Data Exchange Definition, Currency Exchange Rate Services etc.. ? Rather than in an extension?

[@Hougaard]

You can try, not all formats can be consumed by the standard service

[@oldsing-a-longsongs965]

Is there a tutorial for that?

[@michaelkraithat4852]

If another Rest API provider do not provide ‘date’ in the rest call. How do I replace your current set up to take the todays date instead? Hope this makes sense.

[@Hougaard]

Depends on the other web service?

[@michaelkraithat4852]

@@Hougaard thank, just realised that the other web service will required a paid service to have Date shown and base currencies. Now it’s working fine after getting the paid version. Much appreciated for replying. Keep making cool videos. 👍🏼

[@anujchaudhary6985]

In my condition i did not find the root element of the Json file what should i do ?? please tell

[@Hougaard]

How does your json look?

[@anujchaudhary6985]

Thanks for your reply Erik...but i solved it that was a Array json which have 5 key elements

[@siddharthbhavsar3295]

I am getting this { "success": false, "error": { "code": 101, "type": "missing_access_key", "info": "You have not supplied an API Access Key. [Required format: access_key=YOUR_ACCESS_KEY]" } } while accessing the website so how can I overcome this issue ?

[@Hougaard]

No idea? I have ever seen that error? Check here github.com/openratesapi/openrates

[@siddharthbhavsar3295]

@@Hougaard thank you

[@anujchaudhary6985]

@@siddharthbhavsar3295 Same error brooo.....Did u find the solution???/

[@siddharthbhavsar3295]

@@anujchaudhary6985 yes I found the solution by using given link from EH.

[@anujchaudhary6985]

@@siddharthbhavsar3295 EH??. Please share with me that link

[@guidorobben6259]

Nice one. Maybe also make an video how to update to a json webservice?

[@ayoubbns6903]

Thank you very much for the video, could you please tell me why i am not able to convert jsonTken to JsonObject?

[@Hougaard]

yourtoken.AsObject() doesn't work?

[@ayoubbns6903]

@@Hougaard Thanks for the reply:: yeh indeed it dosen't work but I have used -rates.SelectToken(recCurr.Code, CodeCurr) instead and looks good now

Great Erik. I love your videos. They are crystal clear and they solve a lot of doubts. Just one question. What about if you need to authenticate to the web service with Basic Auth? Ta.....

[@Hougaard]

Then you need to add an Authorization header.... to the HttpMessasgeRequest

[@cnclover]

Thank you! Can you tell as about events in your next video's?

[@Hougaard]

Which ones?

[@cnclover]

@@Hougaard Events, which switch off standard code and working your extension code.

[@10GIZChipashvili]

Thank you, I found this video very usefull

[@PerfumoPeru]

It's not free anymore :(

[@Hougaard]

I know, I think you can find another video on the channel where I switch to another provider.