Getting Error: sss_invalid_api_usage in Netsuite when creating Deposit

Gianluca Belardinelli

• April 17, 2024 12:44

Hi Everyone, this is the mapping and the request attached but I get the following error:
{
  "code": "SSS_INVALID_API_USAGE",
  "message": "Invalid API usage. You must use getSublistValue to return the value set with setSublistValue. "
}
What's that about?

importing record {"index":0,"retryCount":0}
{"nlobjRecordType":"deposit","nlobjFieldIds":{"trandate":"13/04/2024","account":"153.39 BANCHE : KLARNA","subsidiary":2,"exchangerate":"1.00","customform":146},"nlobjSublistIds":{"payment":[{"docnumber":"CO2404949","transactionamount":"179.62"}]}}
nlapi calls registered for $R:
r = NRecord.create({"type":"deposit","defaultValues":{"customform":146}});    
r.setValue({"fieldId":"trandate","value":"13/04/2024"});    
r.setText({"fieldId":"account","text":"153.39 BANCHE : KLARNA"});    
r.setValue({"fieldId":"subsidiary","value":2});    
r.setValue({"fieldId":"exchangerate","value":"1.00"}); 

0

• 

  Tyler Lamparter Principal Product Manager

  • April 17, 2024 13:17

  

  

  

  

  

  Can you try using dynamic mode? https://docs.celigo.com/hc/en-us/community/posts/360077243491/comments/15124655745307

  0
• 

  Gianluca Belardinelli

  • April 17, 2024 13:44

  Hi Tyler, Thank you for your answer. So I did, refer to the screenshot below. With the request. This is the error I get now

  importing record {"index":0,"retryCount":0}
  {"nlobjRecordType":"deposit","nlobjFieldIds":{"trandate":"13/04/2024","subsidiary":2,"exchangerate":"1.00","customform":146,"celigo_recordmode_dynamic":"true","memo":"dsada","account":857},"nlobjSublistIds":{"payment":[{"transactionamount":"179.62","type":"CashSale","entity":7594250,"refnum":"#52714"}]}}
  nlapi calls registered for $R:
  r = NRecord.create({"type":"deposit","defaultValues":{"recordmode":"dynamic","customform":146}});    
  r.setValue({"fieldId":"trandate","value":"13/04/2024"});    
  r.setValue({"fieldId":"subsidiary","value":2});    
  r.setValue({"fieldId":"exchangerate","value":"1.00"});    
  r.setValue({"fieldId":"memo","value":"dsada"});    
  r.setValue({"fieldId":"account","value":857});    
  r.selectNewLine({"sublistId":"payment"});
  
  

  Failed to create, update/transform record because You have attempted an invalid sublist or line item operation. You are either trying to access a field on a non-existent line or you are trying to add or remove lines from a static sublist. Tip: Please make sure that all the line items that you're trying to use exist on the record.

  

   

   

   

  0

Please sign in to leave a comment.