Wildcards in REST API Query Params

Chris Francis

• June 03, 2022 12:23
• Edited

I am looking to return assets from the /assets.json endpoint.  I can return specific assets with exact matches in the query parameters like "externalId" easily enough.  But I would like to do a wild card search in these same parameters.  

For Example:  Search for "abc-123" should match the following "externalId"s

abc-123
abc-123v3
UK-abc-123
CA-abc-123v7

Is there any way to do this?  I have tried passing in simple wildcards (*abc-123*, %abc-123%) as well as regular expressions (^.*abc-123.*$).  Neither of which returned any values.

Any guidance would be great

For an CURL example see below.  This was a regular expression attempt.

curl -X GET "https://*****.showpad.biz/api/v3/assets.json?externalId=.%2Aabc-123.%2A" -H "accept: application/json" -H "Authorization: Bearer c7fb...T09"

0

• Official comment

  

  Sarah Shockey

  • June 03, 2022 18:52

  Hi Chris! Thanks for reaching out with your well-stated request. Currently, your request is not a functionality supported in Showpad's API configuration.

  That being said, I created a Product Idea ticket for our team to research and consider, linking to this post and requesting that the ability to wildcard search for assets via the API be considered when planning future Showpad developments. Thanks again for engaging with us, and have a wonderful weekend!
• 

  Chris Francis

  • June 07, 2022 12:44

  Sarah Shockey  upon further research this is possible.
  
  by passing {"like":"%abc-123%"} into the externalId parameter of the assets.json endpoint a like wildcard search is performed.

  0
• 

  Sarah Shockey

  • June 07, 2022 21:35

  Hey Chris, that's awesome news. Thanks for keeping on and sharing your results. I will share this with our team. Have a great one!

  0

Please sign in to leave a comment.