Troubleshoot WebAPI with stored procedure

I am looking for someone to troubleshoot a data retrieval issue with my WebAPI. Specific Requirements: - Experience with WebAPI and troubleshooting data retrieval issues - Familiarity with stored procedures and their potential use in resolving this issue - Ability to assess the urgency of the problem and prioritize accordingly Skills and Experience: - Strong understanding of WebAPI and its associated technologies - Proficiency in troubleshooting data retrieval issues - Knowledge of stored procedures and their potential use in resolving issues - Ability to prioritize and manage tasks based on urgency This project is of medium priority, and I am looking for someone who can address the data retrieval issue efficiently and effectively. Addr1 is not found in the schema of any tables involved. Error: [login to view URL]: The required column 'Addr1' was not present in the results of a 'FromSql' operation. at [login to view URL]`[login to view URL](IReadOnlyList`1 columnNames, DbDataReader dataReader) at [login to view URL]`[login to view URL](Enumerator enumerator) at [login to view URL]`1.Enumerator.<>c.<MoveNext>b__21_0(DbContext _, Enumerator enumerator) at [login to view URL][TState,TResult](TState state, Func`3 operation, Func`3 verifySucceeded) at [login to view URL]`[login to view URL]() at [login to view URL]`1..ctor(IEnumerable`1 collection) at [login to view URL][TSource](IEnumerable`1 source) at [login to view URL](DateTime BoxedDate) in C:\Users\Administrator\source\repos\QRaPAPI-QualityReassuranceProjectAPI\QRaPAPI-QualityReassuranceProjectAPI\Controllers\[login to view URL]:line 23 at lambda_method5(Closure, Object) at [login to view URL](ActionContext actionContext, IActionResultTypeMapper mapper, ObjectMethodExecutor executor, Object controller, Object[] arguments) at Microsoft.AspNetCore.Mvc.Infrastructure.ControllerActionInvoker.<InvokeActionMethodAsync>g__Awaited|12_0(ControllerActionInvoker invoker, ValueTask`1 actionResultValueTask) at Microsoft.AspNetCore.Mvc.Infrastructure.ControllerActionInvoker.<InvokeNextActionFilterAsync>g__Awaited|10_0(ControllerActionInvoker invoker, Task lastTask, State next, Scope scope, Object state, Boolean isCompleted) at [login to view URL](ActionExecutedContextSealed context) at [login to view URL](State& next, Scope& scope, Object& state, Boolean& isCompleted) at [login to view URL]() --- End of stack trace from previous location --- at Microsoft.AspNetCore.Mvc.Infrastructure.ResourceInvoker.<InvokeFilterPipelineAsync>g__Awaited|20_0(ResourceInvoker invoker, Task lastTask, State next, Scope scope, Object state, Boolean isCompleted) at Microsoft.AspNetCore.Mvc.Infrastructure.ResourceInvoker.<InvokeAsync>g__Awaited|17_0(ResourceInvoker invoker, Task task, IDisposable scope) at Microsoft.AspNetCore.Mvc.Infrastructure.ResourceInvoker.<InvokeAsync>g__Awaited|17_0(ResourceInvoker invoker, Task task, IDisposable scope) at Microsoft.AspNetCore.Routing.EndpointMiddleware.<Invoke>g__AwaitRequestTask|6_0(Endpoint endpoint, Task requestTask, ILogger logger) at [login to view URL](HttpContext context) at [login to view URL](HttpContext httpContext) at [login to view URL](HttpContext httpContext, ISwaggerProvider swaggerProvider) at [login to view URL](HttpContext context) at [login to view URL](HttpContext context) HEADERS ======= Accept: text/plain Connection: keep-alive Host: localhost:7131 User-Agent: Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/[login to view URL] Safari/537.36 Accept-Encoding: gzip, deflate, br Accept-Language: en-US,en;q=0.9 Referer: https://localhost:7131/swagger/[login to view URL] sec-ch-ua: "Not_A Brand";v="99", "Google Chrome";v="109", "Chromium";v="109" sec-ch-ua-mobile: ?0 sec-ch-ua-platform: "Windows" Sec-Fetch-Site: same-origin Sec-Fetch-Mode: cors Sec-Fetch-Dest: empty storedproc: ALTER PROCEDURE [dbo].[GNC_QRP_MissingPics] @BoxedDate DATE --exec GNC_QRP_MissingPics '2023-08-04' AS BEGIN -- Create temporary table to store data CREATE TABLE #TempTableQRP ( DateOnly DATE, OrderNumber VARCHAR(8), LineNumber VARCHAR(2), PictureTitle VARCHAR(255), LineCabName VARCHAR(255), RowRank INT ); -- Populate the temporary table with data INSERT INTO #TempTableQRP (DateOnly, OrderNumber, LineNumber, PictureTitle, LineCabName, RowRank) SELECT CONVERT(DATE, [login to view URL]) AS DateOnly, [login to view URL], [login to view URL], [login to view URL], [login to view URL], ROW_NUMBER() OVER (PARTITION BY CONVERT(DATE, [login to view URL]), [login to view URL], [login to view URL] ORDER BY CONVERT(DATE, [login to view URL]), [login to view URL], [login to view URL]) AS RowRank FROM GNC_QRP_ShippingPictures pic WHERE CONVERT(DATE, [login to view URL]) = @BoxedDate; -- Retrieve missing picture data from the main table SELECT sd.ORDNUM_28, sd.LINNUM_28 FROM so_detail sd inner join Part_Sales ps on sd.PRTNUM_28 = ps.PRTNUM_29 LEFT JOIN #TempTableQRP sp ON sd.ORDNUM_28 = [login to view URL] AND sd.LINNUM_28 = [login to view URL] WHERE substring(ps.SLSCAT_29,1,1)<> '*' and substring(ps.SLSCAT_29,2,1)<> '*' and substring(ps.SLSCAT_29,1,1)<> ' ' and sd.ORDNUM_28 IN ( SELECT DISTINCT OrderNumber FROM GNC_QRP_ShippingPictures WHERE CONVERT(DATE, BoxedDate) = @BoxedDate ) AND [login to view URL] IS NULL AND sd.DELNUM_28 = '01'; -- Drop the temporary table DROP TABLE #TempTableQRP; END; Output from exec GNC_QRP_MissingPics '2023-08-04' ORDNUM_28 LINNUM_28 21012074 05 21012074 06 21012075 03 21012075 04 21012075 05 21012075 06 21012075 07 21012075 08 21012075 09 21012075 12 21012075 13 21012075 14 21012075 15 21012370 03 21012370 04 21012370 06 21012370 07 API GET: [HttpGet("{BoxedDate}")] public async Task<ActionResult<List<MissingPicsModel>>> GetMissingPics(DateTime BoxedDate) { Gnconyx20160801Context context = new Gnconyx20160801Context(); var result = [login to view URL]($"EXECUTE GNC_QRP_MissingPics {BoxedDate}") .ToList(); return Ok(result); }