REST API data push into OneStream. How can we create a custom response back to the calling system

If you want to send back an error message, you could wrap your sequence into an Extender rule; on failure, you throw the exception with a message and *I think* this will be returned by the API call. The job will appear as failed though.

If instead you want to return some extra info on success, I think you will need to implement a polling system. One way to do that would be to build a Data Adapter that launches a Dashboard DataSet rule, which will return the necessary info; and then execute that from the endpoint api/DataProvider/GetAdoDataSetForAdapter . This rule will have to be smart enough to figure out when the job is completed (by querying either Task Activity, or Error Log, or the data itself), and return some "in progress" data if it's not. The client will just keep polling GetAdoDataSetForAdapter as long as necessary.