I need a ‘Right-Click’ action that calls an external API endpoint using an API key.
Here’s the scenario:
We have created a custom logical unit table that stores incoming prospect information from our website displayed in a grid. I have created a custom context menu option (Push to Salesforce) that pops up correctly, but what I need to do is attach an action to that click that pulls specific column data from the row, and calls the API endpoint (https://test.endpointurl.com/v1/customer/{person_id}).

It’s a GET method that accepts the PERSON_ID from the data row that was clicked.
I’ve found a few posts that discuss how to call the REST API using the PL/SQL BLOCK method, but none address my two specific challenges:
- How to implement the API Key, not basic or bearer authorization
- How to pass column data into the parameters
Any guidance would be appreciated.