How to retrieve Google search results into Mendix and evaluate them in a microflow (compliance screening use case)?
0
Hi all,I'm building a customer screening feature in my Mendix app (Studio Pro 10.x) and would like advice on the best approach.Use case:1. The app stores a Customer Name (e.g., "Hua Hong Semiconductor (Wuxi) Ltd").2. For screening, the customer name must be searched on Google together with predefined keywords from the database (e.g., "Huawei", "Hisilicon").3. Based on the search results, the app should record a conclusion per keyword: True Hit (genuine relationship found), False Hit (keyword appears but in an unrelated context), or No Match.What I have working so far:- A nanoflow with an Open URL action that builds the search URL: 'https://www.google.com/search?q=' + urlEncode($SearchRequest/CustomerName + ' ' + 'Huawei')- This opens Google in a new tab, but the user has to review the results manually and type the conclusion back into the app.What I want to achieve:- Remove the manual step: have Mendix retrieve the search results itself (via Call REST?) and auto-populate the conclusion and supporting URL.My questions:1. Is the Google Custom Search JSON API the recommended way to do this from a Call REST activity, or is there a marketplace module that already wraps this?2. Has anyone implemented snippet-level evaluation in a microflow (checking if both the company name and keyword occur in the same result snippet)? Any pitfalls with import mappings for the Custom Search response?3. For context-based classification (distinguishing a genuine relationship from coincidental co-occurrence), has anyone integrated an LLM step (e.g., Azure OpenAI) after the search call? Which connector did you use?Mendix version: Studio Pro 10.xAny pointers, marketplace modules, or example implementations would be much appreciated. Thanks!