Microsoft Dataverse \ Dynamics 365 CE/CRM

Questions
1

Hey,

How have others retrieved data from Microsoft Dataverse?

I noticed there’s a Dynamics CRM node, but it only supports accounts. :confused:

It would be great to have a Microsoft Dataverse node that dynamically updates based on the table schema, pulling metadata via the service.

But I cant see that, I could write JavaScript to fetch the data, or for specific tables, I suppose the HTTP requester could work. Alternatively, using JavaScript directly might be an option.

What’s the recommended approach?

Thanks in advance!

2

It looks like your topic is missing some important information. Could you provide the following if applicable.

  • n8n version:
  • Database (default: SQLite):
  • n8n EXECUTIONS_PROCESS setting (default: own, main):
  • Running n8n via (Docker, npm, n8n cloud, desktop app):
  • Operating system:
3

I don’t think this is really relevant to the question as I can use anything I choose to solve this issue.

4

Hey,

I ran into a similar situation and ended up creating a custom n8n node that might be exactly what you’re looking for. It dynamically interacts with Microsoft Dataverse, pulling metadata and allowing you to work with any table, not just accounts. You can check it out here: npm i n8n-nodes-dataverse.

This custom node handles authentication and provides more flexibility compared to the built-in Dynamics CRM node. It could save you from having to write custom JavaScript or rely solely on the HTTP request node.

Hope it helps! Let me know if you have any questions.

5

@Theuns_Barnardt : Thanks for developing this node. I cant really get the hang of it. Auth works, but i am unable to post a value in a lookup field. Any suggestions what im doing wrong?

image
image1330×1374 205 KB