Imperial Parody

{"type":"doc","content":[{"type":"panel","attrs":{"panelIconId":"atlassian-info","panelIcon":":info:","panelColor":"#E3FCEF","panelType":"custom"},"content":[{"type":"paragraph","content":[{"text":"Please read the ","type":"text","marks":[{"type":"strong"}]},{"text":"Terms of Use for Materials on ZennoLab","type":"text","marks":[{"type":"strong"},{"type":"link","attrs":{"href":"https://zennolab.atlassian.net/wiki/spaces/EN/pages/2781675537"}}]}]}]},{"type":"heading","attrs":{"level":2},"content":[{"text":"Table of contents","type":"text"}]},{"type":"expand","attrs":{"title":"Click here to expand the table of contents"},"content":[{"type":"extension","attrs":{"layout":"default","extensionType":"com.atlassian.confluence.macro.core","extensionKey":"toc","parameters":{"macroParams":{"exclude":{"value":"^Оглавление$"}},"macroMetadata":{"macroId":{"value":"855add51-1962-4bd2-bae7-bfe595551b99"},"schemaVersion":{"value":"1"},"title":"Table of Contents"}},"localId":"1e844e2b-d2a8-4919-92bf-dd3cc436d596"}}]},{"type":"rule"},{"type":"heading","attrs":{"level":2},"content":[{"text":"Description","type":"text"}]},{"type":"paragraph","content":[{"text":"The action is used to process and work with JSON and XML.","type":"text"}]},{"type":"panel","attrs":{"panelType":"warning"},"content":[{"type":"paragraph","content":[{"text":"Only one JSON and one XML object can be processed in a project at a time. If you need to process several pieces of data of the same format, then this will need to be done in turn.","type":"text"}]}]},{"type":"heading","attrs":{"level":3},"content":[{"text":"JSON","type":"text"}]},{"type":"paragraph","content":[{"text":"JSON (JavaScript Object Notation) is a simple data exchange format that is easy to read and write by both humans and computers.","type":"text"}]},{"type":"paragraph","content":[{"text":"Example:","type":"text"}]},{"type":"codeBlock","attrs":{"language":"json"},"content":[{"text":"{\n\"firstName\": \"Jhon\",\n \"lastName\": \"Doe\",\n \"address\": {\n \"streetAddress\": \"8478 Rockledge Street\",\n \"city\": \"New York\",\n \"postalCode\": 10306\n },\n \"phoneNumbers\": [\n \"555 123-1234\",\n \"555 987-6541\"\n ]\n}","type":"text"}]},{"type":"heading","attrs":{"level":3},"content":[{"text":"XML","type":"text"}]},{"type":"paragraph","content":[{"text":"XML - (eXtensible Markup Language) is a markup language that resembles HTML. Designed to transmit data, not display it. XML tags are not predefined. It is up to you to define the tags you want.","type":"text"}]},{"type":"codeBlock","content":[{"text":"\n \n Imperial Parody\n Bob Dylan\n USA\n Colombia\n 10.90\n 1985\n \n \n Hide your heart\n Bonnie Tyler\n United Kingdom\n CBS Entries\n 9.90\n 1988\n \n \n Top Hits\n Dolly Parton\n USA\n RCA\n 9.90\n 1982\n \n","type":"text"}]},{"type":"paragraph","content":[{"text":"Example 2:","type":"text"}]},{"type":"panel","attrs":{"panelType":"note"},"content":[{"type":"paragraph","content":[{"text":"It happens that services do not return beautifully formatted text (as in the examples above), but everything in one line, which makes reading much more difficult. In such cases, you can use the so-called beautifiers. ","type":"text"},{"text":"The X/JSON Path Tester","type":"text","marks":[{"type":"link","attrs":{"href":"https://zennolab.atlassian.net/wiki/spaces/EN/pages/924484645/X+JSON+Path+Tester"}}]},{"text":" already has this component built in (","type":"text"},{"text":"Beautify","type":"text","marks":[{"type":"em"}]},{"text":" button)","type":"text"}]},{"type":"paragraph","content":[{"text":"For an action, it doesn't matter if the text is written in one line or is nicely formatted - the main thing is that it is correctly composed.","type":"text","marks":[{"type":"strong"}]}]}]},{"type":"heading","attrs":{"level":2},"content":[{"text":"How to add an action to a project?","type":"text"}]},{"type":"paragraph","content":[{"text":"Via context menu ","type":"text"},{"text":"Add Action -> Data -> Processing JSON / XML ","type":"text","marks":[{"type":"strong"}]}]},{"type":"mediaSingle","attrs":{"layout":"center"},"content":[{"type":"media","attrs":{"width":576,"id":"88929cfc-1be3-46c1-bac8-1a2d7642d8ec","collection":"contentId-924419010","type":"file","height":430}}]},{"type":"paragraph","content":[{"text":"Or use ","type":"text"},{"text":"smart search","type":"text","marks":[{"type":"link","attrs":{"href":"https://zennolab.atlassian.net/wiki/spaces/EN/pages/924581957/Benefits+of+the+ProjectMaker+7+interface#Smart-action-search"}}]},{"text":".","type":"text"}]},{"type":"heading","attrs":{"level":3},"content":[{"text":"Where is JSON / XML used?","type":"text"}]},{"type":"paragraph","content":[{"text":"Most often, these formats are used in the ","type":"text"},{"text":"API","type":"text","marks":[{"type":"link","attrs":{"href":"https://en.wikipedia.org/wiki/API"}}]},{"text":" of various services.","type":"text"}]},{"type":"paragraph","content":[{"text":"For example, services for recognizing ","type":"text"},{"text":"captcha","type":"text","marks":[{"type":"link","attrs":{"href":"https://zennolab.atlassian.net/wiki/spaces/EN/pages/924419454"}}]},{"text":" or ","type":"text"},{"text":"SMS services","type":"text","marks":[{"type":"link","attrs":{"href":"https://zennolab.atlassian.net/wiki/spaces/EN/pages/924484717"}}]},{"text":" (if you work with them directly using ","type":"text"},{"text":"GET","type":"text","marks":[{"type":"link","attrs":{"href":"https://zennolab.atlassian.net/wiki/spaces/EN/pages/924419130"}}]},{"text":", ","type":"text"},{"text":"POST","type":"text","marks":[{"type":"link","attrs":{"href":"https://zennolab.atlassian.net/wiki/spaces/EN/pages/924419142"}}]},{"text":" and ","type":"text"},{"text":"other","type":"text","marks":[{"type":"link","attrs":{"href":"https://zennolab.atlassian.net/wiki/spaces/EN/pages/924419154"}}]},{"text":" requests, bypassing the ","type":"text"},{"text":"Services for SMS processing","type":"text","marks":[{"type":"link","attrs":{"href":"https://zennolab.atlassian.net/wiki/spaces/EN/pages/924451237"}}]},{"text":" and ","type":"text"},{"text":"Recognize captcha","type":"text","marks":[{"type":"link","attrs":{"href":"https://zennolab.atlassian.net/wiki/spaces/EN/pages/924582077"}}]},{"text":" actions) usually work with at least one of these formats (or with two at once)","type":"text"}]},{"type":"heading","attrs":{"level":3},"content":[{"text":"How to work with an action?","type":"text"}]},{"type":"paragraph","content":[{"text":"First, you should choose the type of data with which you will work.","type":"text"}]},{"type":"mediaSingle","attrs":{"layout":"center"},"content":[{"type":"media","attrs":{"width":304,"id":"0685fc70-e486-4841-962d-8478d6030f10","collection":"contentId-924419010","type":"file","height":336}}]},{"type":"heading","attrs":{"level":3},"content":[{"text":"Parsing","type":"text"}]},{"type":"paragraph","content":[{"text":"The data needs to be processed, the ","type":"text"},{"text":"Parsing","type":"text","marks":[{"type":"em"}]},{"text":" action is responsible for this.","type":"text"}]},{"type":"mediaSingle","attrs":{"layout":"center"},"content":[{"type":"media","attrs":{"width":354,"id":"9abf3bb2-134d-489f-8e0c-b1be38cd8890","collection":"contentId-924419010","type":"file","height":342}}]},{"type":"heading","attrs":{"level":3},"content":[{"text":"Variable window","type":"text"}]},{"type":"paragraph","content":[{"text":"The result of the action execution is entered into the Json or Xml project variable, respectively, the content can be viewed in the ","type":"text"},{"text":"Variables Window","type":"text","marks":[{"type":"link","attrs":{"href":"https://zennolab.atlassian.net/wiki/spaces/EN/pages/924484177"}}]}]},{"type":"mediaSingle","attrs":{"layout":"center"},"content":[{"type":"media","attrs":{"width":520,"id":"ce2ba728-498b-4805-a3c2-b517cf96027d","collection":"contentId-924419010","type":"file","height":424}}]},{"type":"paragraph","content":[{"text":"Since XML was parsed in the example, the tab in the Variables window was selected accordingly.","type":"text"}]},{"type":"paragraph","content":[{"text":"The Count (1) variable stores the number of elements - it is very convenient to use it as a delimiter when traversing data in a loop. If in our example there were still tags at the same level with , then there would be a variable CATALOG.DVD.Count with the number of tags","type":"text"}]},{"type":"mediaSingle","attrs":{"layout":"center"},"content":[{"type":"media","attrs":{"width":256,"id":"9a677859-50ee-423e-ad9c-0ce234db9777","collection":"contentId-924419010","type":"file","height":52}}]},{"type":"paragraph","content":[{"text":"With the help of special buttons (2) you can immediately copy a ","type":"text"},{"text":"variable macro","type":"text","marks":[{"type":"link","attrs":{"href":"https://zennolab.atlassian.net/wiki/spaces/EN/pages/924451273"}}]},{"text":" to the clipboard.","type":"text"}]},{"type":"heading","attrs":{"level":3},"content":[{"text":"Variable macros","type":"text"}]},{"type":"paragraph","content":[{"text":"Here is an example of one of the variable macros - ","type":"text"},{"text":"{- Xml.CATALOG.CD [1] .ARTIST-}.","type":"text","marks":[{"type":"code"}]}]},{"type":"paragraph","content":[{"text":"You can use other variables inside this variable, example:","type":"text"}]},{"type":"paragraph","content":[{"text":"{-Xml.CATALOG.","type":"text","marks":[{"type":"strong"}]},{"text":"{-Variable.item_type-}","type":"text","marks":[{"type":"textColor","attrs":{"color":"#ff5630"}},{"type":"strong"}]},{"text":"[","type":"text","marks":[{"type":"strong"}]},{"text":"{-Variable.counter-}","type":"text","marks":[{"type":"textColor","attrs":{"color":"#36b37e"}},{"type":"strong"}]},{"text":"].","type":"text","marks":[{"type":"strong"}]},{"text":"{-Variable.property-}","type":"text","marks":[{"type":"textColor","attrs":{"color":"#4c9aff"}},{"type":"strong"}]},{"text":"-}","type":"text","marks":[{"type":"strong"}]}]},{"type":"mediaSingle","attrs":{"layout":"center"},"content":[{"type":"media","attrs":{"width":718,"id":"c1b5a48f-9d2b-4689-8cf8-b5df9639f74b","collection":"contentId-924419010","type":"file","height":486}}]},{"type":"panel","attrs":{"panelType":"note"},"content":[{"type":"paragraph","content":[{"text":"To quickly insert a variable, you can press the key combination CTRL + SPACEBAR in any text field, a drop-down menu will appear, in this menu, double-click on Xml or Json (depending on what you are working with), then put a period and another menu will appear already with parsed variables.","type":"text"}]}]},{"type":"layoutSection","content":[{"type":"layoutColumn","attrs":{"width":50.0},"content":[{"type":"mediaSingle","attrs":{"layout":"center"},"content":[{"type":"media","attrs":{"width":148,"id":"9677c851-7370-400c-9e7b-67cba3d24966","collection":"contentId-924419010","type":"file","height":216}}]}]},{"type":"layoutColumn","attrs":{"width":50.0},"content":[{"type":"mediaSingle","attrs":{"layout":"center"},"content":[{"type":"media","attrs":{"width":248,"id":"31faf1fd-8055-454b-9ce2-ba89ab596167","collection":"contentId-924419010","type":"file","height":228}}]}]}]},{"type":"heading","attrs":{"level":3},"content":[{"text":"Process JsonPath / XPath","type":"text"}]},{"type":"paragraph","content":[{"text":"This option is used when it is necessary to select a subset of all the data that is processed using the ","type":"text"},{"text":"Parsing ","type":"text","marks":[{"type":"em"}]},{"text":"action. In this case, an ","type":"text"},{"text":"XPath","type":"text","marks":[{"type":"link","attrs":{"href":"https://zennolab.atlassian.net/wiki/spaces/EN/pages/924451177"}}]},{"text":" expression (for XML) or JsonPath (for JSON) is constructed. ","type":"text"},{"text":"The X / JSON Path Tester","type":"text","marks":[{"type":"link","attrs":{"href":"https://zennolab.atlassian.net/wiki/spaces/EN/pages/924484645/X+JSON+Path+Tester"}}]},{"text":" can help you in composing an expression. You can use variable macros in the field to insert an expression.","type":"text"}]},{"type":"mediaSingle","attrs":{"layout":"center"},"content":[{"type":"media","attrs":{"width":378,"id":"b487121c-19bf-49c0-ab83-8d8ced51780a","collection":"contentId-924419010","type":"file","height":148}}]},{"type":"heading","attrs":{"level":3},"content":[{"text":"XML Features","type":"text"}]},{"type":"paragraph","content":[{"text":"XML has node attributes. To access them in macros, square brackets with a string value are used. (For example: ","type":"text"},{"text":"{-Xml.CATALOG.CD [0] [\"item\"] -})","type":"text","marks":[{"type":"code"}]},{"text":".","type":"text"}]},{"type":"mediaSingle","attrs":{"layout":"center"},"content":[{"type":"media","attrs":{"width":378,"id":"e9f3b427-62b5-4146-b237-b2ef14f913f1","collection":"contentId-924419010","type":"file","height":432}}]},{"type":"mediaSingle","attrs":{"layout":"center"},"content":[{"type":"media","attrs":{"width":356,"id":"44ab503f-b591-417e-a632-97c758e8ec90","collection":"contentId-924419010","type":"file","height":448}}]},{"type":"heading","attrs":{"level":3},"content":[{"text":"Processing speed","type":"text"}]},{"type":"paragraph","content":[{"text":"Parsing large JSON or XML while debugging a project in ProjectMaker can take a long time. But when working in ZennoPoster, parsing will be much faster.","type":"text"}]},{"type":"rule"},{"type":"heading","attrs":{"level":3},"content":[{"text":"Add to list","type":"text"}]},{"type":"paragraph","content":[{"text":"This action is used when you need to get one specific property from all data for each element. ","type":"text"},{"text":"Variables","type":"text","marks":[{"type":"link","attrs":{"href":"https://zennolab.atlassian.net/wiki/spaces/EN/pages/924451273"}}]},{"text":" can be used.","type":"text"}]},{"type":"paragraph","content":[{"text":"Property","type":"text","marks":[{"type":"strong"}]},{"text":" - indicates the field that will be parsed as an array. It is possible to use nesting here by specifying a dot (for example: store.employees) If the field is not an array, then one element is added to the list.","type":"text"}]},{"type":"paragraph","content":[{"text":"Subproperty","type":"text","marks":[{"type":"strong"}]},{"text":" - since arrays can contain complex objects, you can specify which value to take from it for the list.","type":"text"}]},{"type":"paragraph","content":[{"text":"If we take the data from the Description section as a basis and imagine that we only need years for each CD, then this action could look like this:","type":"text"}]},{"type":"mediaSingle","attrs":{"layout":"center"},"content":[{"type":"media","attrs":{"width":378,"id":"586ed831-2be3-4b52-a538-cb18df33e4fd","collection":"contentId-924419010","type":"file","height":220}}]},{"type":"rule"},{"type":"heading","attrs":{"level":3},"content":[{"text":"Add to table","type":"text"}]},{"type":"paragraph","content":[{"text":"This action is similar to the previous one, but here you can get not one property, but several. ","type":"text"},{"text":"Variables","type":"text","marks":[{"type":"link","attrs":{"href":"https://zennolab.atlassian.net/wiki/spaces/EN/pages/924451273"}}]},{"text":" can be used.","type":"text"}]},{"type":"mediaSingle","attrs":{"layout":"center"},"content":[{"type":"media","attrs":{"width":378,"id":"b68f6f1f-3bfa-454b-a19e-cf07a86b5b1f","collection":"contentId-924419010","type":"file","height":428}}]},{"type":"paragraph","content":[{"text":"Columns are named as in Excel - capital (!) Latin letters, in alphabetical order. If any column is missed, it will be empty. In the screenshot, you can see that column C is not indicated, this is how it affected the final table:","type":"text"}]},{"type":"mediaSingle","attrs":{"layout":"center"},"content":[{"type":"media","attrs":{"width":370,"id":"67fcaf91-ce26-4547-983b-85c412665771","collection":"contentId-924419010","type":"file","height":190}}]},{"type":"rule"},{"type":"heading","attrs":{"level":3},"content":[{"text":"Working in code","type":"text"}]},{"type":"paragraph","content":[{"text":"In C#, JSON and XML objects are located in the project object. They are of type dynamic. Because of this, the code editor cannot fully display the dropdown hints.","type":"text"}]},{"type":"paragraph","content":[{"text":"Sample code for working with XML:","type":"text"}]},{"type":"codeBlock","content":[{"text":"project.Xml.FromString(project.Variables[\"XmlText\"].Value);\nreturn project.Xml.PurchaseOrder.Address[0][\"Type\"];","type":"text"}]},{"type":"paragraph","content":[{"text":"Example 2:","type":"text"}]},{"type":"codeBlock","attrs":{"language":"csharp"},"content":[{"text":"var list = new List();\nfor(int i = 0; i < project.Xml.PurchaseOrder.Address.Count; i++)\n{\n list.Add(project.Xml.PurchaseOrder.Address[i].Name.Value);\n}\nreturn string.Join(\", \", list);","type":"text"}]},{"type":"paragraph","content":[{"text":"Example 3:","type":"text"}]},{"type":"codeBlock","content":[{"text":"var list = new List();\nforeach(dynamic i in project.Xml.PurchaseOrder.Address)\n{\n list.Add(i.Name.Value);\n}\nreturn string.Join(\", \", list);","type":"text"}]},{"type":"paragraph","content":[{"text":"The same happens with Json. However, it should be noted that access to properties occurs without using “Value”.","type":"text"}]},{"type":"paragraph","content":[{"text":"Example:","type":"text"}]},{"type":"codeBlock","content":[{"text":"return project.Json.employees[1].firstName;","type":"text"}]},{"type":"rule"},{"type":"heading","attrs":{"level":2},"content":[{"text":"Usage example","type":"text"}]},{"type":"heading","attrs":{"level":3},"content":[{"text":"JSON","type":"text"}]},{"type":"paragraph","content":[{"text":"There is a site ","type":"text"},{"text":"http://ip-api.com","type":"text","marks":[{"type":"link","attrs":{"href":"http://ip-api.com/"}}]},{"text":" , which returns detailed information on the ip address using the simplest API. Useful for:","type":"text"}]},{"type":"bulletList","content":[{"type":"listItem","content":[{"type":"paragraph","content":[{"text":"to make sure that the project works through a proxy and not through the main ip","type":"text"}]}]},{"type":"listItem","content":[{"type":"paragraph","content":[{"text":"selection of a country / city during registration, according to proxy data ","type":"text"}]}]}]},{"type":"paragraph","content":[{"text":"It can return data in different formats (more details here - ","type":"text"},{"text":"https://ip-api.com/docs","type":"text","marks":[{"type":"link","attrs":{"href":"https://ip-api.com/docs"}}]},{"text":" ), but we are now interested in JSON.","type":"text"}]},{"type":"paragraph","content":[{"text":"To get information, make a ","type":"text"},{"text":"GET request","type":"text","marks":[{"type":"link","attrs":{"href":"https://zennolab.atlassian.net/wiki/spaces/EN/pages/924419130"}}]},{"text":" at ","type":"text"},{"text":"http://ip-api.com/json","type":"text","marks":[{"type":"link","attrs":{"href":"http://ip-api.com/json"}}]},{"text":" then process the result through the ","type":"text"},{"text":"Parse","type":"text","marks":[{"type":"em"}]},{"text":" action and then work with the received data","type":"text"}]},{"type":"mediaSingle","attrs":{"layout":"center"},"content":[{"type":"media","attrs":{"width":626,"id":"580643ef-901f-41cd-a1d1-89e6100879fd","collection":"contentId-924419010","type":"file","height":508}}]},{"type":"mediaSingle","attrs":{"layout":"center"},"content":[{"type":"media","attrs":{"width":356,"id":"eacff37f-86b9-461e-afa3-03231912f8fc","collection":"contentId-924419010","type":"file","height":448}}]},{"type":"rule"},{"type":"heading","attrs":{"level":3},"content":[{"text":"XML + XPath Processing","type":"text"}]},{"type":"paragraph","content":[{"text":"As data we will use what is in the ","type":"text"},{"text":"Description","type":"text","marks":[{"type":"em"}]},{"text":" section ","type":"text"},{"text":".","type":"text","marks":[{"type":"em"}]}]},{"type":"paragraph","content":[{"text":"Let's imagine that from all the data we only need the album names. For this task, create an XPath expression ","type":"text"},{"text":"// CATALOG / CD / TITLE","type":"text","marks":[{"type":"code"}]},{"text":" . ","type":"text"}]},{"type":"mediaSingle","attrs":{"layout":"center"},"content":[{"type":"media","attrs":{"width":636,"id":"ccdfd15b-c201-4a66-8f1f-a800e314775f","collection":"contentId-924419010","type":"file","height":452}}]},{"type":"paragraph","marks":[{"type":"alignment","attrs":{"align":"center"}}],"content":[{"text":"Action settings and result of its work (right)","type":"text","marks":[{"type":"textColor","attrs":{"color":"#97a0af"}}]}]},{"type":"rule"},{"type":"heading","attrs":{"level":2},"content":[{"text":"Useful links","type":"text"}]},{"type":"bulletList","content":[{"type":"listItem","content":[{"type":"paragraph","content":[{"text":"Variable window","type":"text","marks":[{"type":"link","attrs":{"href":"https://zennolab.atlassian.net/wiki/spaces/EN/pages/924484177"}}]}]}]},{"type":"listItem","content":[{"type":"paragraph","content":[{"text":"Working with variables","type":"text","marks":[{"type":"link","attrs":{"href":"https://zennolab.atlassian.net/wiki/spaces/EN/pages/924451273"}}]}]}]},{"type":"listItem","content":[{"type":"paragraph","content":[{"text":"XPath","type":"text","marks":[{"type":"link","attrs":{"href":"https://zennolab.atlassian.net/wiki/spaces/EN/pages/924451177"}}]}]}]},{"type":"listItem","content":[{"type":"paragraph","content":[{"text":"X/JSON Path Tester","type":"text","marks":[{"type":"link","attrs":{"href":"https://zennolab.atlassian.net/wiki/spaces/EN/pages/924484645/X+JSON+Path+Tester"}}]}]}]},{"type":"listItem","content":[{"type":"paragraph","content":[{"text":"Text processing","type":"text","marks":[{"type":"link","attrs":{"href":"https://zennolab.atlassian.net/wiki/spaces/EN/pages/924451249"}}]}]}]},{"type":"listItem","content":[{"type":"paragraph","content":[{"text":"Cycles","type":"text","marks":[{"type":"link","attrs":{"href":"https://zennolab.atlassian.net/wiki/spaces/EN/pages/924451165/Cycles+loops"}}]}]}]}]}],"version":1}

Browser not supported