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

Consuming Job Queue Entry in Power Automate

(0) Share

Report

Posted on by Abdullah Zafar

Hi,
I have exposed an API for the Job Queue Entry table and want to consume that in Power Automate, Unfortunately, when I try to consume the API through the Business central connector's default triggers ( When a record is changed, When a record is modified) if am not able to find table/entity name as shown in picture. I have tried with the API page and V2 API (Published from Web Services page).

However, If I try to consume some other tables, like the Item table then it worked fine, Can someone guide me about this? Is there any sort of restriction on the Job queue Entry table?
Is there any permission that I am missing?
Best Regards.

All responses (3)

Answers (0)

Sort by

Suggested answer

Steven Renders 5,698 Moderator on at

Like (0)

Report
Copy link

Link copied!

Is it for BC Saas or BC On Prem? Power Automate and Power Apps are currently not able to connect to any custom APIs in BC On Prem. Power BI has no problem with that.
So that might be the reason?
Abdullah Zafar 85 on at

Like (0)

Report
Copy link

Link copied!

[quote user="Steven Renders"]
Is it for BC Saas or BC On Prem? Power Automate and Power Apps are currently not able to connect to any custom APIs in BC On Prem. Power BI has no problem with that.
So that might be the reason?
[/quote]
Hi
Thanks for the reply,
I am trying on SaaS version. I have used the same API in Canvas app as data source and it’s working. Moreover, I am able to use functions like (Get records) but not able to use triggers for Job query entry
Finn1980 21 on at

Like (0)

Report
Copy link

Link copied!

I'm facing this same issue when trying to set up automated notifications on job queue errors. I'm trying to set up a trigger on a custom API page but it's not showing up (first screenshot). It does show up when setting up an action (second screenshot). I'm using a 3rd party app to expose APIs called Simple Object Designer. Funny thing is the other APIs I've created show up, but not the job_Queue_Entrys API. It shouldn't be this difficult to get notified of when a job queue errors. This should be native functionality @Microsoft!