Skip to main content
Solved

API and special characters

  • September 1, 2023
  • 4 replies
  • 282 views
jamest
Varsity I
Forum|alt.badge.img

After a couple of rounds of trying to “PUT” records into the Stock Item that have the # symbol I’m beginning to think the API framework doesn’t accept special characters. Can someone confirm this? 

I’m using Power Automate Desktop to invoke the web service and insert stock items. I’ve tried the Replace Text action  (replace # with %%23 also replace # with \#), none of which work. 

Thanks in advance!

Best answer by jamest

Ok, @yhartman ‘s post game me an idea. There are two api calls. The first one is to see if the stock item exists based off the description. I had to use “%%23” in the variable for that to work. 

For the second call (PUT if the item doesn’t exist), I was able to use the “#”. It looks like I’m ok now. Thanks!

View original
Did this topic help you find an answer to your question?

Y
Jr Varsity I
Forum|alt.badge.img+3
  • yhartman
  • Jr Varsity I
  • September 5, 2023

Hi, can you share a bit information on about the API call?

 

 

Yisroel Hartman • https://www.linkedin.com/in/yisroelhartman/
Vignesh Ponnusamy
Chris Hackett
jamest
3 people like this
  • Vignesh Ponnusamy
    Vignesh Ponnusamy
  • Chris Hackett
    Chris Hackett
  • jamest
    jamest
Vignesh Ponnusamy
Acumatica Moderator
Forum|alt.badge.img+5

@jamest, Are you trying to using special character in the key field(like InventoryID)? Please share the steps to reproduce the issue/behavior. Thanks, 

#VP
Chris Hackett
jamest
2 people like this
  • Chris Hackett
    Chris Hackett
  • jamest
    jamest
jamest
Varsity I
Forum|alt.badge.img
  • jamest
  • Varsity I
  • September 5, 2023

Ok, @yhartman ‘s post game me an idea. There are two api calls. The first one is to see if the stock item exists based off the description. I had to use “%%23” in the variable for that to work. 

For the second call (PUT if the item doesn’t exist), I was able to use the “#”. It looks like I’m ok now. Thanks!

Vignesh Ponnusamy
Chris Hackett
2 people like this
  • Vignesh Ponnusamy
    Vignesh Ponnusamy
  • Chris Hackett
    Chris Hackett
Chris Hackett
Community Manager
Forum|alt.badge.img
  • Chris Hackett
  • Acumatica Community Manager
  • September 7, 2023

Thank you for sharing your solution with the community @jamest!

Chris ~ Let us know how we're doing: https://forms.office.com/r/xmJUdZ1QE5 - A member helped you, please *Like* their post. A member provided an answer to your question, please mark it as *Best Answer*.

Reply


Most helpful members this week

Terms & ConditionsCookie settings

Cookie policy

We use cookies to enhance and personalize your experience. If you accept you agree to our full cookie policy. Learn more about our cookies.

 
Cookie settings
About Acumatica ERP system
Acumatica Cloud ERP provides the best business management solution for transforming your company to thrive in the new digital economy. Built on a future-proof platform with open architecture for rapid integrations, scalability, and ease of use, Acumatica delivers unparalleled value to small and midmarket organizations. Connected Business. Delivered.
© 2008 — 2024  Acumatica, Inc. All rights reserved