Logan,

Thanks very much for the example of controller code. it is working well.

I have a question I am getting this error "System.ArgumentNullException: Value cannot be null. (Parameter 'name')" and I am thinking it is because "datacontext" is missing in below code snippet: 

 IDataStore ds1= dataUnpacker.GetDataStore("dw_1");
            IDataStore ds2= dataUnpacker.GetDataStore("dw_2");

any documentation/ "how-to" define and use DataContext in Controller? in my Service Implementation I already have  datacontext defined.

Thanks !

Hi Miraben,

I can't see your controller code. Your "public void UpdateAll()" method doesn't pass in any data. And both dataStore 1 and dataStore 2 in it never called the Retrieve() method to get any data.

If only for testing DataPacker in this method, please call dataStore1.Retrieve() to ensure the data row is not empty, then add it to datapacker.

My suggestions for receiving data by the Web API:

1) Verify the ConfigureServices method in StartUp.cs:

public void ConfigureServices(IServiceCollection services)
{
    services.AddControllers(m =>
    {
        m.UseCoreIntegrated(); // It will support the IDataUnpacker type in Controller.
        m.UsePowerBuilderIntegrated();
    });
    
    ...
}

And verify the Configure method in StartUp.cs: there should be a line "app.UseDataWindow();" to map the datawindow object name to the .NET DataStore C# models.

2) Use the IDataUnpacker type parameter in the controller of the Web API to receive your JSON package data.

E.g.:

[HttpPost]
[ProducesResponseType(StatusCodes.Status200OK)]
[ProducesResponseType(StatusCodes.Status500InternalServerError)]
public ActionResult Modify(IDataUnpacker dataUnpacker)
{
    // Declare and initialize local .NET DataStore variables
    // By getting the Packaged DataStores
    IDataStore order = dataUnpacker.GetDataStore("order", _context);
    IDataStore orderItems = dataUnpacker.GetDataStore("orderitems", _context);

    // Check if the modification was successful
    if (_service.Modify(order, orderItems))
    {
        // Return Status Code 200
        return Ok();
    }
    else
    {
        // Return a Status Code 500 for Internal Server Error
        return StatusCode(StatusCodes.Status500InternalServerError);
    }
}

Regards, Logan