> For the complete documentation index, see [llms.txt](https://docs.erpbridge.io/llms.txt). Markdown versions of documentation pages are available by appending `.md` to page URLs; this page is available as [Markdown](https://docs.erpbridge.io/the-operation/2-database-mapping.md).

# 2 - Database Mapping

This step let you build a translation layer that permit the agent to properly retrieve data from a source and send it to the destination without the need to use the exact same database columns and HubSpot properties names.

Every row can be enabled/disabled using the toggle at the start of the row. When the toggle is OFF, the specific property or database column will be ignored when the data will be sent to the destination.

The central and core drop-down menus representing the database column and the HubSpot object property.

<mark style="color:orange;background-color:orange;">**IMPORTANT**</mark>: In case of HubSpot Drop-Down property make sure every internal value share the same value of the database data or it will return an error when the software will try to send data to HubSpot. For instance: if you have a drop-down property with values "lorem", "ipsum", "dolor" but in the database you have a different value or the same value but with different cases (like "Lorem"), the software will not save/update that record on HubSpot at all.

**\[Only for Database -> HubSpot operations] :** At the end of the row, is present a file checkbox. If it's checked the database column selected the software will read the data (file path or blob), upload the  file to HubSpot media and associate the media as attachment to the created/updated object.\
When the checkbox is checked, the HubSpot property is automatically disabled.

<figure><img src="/files/8iOkznW4xQOEZoqXYclp" alt=""><figcaption></figcaption></figure>

{% embed url="<https://www.youtube.com/watch?v=S6QBV1eVon4&t=327s>" %}
Database Mapping
{% endembed %}


---

# Agent Instructions
This documentation is published with GitBook. GitBook is the documentation platform designed so that both humans and AI agents can read, navigate, and reason over technical content effectively. Learn more at gitbook.com.

## Querying This Documentation
If you need additional information that is not directly available in this page, you can query the documentation dynamically by asking a question.

Perform an HTTP GET request on the current page URL with the `ask` query parameter, and the optional `goal` query parameter:

```
GET https://docs.erpbridge.io/the-operation/2-database-mapping.md?ask=<question>&goal=<endgoal>
```

`ask` is the immediate question: it should be specific, self-contained, and written in natural language.
`goal` is optional and describes the broader end goal you are ultimately trying to accomplish on behalf of the user. GitBook uses it to tailor the answer towards what is most useful for that goal.

The response will contain a direct answer to the question and relevant excerpts and sources from the documentation.

Use this mechanism when the answer is not explicitly present in the current page, you need clarification or additional context, or you want to retrieve related documentation sections.
