Azure Functions - get records by attribute name

jothsna gali 1

I have created a function app to retrieve the records from Azure SQL DB table(loan table). Function app works fine. I want to now add filters and retrieve the records based on loan record attributes ( loan id, loan amount,...). Should I create a new function for each of the attribute that I need or is there any better approach to do it?

Thanks in advance.

JayaC-MSFT 5,531 Reputation points

2020-08-18T08:14:00.893+00:00

@jothsna gali Thank you for reaching out. Could please share the language ( C# /java etc.) you have used to develop the function? Is it a http trigger? Do you want to pass the filters or attributes as query parameter? It would be great if you could provide an example of the query.
JayaC-MSFT 5,531 Reputation points

2020-08-19T13:02:40.333+00:00

@jothsna gali I would be needing few more details such as the language you have used, the type of trigger,how do you want to pass filters ( e.g. as query parameter) etc.
Please refer to : https://github.com/Azure/azure-functions-host/wiki/Sharing-Your-Function-App-name-privately

I can also take it up offline for a closer look and provide a quick and specialized assistance, please send an email with subject line “Attn:Jaya” to AzCommunity[at]Microsoft[dot]com referencing this thread along with the required details: language you have used, the type of trigger,how do you want to pass filters ( e.g. as query parameter) etc.
JayaC-MSFT 5,531 Reputation points

2020-08-24T07:03:51.687+00:00

@jothsna gali Following up to see if my answer helps. Do let me know if you any further queries.
Please 'Accept as answer' if it helped so that it can help others in the community looking for help on similar topics.

1 answer

JayaC-MSFT 5,531 Reputation points

2020-08-20T13:14:21.317+00:00

@jothsna gali You may want to try with a complex JSON payload in the request body ( assuming this is a Http trigger). You can then deserialize the json body into the required format ( https://www.vainolo.com/2018/10/22/azure-functions-part-3-handling-http-query-get-and-post-requests/) and read the property values which you can use to build the final query - if you follow this approach one function would be sufficient. Otherwise you can have multiple functions based on your requirement.
Please let me know if this answers your question.
Please sign in to rate this answer.

0 comments No comments
Sign in to comment

Use comments to ask for clarification, additional information, or improvements to the question.

Share via

Azure Functions - get records by attribute name

1 answer

Your answer