Skip to main content

Notifications

Small and medium business | Business Central, N...
Suggested answer

How to store a Hexadecimal value in Business Central?

Posted on by 60

Hi Experts,

I tried to recreate the scenario by first converting a text, decimal and date fields into hexadecimal

and further converting the concatenated result value to Base64 by using Base64Convert Codeunit.

But the BC Base64 conversion is giving different result than the actual Hex to Base64 conversion result from online.

Later I realized the the Hex results which I am storing in text variable in BC is actually converting text to Base64 instead of Hex to Base64.

Could you please guide me how to store a Hexadecimal in BC and convert it to Base64 ?

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 store a Hexadecimal value in Business Central?

    Maybe you can find something useful in this video from Eric:

    www.youtube.com/watch

    Business Central does not have a seperate datatype for handling HEX. But you could of course integrate to an Azure function for handling you HEX data.

    learn.microsoft.com/.../

  • Pushparaj Kohli Profile Picture
    Pushparaj Kohli 60 on at
    RE: How to store a Hexadecimal value in Business Central?

    Hi Bilal,

    Thanks for the answer.

    But I already converted my Text to HEX.

    The Problem is with Converting the HEX to Base64 format.

    It's because I can only able to store the Value of  Hexadecimal In Text Variable.

    And When I tried to Convert that Hexadecimal value which is stored in a Text Variable, BC trying to convert that as TEXT to BASE64 not HEXADECIMAL to BASE64.

    That's why I am asking is there any way to store the HEXADECIMAL value as a specific data type and as it is.( HEXADECIMAL to BASE64).

  • Suggested answer
    Bilal Haider Profile Picture
    Bilal Haider 45 on at
    RE: How to store a Hexadecimal value in Business Central?

    Hi,

    Please follow the way in post to convert to Hex.

    community.dynamics.com/.../convert-text-to-hex

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!

Top 10 leaders for November!

Congratulations to our November super stars!

Community AMA December 12th

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

Leaderboard

#1
André Arnaud de Calavon Profile Picture

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

#2
Martin Dráb Profile Picture

Martin Dráb 230,149 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans