Skip to main content
Answer

Insert/update data from one Tenant to another Tenant

  • July 13, 2022
  • 7 replies
  • 500 views

Hello,

I need to know if it is possible to insert/update data from a Tenant(Develop) to another Tenant(Production) by code. I have not found any information about that.

Thanks.

 

 

Best answer by purwandaruw

@alejandroalvarado64 in that case I’d suggest something like calling REST API of the another tenant. You can trigger the REST API call using business events/push notifications in the source tenant.

I’m going to go deeper into those topics! Thanks for the guide @Dmitrii Naumov 

Hi @alejandroalvarado64 

We’re doing this for master data such as stock items. When users create on one tenant as master, will duplicate in other tenants. My teams using API to do this. So i think that’s the best approach.

Daru

7 replies

Dmitrii Naumov
Acumatica Moderator
Forum|alt.badge.img+7
  • Acumatica Moderator
  • July 13, 2022

It is possible to update the data between tenants, but the specific recommendation should be based on the nature of the data. 

 

For general case, I’d say the best way is to utilize import/export scenarios to export data to excel file and import it back.


Kandy Beatty
Captain II
Forum|alt.badge.img+17
  • Captain II
  • July 13, 2022

HI @alejandroalvarado64 

Import scenarios would be best, but depending on what all data you want, you can do a snapshot as well. 


It is possible to update the data between tenants, but the specific recommendation should be based on the nature of the data. 

 

For general case, I’d say the best way is to utilize import/export scenarios to export data to excel file and import it back.

Thanks for your answer @Dmitrii Naumov 

One of our client’s requirements is that when the vendor is saved in Vendors screen of one Tenant, the entire document has to update the same vendor from another tenant right away.


Dmitrii Naumov
Acumatica Moderator
Forum|alt.badge.img+7
  • Acumatica Moderator
  • July 14, 2022

@alejandroalvarado64 in that case I’d suggest something like calling REST API of the another tenant. You can trigger the REST API call using business events/push notifications in the source tenant.


@alejandroalvarado64 in that case I’d suggest something like calling REST API of the another tenant. You can trigger the REST API call using business events/push notifications in the source tenant.

I’m going to go deeper into those topics! Thanks for the guide @Dmitrii Naumov 


purwandaruw
Freshman II
Forum|alt.badge.img
  • Freshman II
  • Answer
  • July 19, 2022

@alejandroalvarado64 in that case I’d suggest something like calling REST API of the another tenant. You can trigger the REST API call using business events/push notifications in the source tenant.

I’m going to go deeper into those topics! Thanks for the guide @Dmitrii Naumov 

Hi @alejandroalvarado64 

We’re doing this for master data such as stock items. When users create on one tenant as master, will duplicate in other tenants. My teams using API to do this. So i think that’s the best approach.

Daru


@alejandroalvarado64 in that case I’d suggest something like calling REST API of the another tenant. You can trigger the REST API call using business events/push notifications in the source tenant.

I’m going to go deeper into those topics! Thanks for the guide @Dmitrii Naumov 

Hi @alejandroalvarado64 

We’re doing this for master data such as stock items. When users create on one tenant as master, will duplicate in other tenants. My teams using API to do this. So i think that’s the best approach.

Daru

Thanks for your recommendation @purwandaruw47, surely API is the best way