web
You’re offline. This is a read only version of the page.
close
Skip to main content
Community site session details

Community site session details

Session Id :
Small and medium business | Business Central, N...
Answered

How to get Vendor Bank Account information from API

(0) ShareShare
ReportReport
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!

I have the same question (0)
  • Suggested answer
    Inge M. Bruvik Profile Picture
    1,045 Moderator 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

  • Verified answer
    YUN ZHU Profile Picture
    92,766 Super User 2025 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

  • ProductRa Profile Picture
    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.

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

    Would it be possible using dimensions lines?

  • Suggested answer
    YUN ZHU Profile Picture
    92,766 Super User 2025 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
    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
    Inge M. Bruvik Profile Picture
    1,045 Moderator 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.

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

Responsible AI policies

As AI tools become more common, we’re introducing a Responsible AI Use…

Abhilash Warrier – Community Spotlight

We are honored to recognize Abhilash Warrier as our Community Spotlight honoree for…

Leaderboard > Small and medium business | Business Central, NAV, RMS

#1
Rishabh Kanaskar Profile Picture

Rishabh Kanaskar 4,330

#2
Sumit Singh Profile Picture

Sumit Singh 2,738

#3
Nimsara Jayathilaka. Profile Picture

Nimsara Jayathilaka. 2,546

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans