How to pass query parameters in API gateway with S3 json file backend

Question

I am new to AWS and I have followed this tutorial : https://docs.aws.amazon.com/apigateway/latest/developerguide/integrating-api-with-aws-services-s3.html, I am now able to read from the TEST console my AWS object stored on s3 which is the following (it is .json file):

[ { "important": "yes", "name": "john", "type": "male" }, { "important": "yes", "name": "sarah", "type": "female" }, { "important": "no", "name": "maxim", "type": "male" } ]

Now, what I am trying to achieve is pass query parameters. I have added type in the Method Request and added a URL Query String Parameter named type with method.request.querystring.type mapping in the Integration Request.

When I want to test, typing type=male is not taken into account, I still get the 3 elements instead of the 2 male elements.

Any reasons you think this is happening ?

For information, the Resources is the following (and I am using AWS Service integration type to create the GET method as explained in the AWS tutorial)

/
 /{folder}
  /{item}
   GET

greeneye12 · Accepted Answer · 2021-01-11 10:51:30Z

1

In case anyone is interested by the answer, I have been able to solve my problem.

The full detailed solution requires a tutorial but here are the main steps. The difficulty lies in the many moving parts so it is important to test each of them independently to make progress (quite basic you will tell me).

Make sure your SQL query to your s3 DB is correct, for this you can go in your s3 bucket, click on your file and select "query with s3 select" from the action.
Make sure that your lambda function works, so check that you build and pass the correct SQL query from the test event
Setup the API query strings in the Method Request panel and setup the Mapping Template in the Integration Request panel (for me it looked like this "TypeL1":"$input.params('typeL1')") using the json content type

Good luck !

answered Jan 11, 2021 at 10:51

greeneye12

738 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

How to pass query parameters in API gateway with S3 json file backend

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related