调用星空即时库存单据列表接口全量返回的时候报"转换 nvarchar 值 '9003120221' 时溢出了整数列。

对应的请求参数如下：

--data '{

"data":{

"FormId":"STK_Inventory",

"FieldKeys":"FStockId.Fnumber,FStockName,FOwnerName,FOwnerId.fnumber,FStockOrgId.fname,FStockOrgId.fnumber,FMaterialName,FMaterialId.fnumber,FBaseQty",

"FilterString":"FOwnerId.fnumber in (111,110,112,113,147,148,149)",

"OrderString":"",

"TopRowCount":0,

"StartRow":10,

"Limit":0

}

对应的回参：

[[{"Result":{"ResponseStatus":{"ErrorCode":500,"IsSuccess":false,"Errors":[{"FieldName":null,"Message":"转换 nvarchar 值 '9003120221' 时溢出了整数列。\r\nServer stack trace: \r\n 在 System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction)\r\n 在 System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj, Boolean callerHasConnectionLock, Boolean asyncClose)\r\n 在 System.Data.SqlClient.TdsParser.TryRun(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj, Boolean& dataReady)\r\n 在 System.Data.SqlClient.SqlDataReader.TryHasMoreRows(Boolean& moreRows)\r\n 在 System.Data.SqlClient.SqlDataReader.TryReadInternal(Boolean setTimeout, Boolean& more)\r\n 在 System.Data.SqlClient.SqlDataReader.Read()\r\n 在 Kingdee.BOS.App.Data.DBUtils.InnerFillObject[T](Context ctx, IDataReader reader, IDataEntityType dt, IDictionary`2 propertyTypeMaps)\r\n 在 Kingdee.BOS.App.Data.DBUtils.ExecuteObject[T](Context ctx, String strSQL, IDataEntityType dt, IDictionary`2 propertyTypeMaps, CommandType cmdType, SqlParam[] paramList)\r\n 在 Kingdee.BOS.App.Data.DBUtils.ExecuteDynamicObject(Context ctx, String strSQL, IDataEntityType dt, IDictionary`2 propertyTypeMaps, CommandType cmdType, SqlParam[] paramList)\r\n 在 Kingdee.BOS.App.Core.Query.QueryService.GetDynamicObjectCollectionAndQuerySql(Context ctx, QueryBuilderParemeter para, List`1 paramList, String& querySql)\r\n 在 Kingdee.BOS.App.Core.Query.QueryService.GetDynamicObjectCollection(Context ctx, QueryBuilderParemeter para, List`1 paramList)\r\n\r\nException rethrown at [0]: \r\n 在 System.Runtime.Remoting.Proxies.RealProxy.HandleReturnMessage(IMessage reqMsg, IMessage retMsg)\r\n 在 System.Runtime.Remoting.Proxies.RealProxy.PrivateInvoke(MessageData& msgData, Int32 type)\r\n 在 Kingdee.BOS.Contracts.IQueryService.GetDynamicObjectCollection(Context ctx, QueryBuilderParemeter para, List`1 paramList)\r\n 在 Kingdee.BOS.ServiceHelper.QueryServiceHelper.GetDynamicObjectCollection(Context ctx, QueryBuilderParemeter para, List`1 paramList)\r\n 在 Kingdee.BOS.WebApi.FormService.QueryBillService.GetQueryData(String data, List`1& querySelectItems)\r\n 在 Kingdee.BOS.WebApi.FormService.QueryBillService.ExecuteBillQuery(String data)","DIndex":0}],"SuccessEntitys":[],"SuccessMessages":[],"MsgCode":6}}}]]

产品问题星空webapi调用即时库存接口报错

产品问题 星空webapi调用即时库存接口报错

恭喜您！

产品问题
星空webapi调用即时库存接口报错

产品问题星空webapi调用即时库存接口报错