Python REQUESTS中变量填充API过滤表达式的语法问题

Hey there! I’ve run into similar issues with API filter expressions that use custom wrappers for variables, so let’s walk through how to solve this step by step.

Basic String Replacement Approach #

The simplest way to populate your #-wrapped placeholders is to start with a template string, then replace each placeholder with its corresponding variable value (from user input or your config file).

Here’s a concrete example using Python (adjust the syntax to your language if needed):

# Load config variables (e.g., from a JSON/YAML file)
config_vars = {"max_results": 50, "default_status": "approved"}
# Capture user input variables
user_input = {"user_id": "9876", "target_category": "electronics"}

# Define your API filter template with #-wrapped placeholders
filter_template = "user_id = #user_id# AND category = #target_category# AND status = #default_status# AND limit <= #max_results#"

# Combine all variables into one dict for easier handling
combined_vars = {**config_vars, **user_input}

# Replace each placeholder with its value
for key, value in combined_vars.items():
    filter_template = filter_template.replace(f"#{key}#", str(value))

# Final filter expression ready for the API
print(filter_template)
# Output: "user_id = 9876 AND category = electronics AND status = approved AND limit <= 50"

Handling Variable Data Types #

If your API expects string values to be wrapped in quotes (e.g., category = 'electronics'), modify the replacement step to add quotes around string values:

for key, value in combined_vars.items():
    if isinstance(value, str):
        # Wrap string values in single quotes
        filter_template = filter_template.replace(f"#{key}#", f"'{value}'")
    else:
        # Leave numbers/booleans as-is
        filter_template = filter_template.replace(f"#{key}#", str(value))

Safer Pattern Matching with Regex #

The basic replace() method can accidentally replace partial matches (e.g., if you have a placeholder #user_id# and another #user_id_extra#). For more precision, use regex to match exact #variable# patterns:

import re

def substitute_placeholders(template, variables):
    # Regex to match # followed by word characters, then #
    def replace_match(match):
        var_key = match.group(1)
        # Return the variable value, or keep the placeholder if key doesn't exist
        return str(variables.get(var_key, match.group(0)))
    
    return re.sub(r"#(\w+)#", replace_match, template)

# Use the function with your combined variables
final_filter = substitute_placeholders(filter_template, combined_vars)

Supporting Custom Wrappers #

Since the API allows specifying alternative wrappers (instead of #), you can make the substitution function dynamic to handle any wrapper:

def substitute_with_custom_wrapper(template, variables, wrapper="#"):
    # Escape the wrapper to handle special regex characters (like @, $)
    escaped_wrapper = re.escape(wrapper)
    pattern = re.compile(f"{escaped_wrapper}(\\w+){escaped_wrapper}")
    
    def replace_match(match):
        var_key = match.group(1)
        return str(variables.get(var_key, match.group(0)))
    
    return pattern.sub(replace_match, template)

# Example using @ as the wrapper
final_filter = substitute_with_custom_wrapper(filter_template, combined_vars, wrapper="@")

Key Notes to Avoid Issues #

• Match variable names exactly: Ensure the keys in your variable dict match the placeholder names (case-sensitive!).
• Escape special characters: If your variable values contain the wrapper character (e.g., a user input with #), check if the API supports escaping (e.g., using ## to represent a single #).
• Validate before sending: Always print the final filter expression first to confirm it matches the API’s expected syntax before making the request.

内容的提问来源于stack exchange，提问作者km457