Googleアナリティクス

2019年8月29日木曜日

Diff between collections with LogicApps / Flow

In Logic Apps and Flow, there are so many opportunities to work with arrays and collections, and there are many things to do. A simple method using filtering was created by obtaining the difference between collections (data that exists only in B between A and B) for which no better way was found.

2019年2月20日水曜日

Check a website has been updated

Sometimes I want to detect if a specific website has been updated. If RSS is provided, it can be judged based on it, but it can not be done easily if there is only information on the website. As one method, there is a method to save it somewhere in another storage and compare it, but this time I tried to compare the method without using the storage.

LogicFlow created has been uploaded to Github.

2019年2月16日土曜日

Notify Logic Apps API Connection Error

Original Post is here.

In Logic Apps and Flow, sometimes API connection may fail. It is mainly due to the expiration of certificate deadline. It is necessary to check regularly or when an error occurs. This time I checked the API connection used in Logic Apps and let me notify of e-mail notification of errors.

2018年11月23日金曜日

Check Flow Connector Error

Original post is here.

There is a thing that many people feel using Microsoft Flow, connection of the created connector becomes a connection error periodically. Because it is due to the expiration of the access token used at the time of connection, it may be an error, but checking from the portal every time was troublesome.

I tried to automate this check with Flow this time.

Since it is quite long as an entry, those who want to check in advance have prepared packages exported to github, so please use here as well.

2018年9月26日水曜日

Workflow Function can not be used with LogicFlow's Trigger

Original post is here.

There are some triggers that can be used in LogicFlow that can be set variously. In many cases, direct value is set in most cases, but in some cases you may want to use the function of LogicFlow. However, it was inconvenienced by current specifications.

2018年9月12日水曜日

Like PIVOT conversion of JSON value

Original post is here.

JSON with arrays is troublesome in getting values when operating with LogicApps / Flow. Converting the values horizontally and vertically like PIVOT and converting so that related values can be acquired with specific key values may make subsequent processing easier.

image

For example in this case. Normally, you loop through SampleArray and check the values one by one. Since the current Logic Apps and Flow can only deal with this way, the purpose is to want to make it even easier here.

2018年9月4日火曜日

Delete approval by Flow Management for Admin connector

Original post is here.

Recently Flow Management for Admin connector has been added. Compared with the conventional management connector, the action of the management system has become more increased. Among them, there was an action called Remove Approval, so I checked what kind of movement it would take.