Connectors

/

Ramp

/

Audit Ramp users against Dynamics 365 Business Central employees
Report
Cross-Connector

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.

Try PopdockAI free
Get a live demo
Audit Ramp users against Dynamics 365 Business Central employees
Audit our Ramp users against Business Central employees and tell me who still has Ramp access after leaving the company.
2 Ramp users are active but their Business Central employee is not. - Highest risk: Jordan Lee, Ramp role Admin, employee status Inactive - Also active: Priya Nair, Ramp role Employee, employee status Terminated - No employee record: 3 Ramp users - Ambiguous: 1 user matched several employees by name Want the full tables for the unmatched users and email mismatches?
Ramp
Sample figures. Your results come from your own account.
ramp-get-user

On this page

The problem

The problem

The prompt

Who it's for

How it works

Tools used

Connector

Ramp

Ramp
Run it on your own Ramp data.

Connect Ramp, pick your AI tool and paste the prompt.

Try PopdockAI free

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.

Prompt
**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.

Your AI tool

02

Match

It finds each Ramp user's Business Central employee by number, or by name checked against email.

ramp-get-user

03

Compare

It flags active users whose employee is not active, users with no employee and email mismatches.

No items found.

04

Report

You get tables, both raw statuses and counts, with deactivation recommended but never done.

Your AI tool

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.

get-data

ramp-get-user

Returns Ramp users as read from the Ramp connector. Filters include: scheduled invitation date to, status, last name, maximum records, role.
Read only.Nothing in Ramp Changes

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.

How Popdock AI secures your data

The outcome

Leavers with live Ramp access found before misuse

Try PopdockAI free
Get a live demo

Related use cases

More ways to put this data to work

All Ramp use cases

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.

Try PopdockAI Free
See Documentation