/
/
Find Ramp users who have left Business Central
For IT and finance teams who want to see who still has Ramp access after leaving, just by asking their AI assistant.
On this page
Connector
Connect Ramp, pick your AI tool and paste the prompt.
The problem
Leavers keep their Ramp cards after they leave
Leavers keep Ramp access because nobody compares Ramp users with Business Central employees. Checking means opening both systems and matching people by number or name, and lookalike names make it easy to match the wrong person.
Without PopdockAI
- Export Ramp users and Business Central employees
- Match people by number or name by hand
- Check each employee's status
- Match the wrong person on a shared surname
With PopdockAI
- Each Ramp user matched by employee number, or name checked against email
- Active users whose employee is not active flagged with their role
- Unmatched users and email mismatches listed
- Ambiguous people marked, and deactivation only recommended
The prompt
Use this prompt
Copy it into any AI tool connected to PopdockAI. Swap the values in braces for your own.
**Objective:** Compare Ramp users with Business Central employees and report leavers who still have Ramp access, users with no employee record, and mismatched details. Limit to Ramp users with last name containing `{last-name}` when given. Read-only.
**Step 1: Read Ramp users**
Call `ramp-get-user` (Ramp server) with `last-name.contains` set to `{last-name}` when given and `max-records` 200. Keep `id`, `first-name`, `last-name`, `email`, `employee-id`, `role`, `status`.
**Step 2: Find each employee**
For each user call `business-central-get-employee` (Business Central server): with `employee-number` set to the Ramp `employee-id` when that is present, otherwise with `last-name` and `first-name` from Ramp. Keep `employee-number`, `status`, `email`, `company-email`, `job-title`, `employment-date`. Confirm a name match by also comparing email; never assume a surname alone is the same person.
**Step 3: Report**
Tables for: Ramp users whose status is active but whose employee `status` is not active (highest risk, list their Ramp `role`); Ramp users with no employee found; Ramp users whose email matches neither employee email; employees found by name only because the Ramp `employee-id` was empty. Finish with counts.
**Rules & Guidelines:**
* `ramp-get-user` is on the Ramp server; `business-central-get-employee` is on the Business Central server.
* Read-only. Do not call `ramp-user-deactivate`, `ramp-user-update` or `business-central-update-employee`; recommend deactivation in the report instead.
**Validation:**
* If Ramp returns no users, say so and stop.
* If a name search returns several employees, list the candidates and mark the user as ambiguous.
* Business Central employee status values are not Ramp's; show both raw values.Who it's for
One answer, three teams that use it
IT administrators
Remove access for people who have left
Active Ramp users with an inactive employee record are listed with their role.
Which Ramp users are no longer active employees in Business Central?
HR managers
Close the gap between HR and spend access
See who still holds a Ramp card after leaving, with both systems' statuses as evidence.
Check Ramp users against Business Central employees and show anyone who left but still has access.
Internal auditors
Test leaver controls with evidence
Raw statuses from both systems and match method make the findings easy to verify.
Audit Ramp users with the last name Garcia against Business Central employees.
How it works
What PopdockAI does when you ask
You request the audit and your AI assistant compares Ramp users with Business Central employees. It never matches on a surname alone and changes nothing in either system.
01
Ask
You request the audit, optionally for one last name.
02
Match
It finds each Ramp user's Business Central employee by number, or by name checked against email.
03
Compare
It flags active users whose employee is not active, users with no employee and email mismatches.
04
Report
You get tables, both raw statuses and counts, with deactivation recommended but never done.
What PopdockAI provides
The tools behind the answer
Ready made tools for Ramp and one secure connection to your AI tool. No code, no exports.
ramp-get-user
This report is built from Get data tools only. PopdockAI applies the row, field and parameter rules your admin sets, and every query is written to the audit trail.
The outcome
Leavers with live Ramp access found before misuse
Related use cases
More ways to put this data to work
One prompt template with infinite possibilities.
Your AI assistant adapts its approach, tone, and capabilities to match each unique context while you maintain a single, manageable workflow.
Join forward-thinking companies that are transforming their operations with intelligent, secure AI automation.

.webp)
