Thank you for replying!

I have been through the suggested tables and stored procedures.

However, the stored procedures are there to migrate records from "staging" or "temporary" tables and the migration is where the validations exist. I cannot find any procedures to create records in staging tables. So does that mean that I have to make stored procedure to insert records in all the staging tables that stores information about customer(eg. StgCustomer, StgCustAdd and may be more) and then migrate them or "am I missing something"?

You are correct, if you are not using Data Migrator, you will need to manually populate the staging tables yourself and then execute the stored procedure to create the customer records. There is no stored procedure to do this as the data could be from any source (website/webservice, delimited file, Excel, etc.). If you are using delimited files or Excel, you might find it easier to use Data Migrator from the Sage 500 client to process your data as it will populate the staging tables for you and execute the stored procedure.

If your requirements are different, you can use either temporary or the actual staging tables themselves to process data. There is a parameter @iUseStageTable that you can pass to the stored procedure to indicate if you are using temp tables or not. We do a lot of work with these APIs using SSIS and the first stage of the process is always populating the staging tables with the appropriate data with the second stage executing the API stored procedure.

You are correct, if you are not using Data Migrator, you will need to manually populate the staging tables yourself and then execute the stored procedure to create the customer records. There is no stored procedure to do this as the data could be from any source (website/webservice, delimited file, Excel, etc.). If you are using delimited files or Excel, you might find it easier to use Data Migrator from the Sage 500 client to process your data as it will populate the staging tables for you and execute the stored procedure.

If your requirements are different, you can use either temporary or the actual staging tables themselves to process data. There is a parameter @iUseStageTable that you can pass to the stored procedure to indicate if you are using temp tables or not. We do a lot of work with these APIs using SSIS and the first stage of the process is always populating the staging tables with the appropriate data with the second stage executing the API stored procedure.

Now that I get a clear idea about how to "create" a record in sage 500 through API, I'll appreciate your help in exploring the process of "updating" any record. Is it that I have to make my own stored procedure to validate data(using sage 500 stored procedures) and directly update the main tables like "tarCustomer, tarCustAddr, etc." or is this something that sage 500 already provides in the form of stored procedure api?

In the past (when I worked for a reseller) I directly updated the tables. I am not aware of an API to do updates. Sage sort of frowns on this though. Just an FYI.

Sage highly frowns upon direct updates to their tables. Your best bet is to use the API as includes validations necessary for creating new customers. As I mentioned before review the stored procedure to see what it actually does and what limitations it has. If necessary you can create your own modified version of this procedure to fill any gaps you find in what you need to accomplish. Simply script the stored procedure and add some identifier to the stored procedure name to identify it as yours. Do not modify the original as any updates from Sage will overwrite your modifications to it.