How to create dynamic tables based on user-meta-data

Hello support,

I want to create a json based table. I already own the Pro Version. I already know how to do this generally.

My Problem:

The php file which generates the json data, is not executed as the user which is actually logged in to the page and viewing the Table.

I want to do something like that in my php file which generates the json:

$userid = get_current_user_id();
$specificID = get_user_meta($userid ,"key_of_the_meta_data",true);
$statement = $pdo->prepare("SELECT * FROM example WHERE id = $specificID");

The problem is, the functions get_current_user_id() and get_user_meta() aren’t executed by the logged in user.

Is there a possibility/setting to change that? I need a solution where the json / serialized array generating script is executed as logged in user. How to do that?

Thanks and best regards,
Toni