Getting exchange rates from a JSON web service in Business Central

แชร์
ฝัง
  • เผยแพร่เมื่อ 14 ต.ค. 2024
  • Find more information at my blog www.hougaard.com or follow me on / ehougaard
    Source code can be found here: github.com/hou...

ความคิดเห็น • 31

  • @michaelkraithat4852
    @michaelkraithat4852 2 ปีที่แล้ว +1

    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
    @stevet.7218 2 ปีที่แล้ว

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

  •  3 ปีที่แล้ว +2

    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
      @Hougaard  3 ปีที่แล้ว

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

  • @eduschimu
    @eduschimu 2 ปีที่แล้ว

    Thank you for this video! Very helpful.

  • @oldsing-a-longsongs965
    @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
      @Hougaard  ปีที่แล้ว

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

    • @oldsing-a-longsongs965
      @oldsing-a-longsongs965 ปีที่แล้ว

      Is there a tutorial for that?

  • @guidorobben6259
    @guidorobben6259 3 ปีที่แล้ว

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

  • @10GIZChipashvili
    @10GIZChipashvili 3 ปีที่แล้ว

    Thank you, I found this video very usefull

  • @michaelkraithat4852
    @michaelkraithat4852 2 ปีที่แล้ว

    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
      @Hougaard  2 ปีที่แล้ว +1

      Depends on the other web service?

    • @michaelkraithat4852
      @michaelkraithat4852 2 ปีที่แล้ว

      @@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. 👍🏼

  • @ayoubbns6903
    @ayoubbns6903 3 ปีที่แล้ว

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

    • @Hougaard
      @Hougaard  3 ปีที่แล้ว

      yourtoken.AsObject() doesn't work?

    • @ayoubbns6903
      @ayoubbns6903 3 ปีที่แล้ว

      @@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

  • @cnclover
    @cnclover 3 ปีที่แล้ว

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

    • @Hougaard
      @Hougaard  3 ปีที่แล้ว +1

      Which ones?

    • @cnclover
      @cnclover 3 ปีที่แล้ว +1

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

  • @siddharthbhavsar3295
    @siddharthbhavsar3295 3 ปีที่แล้ว

    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
      @Hougaard  3 ปีที่แล้ว +1

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

    • @siddharthbhavsar3295
      @siddharthbhavsar3295 3 ปีที่แล้ว

      @@Hougaard thank you

    • @anujchaudhary6985
      @anujchaudhary6985 3 ปีที่แล้ว

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

    • @siddharthbhavsar3295
      @siddharthbhavsar3295 3 ปีที่แล้ว

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

    • @anujchaudhary6985
      @anujchaudhary6985 3 ปีที่แล้ว

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

  • @anujchaudhary6985
    @anujchaudhary6985 3 ปีที่แล้ว

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

    • @Hougaard
      @Hougaard  3 ปีที่แล้ว

      How does your json look?

    • @anujchaudhary6985
      @anujchaudhary6985 3 ปีที่แล้ว

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

  • @PerfumoPeru
    @PerfumoPeru 2 ปีที่แล้ว

    It's not free anymore :(

    • @Hougaard
      @Hougaard  2 ปีที่แล้ว

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