Interestingly, after posting my question, the answer showed up. Using this .NET REGEX tester http://regexstorm.net/tester revealed /gm was not required. The final working formula, REPLACEREGEX(Customer.defaultAddress, "[^>]*>", "") Cheers!

I have address data that looks like this, defaultAddress: NameStreetCity ZIPCountry In my flow's insert/update block 'Country' field, I'm using the following REGEX to match everything that is not the country name and replace it with blank "". The targetis to delete everything and leave the country name. REPLACEREGEX(Customer.defaultAddress, "([^>]*>)/gm", "") When I test this REGEX (https://regexr.com/) it matches everything that is not the country name. Great! ([^>]*>)/gm But when I process it in Scribe's flow Debug Mode, the result for Country is the full defaultAddress. Any thoughts on how this could work Thanks, Stephen

Hello. I have a project to regularly update a sheet in Google Drive, from data contained in our CRM (NetSuite). While I've used Tibco Cloud (Scribe) connect 'on a schedule' apps extensively, it appears that develop 'Flogo' is required and I'm new to this. I've created the Google Connector and new Flogo app with an activity configured for my target sheet. How do I retrieve and map the data from NetSuite and deliver it, daily, to update my target Google sheet Many thanks, Stephen

Thanks for this article. What's required to get the data (from a CRM source) that can be used to update a Google sheet Similar to an integration app where data is retrieved from fields in a CRM and mapped to fields (cells) in the target sheet Cheers!

What I have done is to create a map for each item, so that I can use the ItemID as a top-level query-block filter. Cheers.

Thank you Ash, "... start a map with a Query that cycles thru a list of itemids ..." This would be perfect, and how would I begin that The maps I'm working with begin with a query block, which appears to have limited filtering. Can I begin a query stack differently And yes to lookup and fetch, though they are placed down the stack, and I was hoping to filter at the top of query. Many thanks.

Hello, I'd like to filter a query or lookup block to return only 5 item-types, using the field itemID. It appears the connector (Netsuite) doesn't allow multiple filters using the same operator, for example this works: ItemID equals 169164 this creates an error: ItemID equals 169164 OR ItemID equals 112263 Error " The supported query complexity has been exceeded. A field can be used only once." So, is it possible to make something like this work ItemID equals 169164 || 112263 || 125295 || 125820 || 169162 With this one I get a boolean value error Error " Object of type 'System.Boolean' cannot be converted to type 'System.String'. " Have tried: TOSTRING(169164 || 112263 || 125295 || 125820 || 169162) but get the same boolean error as above. I'd really appreciate assistance with this. Thank you, Stephen