Error while creating IPAM.IPNode record with SWIS API: Specified cast is not valid

coffeeBreak

Hello,

I try to create IP Addresses with the following Curl command:

curl -sSk -v -H "Content-Type: application/json" -H "Accept: application/json"  -u "username:pwd -d '{"SubnetId":111,"IpAddress":"12.12.12.2"}' mysolarwinds:17778/.../IPAM.IPNode

But I keep getting the following error:

< HTTP/2 400
< content-length: 2635
< content-type: application/json
< server: Microsoft-HTTPAPI/2.0
< strict-transport-security: max-age=31536000,includeSubDomains
< date: Mon, 03 Apr 2023 21:39:32 GMT
<
{"Message":"Exception has been thrown by the target of an invocation.","ExceptionType":"System.Reflection.TargetInvocationException","FullException":"System.Reflection.TargetInvocationException: Exception has been thrown by the target of an invocation. ---> System.InvalidCastException: Specified cast is not valid.\r\n at SolarWinds.Data.Providers.Orion.IPAM.V3.CrudHandlers.Validators.IpNodeValidator.ValidateIPOrdinal(IEntityValidationContext context)\r\n --- End of inner exception stack trace ---\r\n at System.RuntimeMethodHandle.InvokeMethod(Object target, Object[] arguments, Signature sig, Boolean constructor)\r\n at System.Reflection.RuntimeMethodInfo.UnsafeInvokeInternal(Object obj, Object[] parameters, Object[] arguments)\r\n at System.Reflection.RuntimeMethodInfo.Invoke(Object obj, BindingFlags invokeAttr, Binder binder, Object[] parameters, CultureInfo culture)\r\n at SolarWinds.Data.Providers.Orion.IPAM.V3.CrudHandlers.Validators.IpamEntityValidatorBuilder.<>c__DisplayClass0_1.<BuildEntityValidator>b__2(IEntityValidationContext context)\r\n at SolarWinds.Data.Providers.Orion.IPAM.V3.CrudHandlers.Validators.IpamEntityValidator.Validate(IEntityValidationContext context)\r\n at SolarWinds.Data.Providers.Orion.IPAM.V3.CrudHandlers.IPAMCrudHandlerBase.Validate(IDictionary`2 columns, IIpamEntityValidator validator, Boolean isCreate, IDictionary`2 columnsToUpdate, String entityName)\r\n at SolarWinds.Data.Providers.Orion.IPAM.V3.CrudHandlers.IPAMCrudHandlerBase.ValidateCreate[T](IDictionary`2 columns, String entityName)\r\n at SolarWinds.Data.Providers.Orion.IPAM.V3.CrudHandlers.IPNodeCrudHandler.Create(IDictionary`2 columns, Func`2 baseCall)\r\n at SolarWinds.Data.Providers.Orion.OrionDataProvider.Create(IStorageElement storage, IDictionary`2 columns)\r\n at SolarWinds.InformationService.Addons.DataProvider.<Create>d__62.MoveNext()\r\n at System.Collections.Generic.List`1.InsertRange(Int32 index, IEnumerable`1 collection)\r\n at SolarWinds.InformationService.Core.CrudProcessor.<Creat* Connection #0 to host ipplan.at-work.local left intact
eLocal>d__22.MoveNext()\r\n at System.Collections.Generic.List`1..ctor(IEnumerable`1 collection)\r\n at System.Linq.Enumerable.ToList[TSource](IEnumerable`1 source)\r\n at SolarWinds.InformationService.Core.CrudProcessor.<CreateInternal>d__19.MoveNext()\r\n at System.Linq.Enumerable.First[TSource](IEnumerable`1 source)\r\n at SolarWinds.InformationService.Core.CrudProcessor.Create(String entityType, IDictionary`2 properties, IQueryExecutionContext context)\r\n at SolarWinds.InformationService.Core.InformationService.Create(String entityType, IDictionary`2 properties)"}[

Obviously, there is something wrong with the subnet ID.

I already tried to write the value of the subnet Id with quotation marks, but somehow it doesn't work.

Update: The subnet ID was totally fine.

Thanks in advance

coffeeBreak

Thanks to the following post, I managed to create an IP address:

https://thwack.solarwinds.com/product-forums/the-orion-platform/f/orion-sdk/91643/how-do-i-create-an-ipam-ip-node

Without trial and error, it is very hard to know what fields you need.

The developers of the API should really check their documentation, because there is written, that only subnetid and ipaddress (Check the IPAM API documentation and yes I know I use a different API but the table is the same) are enough while the error message above is very confusing. They should work on it.

I assume, that a null value will be assigned to the other 2 required values, which leads to the "specified cast is not valid" error.

Thanks to the hero Pyhton_Noob.