Skip to main content

Notifications

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

Generate GUIDs for API use

Posted on by 5

Hi,

I'm trying to create new customer via BC api v2, but examples available in documentation contains id and name values which I would like to be set automatically - generated GUID and next available customer number like C00020. Acording to documentation I need to POST JSON body like this:

{
    "id": "f2a5738a-44e3-ea11-bb43-000d3a2feca1",
    "number": "10000",
    "displayName": "Adatum Corporation",
    "type": "Company",
    "addressLine1": "192 Market Square",
    "addressLine2": "",
    "city": "Atlanta",
    "state": "GA",
    "country": "US",
    "postalCode": "31772",
    "phoneNumber": "",
    "email": "robert.townes@contoso.com",
    "website": "",
    "taxLiable": true,
    "taxAreaId": "90196a90-44e3-ea11-bb43-000d3a2feca1",
    "taxAreaDisplayName": "ATLANTA, GA",
    "taxRegistrationNumber": "",
    "currencyId": "00000000-0000-0000-0000-000000000000",
    "currencyCode": "USD",
    "paymentTermsId": "04a5738a-44e3-ea11-bb43-000d3a2feca1",
    "shipmentMethodId": "00000000-0000-0000-0000-000000000000",
    "paymentMethodId": "3b196a90-44e3-ea11-bb43-000d3a2feca1",
    "blocked": " ",
    "lastModifiedDateTime": "2020-08-21T07:38:44.293Z"
}

How to get id for new customer and 'next available' customer number?

When I omit id and number in request body I get "Invalid Request Body" error :/

  • Suggested answer
    jamescarrey Profile Picture
    jamescarrey 5 on at
    RE: Generate GUIDs for API use

    Thanks, Josh, for the helpful tip! Although I couldn't find an explicit option to select "No. Series"or UUID/Guid Generator for the Configuration template, I discovered that the issue actually resided in the JSON request body.

  • zielus Profile Picture
    zielus 5 on at
    RE: Generate GUIDs for API use

    Thank you ZHU! I modified my json request body and now works like a charm :)

  • Verified answer
    YUN ZHU Profile Picture
    YUN ZHU 71,565 Super User 2024 Season 2 on at
    RE: Generate GUIDs for API use

    Hi, If you set the default No. Series for the Customer in BC, as long as you omit these two fields, the system will automatically generate it.

    pastedimage1657499214816v2.png

    For example,

    [View:/cfs-file/__key/communityserver-discussions-components-files/758/Test0711.mp4:1181:885]

    Thanks.

    ZHU

  • Suggested answer
    zielus Profile Picture
    zielus 5 on at
    RE: Generate GUIDs for API use

    Thank you Josh for the tip! I couldn't find an option to choose No. Series for Configuration template but figured out that the problem was in json request body itself.

    I think example request body available here:

    docs.microsoft.com/.../dynamics_customer_create

    is not correct. I had to remove from request body "taxAreaDisplayName" and "lastModifiedDateTime" fields and I finally get "201 Created" response :) Of course I omitted "id" and "name" and that fields was generated automatically.

  • Suggested answer
    JAngle Profile Picture
    JAngle 33,157 on at
    RE: Generate GUIDs for API use

    Within BC search for api setup and verify the template assigned to table 18 has a no. series assigned to it

    59B64E5E_2D00_DB02_2D00_4940_2D00_8670_2D00_62C33587AFCE.jpeg
    then omit the fields from the POST action.

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

November Spotlight Star - Khushbu Rajvi

Congratulations to a top community star!

Forum Structure Changes Complete!

🔔 Be sure to subscribe to the new forums you are interested in to stay up to date! 🔔

Dynamics 365 Community Platform update – Oct 28

Welcome to the next edition of the Community Platform Update. This is a status …

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 290,900 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 229,275 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans