{"type":"doc","content":[{"type":"layoutSection","content":[{"type":"layoutColumn","attrs":{"width":66.66},"content":[{"type":"paragraph","content":[{"text":"The Insert statement creates new items. Here is an example:","type":"text"}]},{"type":"paragraph","content":[{"text":"XML:","type":"text"}]},{"type":"codeBlock","content":[{"text":"\n \n \n ABCD-123\n The good item\n A very good item\n En meget god vare\n \n \n ABCD-321\n The good item 2\n A very good item 2\n En meget god vare 2\n \n \n \n","type":"text"}]},{"type":"paragraph","content":[{"text":"JSON:","type":"text"}]},{"type":"codeBlock","content":[{"text":"{\n \"Query\": {\n \"Insert\": {\n \"Items\": [\n {\n \"brand\": \"Normal\",\n \"parentid\": 0,\n \"values\": [\n { \"name\": \"Value\", \"value\": \"ABCD-123\" },\n { \"name\": \"ItemName\", \"language\": \"EN\", \"value\": \"The good item\" },\n { \"name\": \"Description\", \"language\": \"EN\", \"value\": \"A very good item\" },\n { \"name\": \"Description\", \"language\": \"DAN\", \"value\": \"En meget god vare\" }\n ]\n },\n {\n \"brand\": \"Normal\",\n \"parentid\": 0,\n \"values\": [\n { \"name\": \"Value\", \"value\": \"ABCD-321\" },\n { \"name\": \"ItemName\", \"language\": \"EN\", \"value\": \"The good item 2\" },\n { \"name\": \"Description\", \"language\": \"EN\", \"value\": \"A very good item 2\" },\n { \"name\": \"Description\", \"language\": \"DAN\", \"value\": \"En meget god vare 2\" }\n ]\n }\n ]\n },\n \"From\": { \"id\": \"Product\" }\n }\n}","type":"text"}]},{"type":"paragraph","content":[{"text":"As can be seen, it looks very much like an Update-statements and works very much like it. But instead of updating existing items, it simply adds new items. Because it is creating new items, you can specify these two attributes/properties on each item element/object: ","type":"text"}]},{"type":"table","attrs":{"layout":"default","localId":"673c85c2-33dd-4907-9b8a-f29aa93f5eac"},"content":[{"type":"tableRow","content":[{"type":"tableCell","attrs":{"colspan":1,"rowspan":1,"colwidth":[170.0]},"content":[{"type":"paragraph","content":[{"text":"brand","type":"text","marks":[{"type":"textColor","attrs":{"color":"#ff5630"}}]}]}]},{"type":"tableCell","attrs":{"colspan":1,"rowspan":1,"colwidth":[1013.0]},"content":[{"type":"paragraph","content":[{"text":"Specifies the brand of the item to be created (Normal or Virtual)","type":"text"}]}]}]},{"type":"tableRow","content":[{"type":"tableCell","attrs":{"colspan":1,"rowspan":1,"colwidth":[170.0]},"content":[{"type":"paragraph","content":[{"text":"parentID","type":"text","marks":[{"type":"textColor","attrs":{"color":"#ff5630"}}]}]}]},{"type":"tableCell","attrs":{"colspan":1,"rowspan":1,"colwidth":[1013.0]},"content":[{"type":"paragraph","content":[{"text":"Specifies if the item is a child of an already existing item. Specifying a value of 0 will make a root-item. It is only possible to use Virtual Items as parent item","type":"text"}]}]}]}]}]},{"type":"layoutColumn","attrs":{"width":33.33},"content":[{"type":"extension","attrs":{"layout":"default","extensionType":"com.atlassian.confluence.macro.core","extensionKey":"toc","parameters":{"macroParams":{},"macroMetadata":{"macroId":{"value":"9dc1d322-0033-4c6b-8133-fb2f8ce08fa9"},"schemaVersion":{"value":"1"},"title":"Table of Contents"}},"localId":"791d4986-ccfc-46bf-b4d6-f6683e309232"}}]}]}],"version":1}

Browser not supported