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

Announcements

No record found.

News and Announcements icon
Community site session details

Community site session details

Session Id :
Dynamics 365 Community / Forums / Small and medium business | Business Central, N... / Querying odata.nextlin...
Small and medium business | Business Central, N...
Suggested Answer

Querying odata.nextlink Times Out

(0) ShareShare
ReportReport
Posted on by pforsberg 15

Hi, 

We have developed an integration to the Business Central v3 OData. We have a source query object that contains 725,000 transactions and when we query for this object we get the first 625,000 in under 2 minutes. at the bottom of the result set is an odata.nextlink that we then send a request for but this always times out after 8-10 minutes. It seems strange that we are timing out on the next odata result set that is only 1/6th the size of the first, successful result set. 

Has anyone experienced this any have any suggestions as to what might be causing this. We are basically passing off these two requests. 

  • Suggested answer
    THE Italian Profile Picture
    THE Italian Microsoft Employee on at

    OData V3 endopoint is no longer maintained and will be deprecated (completely removed) from the service stack in the upcoming 2021 spring release. This is documented here 

    Deprecated Features in W1 - Business Central | Microsoft Docs

    ...

    OData V3

    The following feature will be Removed with Business Central 2021 release wave 1.

    Moved, Removed, or Replaced? Why?
    Removed OData V3 has been superseded by OData v4. OData V3 will be deprecated as of Business Central 2021 release wave 1. It's recommended that integrations are migrated to OData v4 as soon as possible.

    ...

    There is also a simple query to find out if your customers are implementing OData V3 in the aka.ms\bctelemetrysamples 

    BCTech/samples/AppInsights/KQL/Queries at master · microsoft/BCTech (github.com)

    pastedimage1606296193928v1.png

    See below 

    // KQL samples - Deprecated Web Service Protocols
    // Endpoints exposed from Business Central using Odata v3 has been deprecated and the feature will removed in Business Central 2021 release wave 1
    // See docs.microsoft.com/.../deprecated-features-w1
    // Usage of Odata v3 endpoints in the last 30 days
    traces
    | where timestamp > ago(30d) // change if your retention policy is different than the default
    | where operation_Name == "Web Services Call" // do note that in a later version of the schema, this field will not be used
    or customDimensions.eventId == "RT0008" // starting from version 16.1, the eventId is used to identity signal types
    | where customDimensions.category == 'ODataV3'
    | project timestamp
    , aadID = customDimensions.aadTenantId
    , environmentType = customDimensions.environmentType
    , environmentName = customDimensions.environmentName
    , endpoint = customDimensions.endpoint
    // list of endpoints using OData v3 in the last 30 days
    traces
    | where 1==1
    and timestamp > ago(30d)
    and customDimensions.eventId == 'RT0008'
    and customDimensions.category == 'ODataV3'
    | project aadId = tostring( customDimensions.aadTenantId )
    , environmentName = tostring( customDimensions.environmentName )
    , category = tostring( customDimensions.category )
    , endpoint = tostring( customDimensions.endpoint )
    | distinct aadId
    , environmentName
    , category
    , endpoint
  • pforsberg Profile Picture
    pforsberg 15 on at

    Hi Duilio, thank you for the information. I have done some research and tested using OData v4 and it behaves these same way.

  • Suggested answer
    THE Italian Profile Picture
    THE Italian Microsoft Employee on at

    If you could reproduce the same with ODataV4 then you might have your CSP Partner open a request on your behalf to Microsoft support.

  • pforsberg Profile Picture
    pforsberg 15 on at

    Thanks Duilio, we will take a look with Odata v4.

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

Season of Sharing Community Challenge Winners!

Congratulations to our community stars!

Women in Power Builds Momentum

Expanding mentorship, skilling, and AI innovation

Congratulations to the August Top 10 Community Leaders

These are the community rock stars!

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

#1
OussamaSabbouh Profile Picture

OussamaSabbouh 715 Super User 2026 Season 2

#2
YUN ZHU Profile Picture

YUN ZHU 452 Super User 2026 Season 2

#3
AndrewThomas81 Profile Picture

AndrewThomas81 371 Super User 2026 Season 2

Last 30 days Overall leaderboard

Featured topics

Microsoft Training Manuals

Product updates

Dynamics 365 release plans