Is it possible to use variables in the Post Body of the API Extract component?

Matillion ETL
1

I'm trying to make the following process

  1. Query Result to Grid component reading from a Snowflake table.
  2. Grid iterator connected to a API Extract component
  3. API Extract component to send multiple API requests with distinct post body content based on grid variables that are mapped to environment variables

 

I'm getting an error from the API when I tried to substitute a piece of the post body with an environment variable. The matillion documentation says variables are only supported for Query, Header, and URI configuartion. Is using variables in the post body not supported?

 

If it is not supported, what would be the recommended method of calling an API with multiple requests and a post body that changes between the requests?

 

Thank you!

2

@ivan.liaoI don't think we can use variable in Post Body of the API Extract component we can achieve this in python script, Using the Python Script component it gives you the flexibility to make multiple API requests with varying Post Body content. This approach bypasses the limitations of the API Extract component and allows you to utilize variables and dynamic data effectively.