API_RunImport with Summary table
Is it possible to use the API_RunImport to create a URL and automatically imports the data in a Summary Report in one table, to another table. I have one table that has items and their weight, a su...
Forum Discussion
I wish you could, but there is no API for that.
But here is a thought.
You probably have a table of items in your app. Create a summary field on that table of Weight Shipped Today. Then make a saved Table to Table copy report to your Shipments Table from the Item Table and just map the fields across. Include a filter on the saved import
where Weight today > 0
so you don't export your whole item table! - just the ones that Shipped today.
But here is a thought.
You probably have a table of items in your app. Create a summary field on that table of Weight Shipped Today. Then make a saved Table to Table copy report to your Shipments Table from the Item Table and just map the fields across. Include a filter on the saved import
where Weight today > 0
so you don't export your whole item table! - just the ones that Shipped today.