does anyone know if you can use the external ID in...
# integrationsn
Nicolas Bean
08/14/2024, 1:46 PMdoes anyone know if you can use the external ID in the "apply" sublist on a credit memo through SOAP?
Nicolas Bean
08/14/2024, 2:32 PM@battk
b
battk
08/14/2024, 3:15 PMno, there is no sublist key that uses external id
n
Nicolas Bean
08/14/2024, 3:16 PMdang then how do we need to do an extra call to get the internalid?
Nicolas Bean
08/14/2024, 3:16 PMis there another field we can use
b
battk
08/14/2024, 3:18 PMpick a choice for sublist key most convenient to you
n
Nicolas Bean
08/14/2024, 3:22 PMlike the refNo?
Nicolas Bean
08/14/2024, 3:23 PMis there anything additional we need to do "pick a key"
Nicolas Bean
08/14/2024, 3:23 PMaka in the SOAP request
b
battk
08/14/2024, 3:24 PMmy answers rarely make sense without reading the linked documentation
😂 1
r
RJMNS
08/14/2024, 4:12 PMFwiw this was not on a Credit Memo, so maybe it has different requirements, but we were able to do this on a vendor payment by using the following string.
Copy code
[ { "amount": 116246.4125, "apply": true, "doc": { "externalId": "our_external_id" } } ]RJMNS
08/14/2024, 4:14 PMWorth trying. I know NS would never have their documentation behind to where something worked that wasn't documented as such, but would probably be worth taking 15 mins to try it if it can save you a bunch of time.
n
Nicolas Bean
08/14/2024, 4:21 PMlmao
Nicolas Bean
08/14/2024, 4:21 PMthank you!
👍 1
Nicolas Bean
08/15/2024, 2:14 AMjava.lang.NumberFormatException: For input string: “Invoice-CreditMemo-TEST-2024-08-14
b
battk
08/15/2024, 2:43 AMits a data type thing
battk
08/15/2024, 2:45 AM@RJMNS solution works for rest since the doc is a nsResource, while for soap, its a long
battk
08/15/2024, 2:47 AMdont expect to be able to use something from a different integration method
r
RJMNS
08/15/2024, 3:29 PMIt worked for us on SOAP. If it's not supposed to, I have no idea why it did. I'm only semi-technical. 🤷♂️
RJMNS
08/15/2024, 3:37 PMTo that point ☝️ @Nicolas Bean, I don't have any help with you on that error. I'm sure @battk knows more than I do about it. We had more technical people than I help us set this stuff up.
n
Nicolas Bean
08/15/2024, 3:38 PMno worries i appreciate it
r
RJMNS
08/15/2024, 10:39 PMFwiw I got curious and looked at our actual SOAP request and I see it's using Internal ID. I forgot to mention that the little snippet of code I posted is not something used in a direct request, we're feeding it through a middleware platform. So probably @battk and I are both right..ha.
They're right in that this doesn't really work with SOAP, but I'm guessing it works for us because the middleware platform under the covers is taking the Ext ID we're giving it and doing some lookup process invisible to the user to take that Ext ID and find the corresponding Int ID before it submits the SOAP request.
Doesn't help your problem, but in case anyone cares.
n
Nicolas Bean
08/16/2024, 12:40 AMah
Nicolas Bean
08/16/2024, 12:41 AMi figured thank you
4 Views