0

I have an onsite SQL server which runs and posts relevant records to to a data warehouse accessible via API endpoint. I need to create a webhook to detect changes whenever rows are added or deleted from the warehouse table.Preferably, the webhook should trigger a message to Azure queue storage via a httptrigger.

  1. How can I go about this in azure? I cant get my hands on any straightforward documentation or tutorial.
  2. If it cant be done in Azure, are there any other third party platforms with which I can create a webhook to detect changes to the table given the end points url?

I have been able to create a webhook in ArcGIS which is currently successfully running on the same logic. I am however now required to change and have that triggered by activity on the datawarehouse API. Any help will be appreciated?

Improve this question
14
  • Do you mean you want the function be trigger when the datawarehouse api be called ? Commented Jan 5, 2021 at 6:15
  • @Hury Shen, I have a URI which is a link with query parameters. How do I ensure when new data meeting a predefined search criteria is input, a http trigger is activated and message sent to queue. The difficulty I have here is creating a webhook or whatever you may want to call it to be listened to by the http trigger. Commented Jan 5, 2021 at 6:19
  • I don't think it can be implemented easily. May I know how did you call the warehouse api ? (what logic does the api run on ?) Commented Jan 5, 2021 at 6:33
  • In a normal code, I call and retrieve data from the api thus;url = "https://url/operations?q=Active%20%3D1%20and%20LATITUDE%20%3D%20%20%220.000000%22%20and%20LONGITUDE%20%3D%20%220.000000%22&pageSize =300" payload = {} headers = {'Authorization': access_token.split('"')[3]} response = requests.request("GET", url, headers=headers, data = payload) #print(response.text.encode('utf8')) j=json.loads(response.text.encode('utf8')) Commented Jan 5, 2021 at 6:36
  • Does that answer your query? Commented Jan 5, 2021 at 6:37
Related questions
4
Windows Azure Web sites python
0
Azure WebHook not saving
3
Python websocket support on Azure web appservice?
Load 7 more related questions Show fewer related questions

0

Reset to default

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Start asking to get answers

Find the answer to your question by asking.

Ask question

Explore related questions

See similar questions with these tags.