Generate GUIDs for API use

(0) Share

Report

Posted on by zielus

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 :/

I have the same question (0)

All responses (5)

Answers (1)

Suggested answer

JAngle 150 on at

Like (1)

Report
Copy link

Link copied!

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

then omit the fields from the POST action.

Was this reply helpful? Yes No
Suggested answer

zielus 5 on at

Like (0)

Report
Copy link

Link copied!

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.

Was this reply helpful? Yes No
Verified answer

YUN ZHU 98,421 Super User 2026 Season 1 on at

Like (1)

Report
Copy link

Link copied!

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.

For example,

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

Thanks.

ZHU

Was this reply helpful? Yes No
zielus 5 on at

Like (1)

Report
Copy link

Link copied!

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

Was this reply helpful? Yes No
Suggested answer

jamescarrey 5 on at

Like (0)

Report
Copy link

Link copied!

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.

Was this reply helpful? Yes No