Table data export

[Shabbir1]

Hello Team,

we have one table (hr_mapping) there are 80k + records in prod instance we want export & import this records into our lower instance can anyone suggest the best way to achieve this any schedule job script..?  kindly help me in the script  or any other best solution might me helpful to us

Regards

Shabbir

[Dr Atul G- LNG]

Hi @Shabbir1 

You can go to the Mapping Table list view.

However, if I’m not mistaken, out of the box you can only export 10,000 records at a time. To export more than that, you’ll need to update the input export property and increase the count — though this may impact performance temporarily.

Also, if you’re planning to clone this in the near future, this is the best option instead of moving data via CSV or JSON format

[Ankur Bawiskar]

@Shabbir1 

couple of approaches

1st approach:

Use Export CSV option and then import that in lower instance

2nd approach:

You can run background script to push/insert data from PROD To DEV using REST TABLE API Endpoint

💡 If my response helped, please mark it as correct ✅ and close the thread 🔒— this helps future readers find the solution faster! 🙏

[Ankur Bawiskar]

@Shabbir1 

Hope you are doing good.

Did my reply answer your question?

💡 If my response helped, please mark it as correct ✅ and close the thread 🔒— this helps future readers find the solution faster! 🙏