Supercharge Your API Requests with CodelessAPI.io: Introducing Query Parameters and Wildcard Operators

Published on June 22, 2023

Introduction

Are you looking to level up your API requests? CodelessAPI.io has just introduced an exciting enhancement that allows you to add query parameters and leverage wildcard operators in your GET requests. In this blog post, we will explore how this new functionality empowers you to filter and retrieve specific data from your API responses effortlessly. Let's dive in!

Ensure your API data types are correct

To fully utilize the query parameters feature, please make sure the data types of your API responses match the data types of your query parameters.

If you're using Postgres as your data source, then the data types will be inferred from the types defined in your Postgres schema. However, if you're using Google Sheets or CSV as your data source, then you will need to enhance the data type of the columns retrieved by clicking the down arrow in the 'Columns to retrieve' section of the data source configuration.

Adding Query Parameters

CodelessAPI.io provides a powerful yet user-friendly way to query data from various sources using simple GET requests. By leveraging query parameters, you can refine and filter the data you retrieve based on specific conditions. Let's explore the different operators you can use and how to harness their potential.

Operators for Query Parameters

CodelessAPI.io supports a range of operators that allow you to apply conditions when querying data. These operators include:

• = (Equals): Matches values that are equal to the specified condition.
• != (Not Equals): Matches values that are not equal to the specified condition.
• > (Greater Than): Matches values that are greater than the specified condition.
• >= (Greater Than or Equal To): Matches values that are greater than or equal to the specified condition.
• <= (Less Than or Equal To): Matches values that are less than or equal to the specified condition.
• < (Less Than): Matches values that are less than the specified condition.

Wildcard Operator for String Comparison

In addition to the standard operators, CodelessAPI.io also supports the wildcard operator for string comparison. This allows you to perform pattern matching on string values. The wildcard operator is denoted by the asterisk (*) symbol.

For example, using the wildcard operator in a query parameter like product_name=*Apple* will match any value where the product name contains the word Apple.

By combining these operators and the wildcard, you can precisely filter and retrieve the data you need from your sources using CodelessAPI.io's intuitive interface.

Examples of Query Parameters and Wildcard Operators

Let's explore some examples of how query parameters and wildcard operators can be used in CodelessAPI.io:

• Retrieve products with a price greater than $50: price>50
• Retrieve customers from a specific city: city=New York
• Retrieve orders placed after a specific date: date>=2023-01-01
• Retrieve all products with 'apple' in the name: product_name=*apple*

Let's take a look at this API as an example: https://codelessapi.io/api/v1/get/1theQpat1D5~L1fR9ekNI9ic7Sr. This API returns the following data:

[
  {
    "name": "iPhone 12",
    "price": "999",
    "description": "The latest and greatest iPhone"
  },
  {
    "name": "Samsung Galaxy S21",
    "price": "799",
    "description": "A powerful Android phone"
  },
  {
    "name": "Macbook Pro",
    "price": "1299",
    "description": "A high-performance laptop"
  },
  {
    "name": "Microsoft Surface Laptop 4",
    "price": "999",
    "description": "A sleek and stylish laptop"
  },
  {
    "name": "Sony PlayStation 5",
    "price": "499",
    "description": "The ultimate gaming console"
  },
  {
    "name": "Xbox Series X",
    "price": "499",
    "description": "A powerful gaming console"
  }
]

You can use query parameters to filter the data from this API based on specific criteria. Here are some examples:

• Retrieve products with a price greater than $1000: https://codelessapi.io/api/v1/get/1theQpat1D5~L1fR9ekNI9ic7Sr?price>1000
• Retrieve products with a price less than or equal to $800: https://codelessapi.io/api/v1/get/1theQpat1D5~L1fR9ekNI9ic7Sr?price<=800
• Retrieve products with a description containing the word 'powerful': https://codelessapi.io/api/v1/get/1theQpat1D5~L1fR9ekNI9ic7Sr?description=*powerful*
• Retrieve products with a product name not equal to 'iPhone 12': https://codelessapi.io/api/v1/get/1theQpat1D5~L1fR9ekNI9ic7Sr?name!=iPhone%2012

These examples demonstrate how you can use query parameters to filter and refine the data from the CodelessAPI.io API endpoint, allowing you to retrieve only the information that meets your specific criteria.

Chaining Query Parameters

You can also chain query parameters by using the & symbol to separate them.

• Retrieve products with a description containing the word 'powerful' and price bring greater than 500: https://codelessapi.io/api/v1/get/1theQpat1D5~L1fR9ekNI9ic7Sr?description=*powerful*&price>500

Conclusion

The introduction of query parameters and wildcard operators in CodelessAPI.io brings powerful filtering capabilities to your API requests. Whether you need to retrieve specific records or search for patterns within your data, these enhancements enable you to fine-tune your API responses effortlessly. Start leveraging the potential of query parameters and wildcard operators in CodelessAPI.io today, and supercharge your API integration experience.