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.

I have the same question (0)

All responses (3)

Answers (0)

Suggested answer

Steven Renders 5,672 Moderator on at

Like (0)

Report

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?

Was this reply helpful? Yes No
Abdullah Zafar 85 on at

Like (0)

Report

[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

Was this reply helpful? Yes No
Finn1980 21 on at

Like (0)

Report

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!

Was this reply helpful? Yes No