Ebay integration with BC token issue

(1) Share

Report

Posted on by CU04091421-0

Hello there,
I'm working on an API integration Ebay with business central (trying to fetch Ebay orders and show it on bc), but the token i got from Ebay has a length of more than 2350+, i cannot store this
value on bc due to the field size limitation of 2048. what are my options i want to reference my field "Access Token" Text [2048] as the token on all the endpoints.

business central (Cloud)

Categories:

Dynamics 365 Business Central

All responses (4)

Answers (1)

Suggested answer

YUN ZHU 74,148 Super User 2024 Season 2 on at

Like (1)

Report

Ebay integration with BC token issue

I think what Valentin means is that you store the value in the Blob of the table, not in the Text of the table.

Then when reading this blob field, you can read it into a text variable. The length of the Text variable is much larger than 2048.

You can refer to the standard work description approach.

PS: https://yzhums.com/?s=work+description

Hope this helps.

Thanks.

ZHU
CU04091421-0 14 on at

Like (0)

Report

Ebay integration with BC token issue

Hi, Valentin

It was just as you said I was able to store my token in a blob field. I took reference from the standard sales header table - "Work description". I copied over both the functions and used outstream to store the token and used instream to read the value inside. I presume thats how it works based on my understanding.

Thanks a lot!
CU04091421-0 14 on at

Like (1)

Report

Ebay integration with BC token issue

hi valentin,

if i use it as blob i cannot convert the jsontoken which stores the ebay token into text. at the very least jsontoken cannot convert to a blob from what i understand , neither does it support operators.

i added some screenshots for reference
Verified answer

Valentin Castravet 24,961 Super User 2024 Season 2 on at

Like (2)

Report

Ebay integration with BC token issue

You can create a blob field in Business Central which can store more than 2048 characters - Blob Data Type - Business Central | Microsoft Learn

Valentin Castravet
Work: Zander ERP Services
Blog: Dynamics 365 Business Central Insights
LinkedIn: www.linkedin.com/in/valentin-c-0500a247/