{"formatVersion":1,"graph":{"connections":[[["c3104e04-b302-4b1d-9cf0-21b272809b36",1],["d1056155-632f-4c71-85e7-fc598551401a",1]],[["c3104e04-b302-4b1d-9cf0-21b272809b36",1],["bdd6d445-631e-4b02-b881-ff1f77c04899",1]],[["d1056155-632f-4c71-85e7-fc598551401a",2],["8106a20d-e0be-476b-9ef4-bfa2a2d518e2",1]],[["8106a20d-e0be-476b-9ef4-bfa2a2d518e2",2],["4c1444b4-dc3d-43d3-80e3-8d7da13f5f1c",1]],[["4c1444b4-dc3d-43d3-80e3-8d7da13f5f1c",2],["6eef175c-8bfc-4f27-81d0-f118a51406de",1]],[["bdd6d445-631e-4b02-b881-ff1f77c04899",2],["60b266c4-aa33-4328-88e0-c3e7e1ab678d",1]]],"nodes":[{"$type":"jsonWebServiceConnectionNode","host":"https://data.gov.ru","port":null,"url":"opendata/7728073222-2/data-20181120T0100.json","data":null,"method":"GET","headers":[],"id":"c3104e04-b302-4b1d-9cf0-21b272809b36","name":"График работы","description":null,"ports":[{"$type":"jsonWebServiceOutputPort","id":1,"tag":null,"direction":"out"},{"$type":"streamInputPort","id":2,"tag":null,"direction":"in","parameterId":null}]},{"$type":"jsonTableNode","path":null,"documentMode":false,"columns":[{"$type":"jsonTableColumn","name":"Address","type":"string"},{"$type":"jsonTableColumn","name":"RoomNumber","type":"integer"},{"$type":"jsonTableColumn","name":"WorkingHours","type":"json"}],"id":"d1056155-632f-4c71-85e7-fc598551401a","name":"График работы и адреса обслуживания","description":null,"ports":[{"$type":"jsonWebServiceInputPort","id":1,"tag":null,"direction":"in","parameterId":null},{"$type":"tableOutputPort","id":2,"tag":null,"direction":"out"}]},{"$type":"projectionNode","rules":[{"$type":"addCalculatedColumn","formula":"ИзвлечьМассив(WorkingHours)","columnName":"Рабочие часы"}],"removeInputColumns":false,"sortRules":[{"$type":"columnSortRule","column":"RoomNumber","order":"ascending"}],"id":"8106a20d-e0be-476b-9ef4-bfa2a2d518e2","name":"Проекция Графика работы","description":null,"ports":[{"$type":"tableInputPort","id":1,"tag":null,"direction":"in","parameterId":null},{"$type":"tableOutputPort","id":2,"tag":null,"direction":"out"}]},{"$type":"expandRowsNode","column":"Рабочие часы","mode":"Array","delimiter":null,"id":"4c1444b4-dc3d-43d3-80e3-8d7da13f5f1c","name":"Развернуть ячейки в строки","description":null,"ports":[{"$type":"tableInputPort","id":1,"tag":null,"direction":"in","parameterId":null},{"$type":"tableOutputPort","id":2,"tag":null,"direction":"out"}]},{"$type":"projectionNode","rules":[{"$type":"addCalculatedColumn","formula":"Извлечь([Рабочие часы]; 'DayOfWeek')","columnName":"День недели"},{"$type":"addCalculatedColumn","formula":"Извлечь([Рабочие часы]; 'Hours')","columnName":"Часы"}],"removeInputColumns":false,"sortRules":[],"id":"6eef175c-8bfc-4f27-81d0-f118a51406de","name":"Проекция Рабочие часы","description":null,"ports":[{"$type":"tableInputPort","id":1,"tag":null,"direction":"in","parameterId":null},{"$type":"tableOutputPort","id":2,"tag":null,"direction":"out"}]},{"$type":"encodeStringNode","encoding":"Unicode","id":"bdd6d445-631e-4b02-b881-ff1f77c04899","name":"Преобразовать в байты","description":null,"ports":[{"$type":"valueInputPort","id":1,"tag":null,"direction":"in","parameterId":null},{"$type":"streamOutputPort","id":2,"tag":null,"direction":"out"}]},{"$type":"saveFileNode","filePath":"C:\\temp\\График работы.json","id":"60b266c4-aa33-4328-88e0-c3e7e1ab678d","name":"Запись полученного ответа в файл","description":null,"ports":[{"$type":"streamInputPort","id":1,"tag":null,"direction":"in","parameterId":null},{"$type":"streamOutputPort","id":2,"tag":null,"direction":"out"}]}]},"layout":{"paperSize":{},"nodes":{"c3104e04-b302-4b1d-9cf0-21b272809b36":{"position":{"x":62,"y":54.99999999999997},"size":{"width":160,"height":40}},"d1056155-632f-4c71-85e7-fc598551401a":{"position":{"x":20,"y":150},"size":{"width":250,"height":40}},"8106a20d-e0be-476b-9ef4-bfa2a2d518e2":{"position":{"x":60,"y":240},"size":{"width":170,"height":40}},"4c1444b4-dc3d-43d3-80e3-8d7da13f5f1c":{"position":{"x":60,"y":330},"size":{"width":170,"height":40}},"6eef175c-8bfc-4f27-81d0-f118a51406de":{"position":{"x":70,"y":410},"size":{"width":150,"height":40}},"bdd6d445-631e-4b02-b881-ff1f77c04899":{"position":{"x":360,"y":150},"size":{"width":150,"height":40}},"60b266c4-aa33-4328-88e0-c3e7e1ab678d":{"position":{"x":330,"y":240},"size":{"width":210,"height":40}}},"links":{}}}