Skip to main content

Notifications

Small and medium business | Business Central, N...
Answered

How to get Vendor Bank Account information from API

Posted on by 20

Hi Experts,

Im looking a way through the API to get Vendor:

  • Payments information (Preferred Bank Acount)
  • Vendor Bank Account Card information
    • name, address, postcode, bank sort code, bank account number
  • Tax information
    • assessed code, PAN Details, GST section.

Any help in how to get all this data through the APIs

Thanks in advance!

  • Suggested answer
    Inge M. Bruvik Profile Picture
    Inge M. Bruvik 32,748 Super User 2024 Season 1 on at
    RE: How to get Vendor Bank Account information from API

    The standard API's are not country specific.

    But you can create a custom API to cover your need.

  • ProductRa Profile Picture
    ProductRa 20 on at
    RE: How to get Vendor Bank Account information from API

    Thanks!!

    Do you know if the API is different per country? Im working with the US api, and I cant find any of the next fields:

    Payments information

    - (Preferred Bank Acount)

    - Vendor Bank Account Card information

    name, address, postcode, bank sort code, bank account number

    - Tax information

    assessed code, PAN Details, GST section.

    This are from a person in India, so I wonder if the API is country specific.

    Thanks

  • Suggested answer
    YUN ZHU Profile Picture
    YUN ZHU 73,339 Super User 2024 Season 2 on at
    RE: How to get Vendor Bank Account information from API

    Hi, you can create two API pages and use $expand to get all the related data.
    More details: https://yzhums.com/6117/#toc13

    PS: Can we extend standard APIs? – Download Standard Source Code for APIs
    https://yzhums.com/20960/

    Hope this helps.

    Thanks.

    ZHU

  • ProductRa Profile Picture
    ProductRa 20 on at
    RE: How to get Vendor Bank Account information from API

    Would it be possible using dimensions lines?

  • ProductRa Profile Picture
    ProductRa 20 on at
    RE: How to get Vendor Bank Account information from API

    One doubt.

    The use case I have right now is that I have users that have added their vendor's information in the UI and I want to get all the data from that vendors through the API.

    From what I read in the custom API link (you shared), I won't be able to get that, right? since I need to add that information in the custom API to later retrieve it.

  • Verified answer
    YUN ZHU Profile Picture
    YUN ZHU 73,339 Super User 2024 Season 2 on at
    RE: How to get Vendor Bank Account information from API

    Hi, Another simple way is to use Web Services (Odata).

    For example,

    You can add the fields you need to the page first.

    pastedimage1682378991823v1.png

    pastedimage1682379017192v2.png

    pastedimage1682379038245v3.png

    pastedimage1682379092554v4.png

    Hope this helps as well.

    Thanks.

    ZHU

  • Suggested answer
    Inge M. Bruvik Profile Picture
    Inge M. Bruvik 32,748 Super User 2024 Season 1 on at
    RE: How to get Vendor Bank Account information from API

    The standard API's from Microsoft does not cover then information you need.

    So you will have to create a custom API to get this information.

    Please refer to this documentaion:

    learn.microsoft.com/.../devenv-develop-custom-api

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

December Spotlight Star - Muhammad Affan

Congratulations to a top community star!

Community AMA December 12th

Join us as we continue to demystify the Dynamics 365 Contact Center

New! Quick response templatesâš¡

Save time with the new custom templates!

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 291,228 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 230,056 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans