I am working with Oracle APEX version 24.1.4 and calling a Jira API to fetch issue data. The challenge I’m facing is that Jira uses an offset of 0 for the first record, while Oracle REST Data Source (RDS) seems to default to 1.
With my setup, pagination works, but the mismatch in offsets causes the API to skip the first record.
I’ve already configured the Row Offset URL Parameter in my REST Data Source to use startAt, which Jira expects. However, I haven’t been able to figure out how to dynamically adjust the value sent for startAt to align with Jira’s 0-based indexing. Ideally, I need to set the offset, but I can’t find where or how to configure this adjustment in APEX.
Can someone help guide me on how can address this issue?
Sample JSON from Jira
{
"startAt" : 0,
"maxResults" : 50,
"total" : 0,
"issues" :
[
]
}
My RDS pagination settings.
