Help Needed: Accessing Invoice/Contracts/Quote Line Items in SuiteCRM

[yelmo]

Hello everyone!

I’m trying to retrieve Invoice/Contracts/Quote Line Items in SuiteCRM using a specific query, but I’m having trouble and haven’t found much guidance in the documentation or forum.

I used the following query:

aos_products_invoices.parent_id = 'c014521a-e038-2348-b88d-677a8fdecafc' AND aos_products_invoices.parent_type = 'AOS_Invoices'

However, I’m encountering this error:

RuntimeError: Access Denied [40]: You do not have access

Origin: SuiteCRM 7

Has anyone experienced this issue before? Any help or advice would be greatly appreciated!

Thank you in advance!

[pgr]

Where are you entering that query? Is that phpMyAdmin, or some other SQL console?

Make sure to give that software sufficient database permissions.

[yelmo]

I’m traying to doit using Make.com formely integromat