{"type":"doc","content":[{"type":"paragraph","content":[{"text":"K provides an API which can be sent a JSON payload to bulk update objects in K","type":"text"}]},{"type":"paragraph","content":[{"text":"You can use this API to bulk update descriptions, classifications, owners etc for tables, reports etc ","type":"text"}]},{"type":"paragraph"},{"type":"heading","attrs":{"level":2},"content":[{"text":"1. Preparing the data to upload","type":"text"}]},{"type":"paragraph","content":[{"text":"The following information is used by the API to update the object metadata","type":"text"}]},{"type":"panel","attrs":{"panelType":"warning"},"content":[{"type":"paragraph","content":[{"text":"JSON is to be UTF-8 encoded.","type":"text"}]}]},{"type":"paragraph"},{"type":"heading","attrs":{"level":3},"content":[{"text":"Data template","type":"text"}]},{"type":"table","attrs":{"layout":"full-width","localId":"e5a7fded-6cbc-4301-97e6-bca4a7b1a3af"},"content":[{"type":"tableRow","content":[{"type":"tableHeader","attrs":{"colspan":1,"rowspan":1,"colwidth":[197.0]},"content":[{"type":"paragraph","content":[{"text":"ATTRIBUTE","type":"text","marks":[{"type":"strong"}]}]}]},{"type":"tableHeader","attrs":{"colspan":1,"rowspan":1,"colwidth":[570.0]},"content":[{"type":"paragraph","content":[{"text":"DESCRIPTION","type":"text","marks":[{"type":"strong"}]}]}]},{"type":"tableHeader","attrs":{"colspan":1,"rowspan":1,"colwidth":[172.0]},"content":[{"type":"paragraph","content":[{"text":"REQUIRED","type":"text","marks":[{"type":"strong"}]}]}]},{"type":"tableHeader","attrs":{"colspan":1,"rowspan":1,"colwidth":[286.0]},"content":[{"type":"paragraph","content":[{"text":"DATA TYPE","type":"text","marks":[{"type":"strong"}]}]}]},{"type":"tableHeader","attrs":{"colspan":1,"rowspan":1,"colwidth":[575.0]},"content":[{"type":"paragraph","content":[{"text":"Comments","type":"text","marks":[{"type":"strong"}]}]}]}]},{"type":"tableRow","content":[{"type":"tableCell","attrs":{"colspan":1,"rowspan":1,"colwidth":[197.0]},"content":[{"type":"paragraph","content":[{"text":"id","type":"text"}]}]},{"type":"tableCell","attrs":{"colspan":1,"rowspan":1,"colwidth":[570.0]},"content":[{"type":"paragraph","content":[{"text":"Row ID for each object.","type":"text"}]},{"type":"paragraph","content":[{"text":"The Row ID must be unique per object","type":"text"}]},{"type":"paragraph","content":[{"text":"This is used to all the caller to linked rejected rows and error messages in the response to the objects in the request payload.","type":"text"}]}]},{"type":"tableCell","attrs":{"colspan":1,"rowspan":1,"colwidth":[172.0]},"content":[{"type":"paragraph","content":[{"text":"Y","type":"text"}]}]},{"type":"tableCell","attrs":{"colspan":1,"rowspan":1,"colwidth":[286.0]},"content":[{"type":"paragraph","content":[{"text":"INTEGER","type":"text"}]}]},{"type":"tableCell","attrs":{"colspan":1,"rowspan":1,"colwidth":[575.0]},"content":[{"type":"paragraph","content":[{"text":"Generated id so we can identify rejects by id back as in the error message, completely up to how they want to generate the id as long as its unique within the payload otherwise it may cause confusion with error messages.","type":"text"}]}]}]},{"type":"tableRow","content":[{"type":"tableCell","attrs":{"colspan":1,"rowspan":1,"colwidth":[197.0]},"content":[{"type":"paragraph","content":[{"text":"object_k_id","type":"text"}]}]},{"type":"tableCell","attrs":{"colspan":1,"rowspan":1,"colwidth":[570.0]},"content":[{"type":"paragraph","content":[{"text":"The ID attribute for a K object.","type":"text"}]},{"type":"paragraph","content":[{"text":"Only populate if you need to reprocess objects because they errored because the name was not unique.","type":"text"}]},{"type":"paragraph","content":[{"text":"This can happen for Reports and Sheets where the object meta (below) is not unique","type":"text"}]},{"type":"paragraph"}]},{"type":"tableCell","attrs":{"colspan":1,"rowspan":1,"colwidth":[172.0]},"content":[{"type":"paragraph","content":[{"text":"N","type":"text"}]},{"type":"paragraph","content":[{"text":"Only required when reprocessing objects where the name is not unique","type":"text","marks":[{"type":"annotation","attrs":{"annotationType":"inlineComment","id":"0b316aa9-73f9-45fc-932f-2a449ee6efcb"}},{"type":"em"}]}]}]},{"type":"tableCell","attrs":{"colspan":1,"rowspan":1,"colwidth":[286.0]},"content":[{"type":"paragraph","content":[{"text":"UUID","type":"text"}]}]},{"type":"tableCell","attrs":{"colspan":1,"rowspan":1,"colwidth":[575.0]},"content":[{"type":"paragraph","content":[{"text":"The ID can be found in K by searching for the object and noting and taking the UUID from he url of the object’s profile page. Eg ","type":"text"},{"text":"4daa6fa3-3b32-3f07-b587-67bcd8133d35","type":"text","marks":[{"type":"code"}]}]},{"type":"paragraph","content":[{"text":"from the URL","type":"text"}]},{"type":"paragraph","content":[{"text":"https://.kada.ai/profile/content/4daa6fa3-3b32-3f07-b587-67bcd8133d35","type":"text","marks":[{"type":"code"}]}]},{"type":"paragraph"},{"type":"paragraph","content":[{"text":"If you know the UUID inside K, specify and we will use this over object_meta to identify the object, this is helpful is cases such as reports where multiple reports potentially can have the same name but different ids and ids for reports are generally derived from the system id and not uniquely generated by K.","type":"text"}]}]}]},{"type":"tableRow","content":[{"type":"tableCell","attrs":{"colspan":1,"rowspan":1,"colwidth":[197.0]},"content":[{"type":"paragraph","content":[{"text":"object_type","type":"text"}]}]},{"type":"tableCell","attrs":{"colspan":1,"rowspan":1,"colwidth":[570.0]},"content":[{"type":"paragraph","content":[{"text":"valid values: SCHEMA/TABLE/COLUMN/REPORT/SHEET","type":"text"}]},{"type":"paragraph"}]},{"type":"tableCell","attrs":{"colspan":1,"rowspan":1,"colwidth":[172.0]},"content":[{"type":"paragraph","content":[{"text":"Y","type":"text"}]}]},{"type":"tableCell","attrs":{"colspan":1,"rowspan":1,"colwidth":[286.0]},"content":[{"type":"paragraph","content":[{"text":"STRING","type":"text"}]}]},{"type":"tableCell","attrs":{"colspan":1,"rowspan":1,"colwidth":[575.0]},"content":[{"type":"paragraph","content":[{"text":"Note these must be UPPER CASE.","type":"text"}]}]}]},{"type":"tableRow","content":[{"type":"tableCell","attrs":{"colspan":1,"rowspan":1,"colwidth":[197.0]},"content":[{"type":"paragraph","content":[{"text":"object_meta","type":"text"}]}]},{"type":"tableCell","attrs":{"colspan":1,"rowspan":1,"colwidth":[570.0]},"content":[{"type":"paragraph","content":[{"text":"Attributes to uniquely identify the object in K","type":"text"}]},{"type":"paragraph","content":[{"text":"NOTE that object_meta properties are different per object_type.","type":"text"}]},{"type":"paragraph"}]},{"type":"tableCell","attrs":{"colspan":1,"rowspan":1,"colwidth":[172.0]},"content":[{"type":"paragraph","content":[{"text":"Y","type":"text"}]}]},{"type":"tableCell","attrs":{"colspan":1,"rowspan":1,"colwidth":[286.0]},"content":[{"type":"paragraph","content":[{"text":"JSON code blocks","type":"text"}]},{"type":"paragraph","content":[{"text":"Example for a TABLE. See more examples below","type":"text"}]},{"type":"codeBlock","content":[{"text":"\"object_meta\": {\n \"source_id\": 1008,\n \"database\": \"adventureworks\",\n \"schema\": \"sales\",\n \"table\": \"customer\"\n }","type":"text"}]}]},{"type":"tableCell","attrs":{"colspan":1,"rowspan":1,"colwidth":[575.0]},"content":[{"type":"paragraph","content":[{"text":"All object_meta requires a ","type":"text"},{"text":"source_id","type":"text","marks":[{"type":"code"}]},{"text":" This value can be found in Admin > Sources.","type":"text"}]},{"type":"paragraph","content":[{"text":"Get reference list of sources","type":"text","marks":[{"type":"strong"}]}]},{"type":"paragraph","content":[{"text":"https:///api/sources","type":"text","marks":[{"type":"code"}]}]},{"type":"paragraph","content":[{"text":"Specific information about that particular object type, this can be unique to each object type, generally the information needed to identify it","type":"text"}]},{"type":"paragraph"},{"type":"paragraph","content":[{"text":"Get source ID from the UI","type":"text","marks":[{"type":"strong"}]}]},{"type":"paragraph","content":[{"text":"Go to Platform Settings. Click on Sources. Source ID is displayed next to each source you have integrated","type":"text"}]},{"type":"mediaSingle","attrs":{"layout":"center"},"content":[{"type":"media","attrs":{"width":1170,"id":"f93efecc-df25-4f4f-a6d3-e370e55dec45","collection":"contentId-2002157569","type":"file","height":90}}]},{"type":"paragraph"},{"type":"paragraph"},{"type":"paragraph"}]}]},{"type":"tableRow","content":[{"type":"tableCell","attrs":{"colspan":1,"rowspan":1,"colwidth":[197.0]},"content":[{"type":"paragraph","content":[{"text":"description","type":"text"}]}]},{"type":"tableCell","attrs":{"colspan":1,"rowspan":1,"colwidth":[570.0]},"content":[{"type":"paragraph","content":[{"text":"The description for the object.","type":"text"}]},{"type":"paragraph","content":[{"text":"Any existing description will be overridden","type":"text"}]},{"type":"paragraph","content":[{"text":"If a blank description is provided it will be ignored. ","type":"text"}]}]},{"type":"tableCell","attrs":{"colspan":1,"rowspan":1,"colwidth":[172.0]},"content":[{"type":"paragraph","content":[{"text":"N ","type":"text"}]}]},{"type":"tableCell","attrs":{"colspan":1,"rowspan":1,"colwidth":[286.0]},"content":[{"type":"paragraph","content":[{"text":"STRING","type":"text"}]}]},{"type":"tableCell","attrs":{"colspan":1,"rowspan":1,"colwidth":[575.0]},"content":[{"type":"paragraph","content":[{"text":"From this attribute onwards at least 1 should be provided otherwise there is nothing to be enriched for the object.","type":"text"}]}]}]},{"type":"tableRow","content":[{"type":"tableCell","attrs":{"colspan":1,"rowspan":1,"colwidth":[197.0]},"content":[{"type":"paragraph","content":[{"text":"business_name","type":"text"}]}]},{"type":"tableCell","attrs":{"colspan":1,"rowspan":1,"colwidth":[570.0]},"content":[{"type":"paragraph","content":[{"text":"This will populate the business name for the object. ","type":"text"}]},{"type":"paragraph","content":[{"text":"Any existing business name will be overridden","type":"text"}]},{"type":"paragraph","content":[{"text":"If a blank business name is provided it will be ignored. ","type":"text"}]}]},{"type":"tableCell","attrs":{"colspan":1,"rowspan":1,"colwidth":[172.0]},"content":[{"type":"paragraph","content":[{"text":"N","type":"text"}]}]},{"type":"tableCell","attrs":{"colspan":1,"rowspan":1,"colwidth":[286.0]},"content":[{"type":"paragraph","content":[{"text":"STRING","type":"text"}]}]},{"type":"tableCell","attrs":{"colspan":1,"rowspan":1,"colwidth":[575.0]},"content":[{"type":"paragraph","content":[{"text":"will populate the alternate name","type":"text"}]}]}]},{"type":"tableRow","content":[{"type":"tableCell","attrs":{"colspan":1,"rowspan":1,"colwidth":[197.0]},"content":[{"type":"paragraph","content":[{"text":"business_logic","type":"text"}]}]},{"type":"tableCell","attrs":{"colspan":1,"rowspan":1,"colwidth":[570.0]},"content":[{"type":"paragraph","content":[{"text":"A description to describe the business logic use to create the object","type":"text"}]}]},{"type":"tableCell","attrs":{"colspan":1,"rowspan":1,"colwidth":[172.0]},"content":[{"type":"paragraph","content":[{"text":"N","type":"text"}]}]},{"type":"tableCell","attrs":{"colspan":1,"rowspan":1,"colwidth":[286.0]},"content":[{"type":"paragraph","content":[{"text":"STRING","type":"text"}]}]},{"type":"tableCell","attrs":{"colspan":1,"rowspan":1,"colwidth":[575.0]},"content":[{"type":"paragraph","content":[{"text":"You should check if similar business logic for the object does not exist before creating to avoid creating duplicates","type":"text","marks":[{"type":"annotation","attrs":{"annotationType":"inlineComment","id":"950f4d23-cec4-4567-921c-548bbcce9b10"}}]}]}]}]},{"type":"tableRow","content":[{"type":"tableCell","attrs":{"colspan":1,"rowspan":1,"colwidth":[197.0]},"content":[{"type":"paragraph","content":[{"text":"owners","type":"text"}]}]},{"type":"tableCell","attrs":{"colspan":1,"rowspan":1,"colwidth":[570.0]},"content":[{"type":"paragraph","content":[{"text":"An owner’s username of the onboarded user (typically email).","type":"text"}]},{"type":"paragraph","content":[{"text":"If platform_profile_user_lookups is set to ","type":"text"},{"text":"data_roles","type":"text","marks":[{"type":"code"}]},{"text":" then the user must be linked to the ","type":"text"},{"text":"Data Owner","type":"text","marks":[{"type":"code"}]},{"text":" instance.","type":"text"}]},{"type":"paragraph","content":[{"text":"Set to empty list ","type":"text"},{"text":"“owners\":[]","type":"text","marks":[{"type":"code"}]},{"text":" of included property but there are no owners","type":"text"}]},{"type":"paragraph"}]},{"type":"tableCell","attrs":{"colspan":1,"rowspan":1,"colwidth":[172.0]},"content":[{"type":"paragraph","content":[{"text":"N","type":"text"}]}]},{"type":"tableCell","attrs":{"colspan":1,"rowspan":1,"colwidth":[286.0]},"content":[{"type":"paragraph","content":[{"text":"LIST","type":"text"}]},{"type":"paragraph"}]},{"type":"tableCell","attrs":{"colspan":1,"rowspan":1,"colwidth":[575.0]},"content":[{"type":"paragraph","content":[{"text":"list of owners identified by either the username (if synced with AD this is the email of the user) of the onboarded user ","type":"text","marks":[{"type":"annotation","attrs":{"annotationType":"inlineComment","id":"8b04c52b-67c2-4253-9690-77aa95115940"}}]}]},{"type":"paragraph","content":[{"text":"Note: Check whether you have a set of owners configured or any user can be an owner This is configured in Platform settings - Customisation","type":"text","marks":[{"type":"annotation","attrs":{"annotationType":"inlineComment","id":"8b04c52b-67c2-4253-9690-77aa95115940"}}]}]},{"type":"paragraph"},{"type":"paragraph","content":[{"text":"API to get list of owners","type":"text","marks":[{"type":"strong"}]}]},{"type":"paragraph","content":[{"text":"https:///api/collectioninstances/16e05af2-13fa-301d-b7fa-69d48bc71d7d/related?object_name=USER&relationship=MEMBERS","type":"text","marks":[{"type":"code"}]}]}]}]},{"type":"tableRow","content":[{"type":"tableCell","attrs":{"colspan":1,"rowspan":1,"colwidth":[197.0]},"content":[{"type":"paragraph","content":[{"text":"stewards","type":"text"}]}]},{"type":"tableCell","attrs":{"colspan":1,"rowspan":1,"colwidth":[570.0]},"content":[{"type":"paragraph","content":[{"text":"A list of steward usernames of the onboarded user (typically email) . ","type":"text"}]},{"type":"paragraph","content":[{"text":"If platform_profile_user_lookups is set to ","type":"text"},{"text":"data_roles","type":"text","marks":[{"type":"code"}]},{"text":" then the user must be linked to the ","type":"text"},{"text":"Data Steward","type":"text","marks":[{"type":"code"}]},{"text":" instance.","type":"text"}]},{"type":"paragraph","content":[{"text":"Set to empty list ","type":"text"},{"text":"“stewards\":[]","type":"text","marks":[{"type":"code"}]},{"text":" of included property but there are no stewards","type":"text"}]},{"type":"paragraph"},{"type":"paragraph"}]},{"type":"tableCell","attrs":{"colspan":1,"rowspan":1,"colwidth":[172.0]},"content":[{"type":"paragraph","content":[{"text":"N","type":"text"}]}]},{"type":"tableCell","attrs":{"colspan":1,"rowspan":1,"colwidth":[286.0]},"content":[{"type":"paragraph","content":[{"text":"LIST","type":"text"}]}]},{"type":"tableCell","attrs":{"colspan":1,"rowspan":1,"colwidth":[575.0]},"content":[{"type":"paragraph","content":[{"text":"list of stewards ","type":"text","marks":[{"type":"annotation","attrs":{"annotationType":"inlineComment","id":"15ddee28-8fc9-4777-bc37-d0822d3b6ee2"}}]},{"text":"identified by username (if synced with AD this is the email of the user) of the onboarded user (check platform_profile_user_lookups value data_roles vs any_user)","type":"text","marks":[{"type":"annotation","attrs":{"annotationType":"inlineComment","id":"8b04c52b-67c2-4253-9690-77aa95115940"}},{"type":"annotation","attrs":{"annotationType":"inlineComment","id":"15ddee28-8fc9-4777-bc37-d0822d3b6ee2"}}]}]},{"type":"paragraph","content":[{"text":"Note: Check whether you have a set of stewards configured or any user can be an owner This is configured in Platform settings - Customisation","type":"text","marks":[{"type":"annotation","attrs":{"annotationType":"inlineComment","id":"8b04c52b-67c2-4253-9690-77aa95115940"}}]}]},{"type":"paragraph"},{"type":"paragraph","content":[{"text":"API to get a list of stewards","type":"text","marks":[{"type":"strong"}]}]},{"type":"paragraph","content":[{"text":"https:///api/collectioninstances/d13d6b10-a535-3718-854d-459f086ad057/related?object_name=USER&relationship=MEMBERS","type":"text","marks":[{"type":"code"}]}]}]}]},{"type":"tableRow","content":[{"type":"tableCell","attrs":{"colspan":1,"rowspan":1,"colwidth":[197.0]},"content":[{"type":"paragraph","content":[{"text":"verified_use_cases","type":"text"}]}]},{"type":"tableCell","attrs":{"colspan":1,"rowspan":1,"colwidth":[570.0]},"content":[{"type":"paragraph","content":[{"text":"A list of IDs for the verified use cases to be linked to this object.","type":"text"}]},{"type":"paragraph","content":[{"text":"Set to empty list ","type":"text"},{"text":"“verified_use_cases\":[]","type":"text","marks":[{"type":"code"}]},{"text":" of included property but there are no verified_use_cases","type":"text"}]},{"type":"paragraph"}]},{"type":"tableCell","attrs":{"colspan":1,"rowspan":1,"colwidth":[172.0]},"content":[{"type":"paragraph","content":[{"text":"N","type":"text"}]}]},{"type":"tableCell","attrs":{"colspan":1,"rowspan":1,"colwidth":[286.0]},"content":[{"type":"paragraph","content":[{"text":"LIST","type":"text"}]}]},{"type":"tableCell","attrs":{"colspan":1,"rowspan":1,"colwidth":[575.0]},"content":[{"type":"paragraph","content":[{"text":"UUID of verified use cases","type":"text"},{"text":", separated into these categories as the links are different and easier for the job to process","type":"text","marks":[{"type":"annotation","attrs":{"annotationType":"inlineComment","id":"c68188af-1fb5-4460-bf09-f23d0ee3d039"}}]}]},{"type":"paragraph"},{"type":"paragraph","content":[{"text":"API to get a list of verified use cases","type":"text","marks":[{"type":"strong"}]}]},{"type":"paragraph","content":[{"text":"https:///api/collectioninstances?collection_id=0ffdae93-b46c-38c2-8511-8183f1d89c8d","type":"text","marks":[{"type":"code"}]}]}]}]},{"type":"tableRow","content":[{"type":"tableCell","attrs":{"colspan":1,"rowspan":1,"colwidth":[197.0]},"content":[{"type":"paragraph","content":[{"text":"classifications","type":"text"}]}]},{"type":"tableCell","attrs":{"colspan":1,"rowspan":1,"colwidth":[570.0]},"content":[{"type":"paragraph","content":[{"text":"A ID of the classification to be linked to this object. ","type":"text"}]},{"type":"paragraph","content":[{"text":"This should be a single value.","type":"text","marks":[{"type":"strong"}]}]},{"type":"paragraph","content":[{"text":"Set to empty list ","type":"text"},{"text":"“classifications\":[]","type":"text","marks":[{"type":"code"}]},{"text":" of included property but there are no classifications.","type":"text"}]},{"type":"paragraph"}]},{"type":"tableCell","attrs":{"colspan":1,"rowspan":1,"colwidth":[172.0]},"content":[{"type":"paragraph","content":[{"text":"N","type":"text"}]}]},{"type":"tableCell","attrs":{"colspan":1,"rowspan":1,"colwidth":[286.0]},"content":[{"type":"paragraph","content":[{"text":"LIST","type":"text"}]}]},{"type":"tableCell","attrs":{"colspan":1,"rowspan":1,"colwidth":[575.0]},"content":[{"type":"paragraph","content":[{"text":"UUID of classifications","type":"text"}]},{"type":"paragraph"},{"type":"paragraph","content":[{"text":"API to get a list of classifications","type":"text","marks":[{"type":"strong"}]}]},{"type":"paragraph","content":[{"text":"https:///api/collectioninstances?collection_id=e1fd2337-1b0e-3841-8d60-7c85daa1707e","type":"text","marks":[{"type":"code"}]}]}]}]},{"type":"tableRow","content":[{"type":"tableCell","attrs":{"colspan":1,"rowspan":1,"colwidth":[197.0]},"content":[{"type":"paragraph","content":[{"text":"domains","type":"text"}]}]},{"type":"tableCell","attrs":{"colspan":1,"rowspan":1,"colwidth":[570.0]},"content":[{"type":"paragraph","content":[{"text":"A list of IDs of the domains to be linked to this object. ","type":"text"}]},{"type":"paragraph","content":[{"text":"Set to empty list ","type":"text"},{"text":"“domains\":[]","type":"text","marks":[{"type":"code"}]},{"text":" of included property but there are no domains.","type":"text"}]},{"type":"paragraph"}]},{"type":"tableCell","attrs":{"colspan":1,"rowspan":1,"colwidth":[172.0]},"content":[{"type":"paragraph","content":[{"text":"N","type":"text"}]}]},{"type":"tableCell","attrs":{"colspan":1,"rowspan":1,"colwidth":[286.0]},"content":[{"type":"paragraph","content":[{"text":"LIST","type":"text"}]}]},{"type":"tableCell","attrs":{"colspan":1,"rowspan":1,"colwidth":[575.0]},"content":[{"type":"paragraph","content":[{"text":"UUID of domains","type":"text"}]},{"type":"paragraph"},{"type":"paragraph","content":[{"text":"API to get a list of domains","type":"text","marks":[{"type":"strong"}]}]},{"type":"paragraph","content":[{"text":"https:///api/collectioninstances?collection_id=73f92690-2edd-33a9-ad32-4f9c225a5c18","type":"text","marks":[{"type":"code"}]}]}]}]}]},{"type":"paragraph"},{"type":"heading","attrs":{"level":3},"content":[{"text":"Example payloads","type":"text"}]},{"type":"heading","attrs":{"level":4},"content":[{"text":"Schema","type":"text"}]},{"type":"codeBlock","attrs":{"language":"json"},"content":[{"text":"[\n {\n \"id\": 1,\n \"object_k_id\": \"982c18cf-643a-356b-bdef-15d69919d1d1\",\n \"object_type\": \"SCHEMA\",\n \"object_meta\": {\n \"source_id\": 1008,\n \"database\": \"adventureworks\",\n \"schema\": \"sales\"\n },\n \"description\": \"my new schema\",\n \"business_name\": \"customer ledger\",\n \"business_logic\": \"some busines logic\",\n \"owners\": [\"xyz@kada.ai\"],\n \"stewards\": [\"abc@kada.ai\"],\n \"verified_use_cases\": [\"982c18cf-643a-356b-bdef-15d69919d1d1\"],\n \"classifications\": [\"982c18cf-643a-356b-bdef-15d69919d1d1\"],\n \"domains\": [\"982c18cf-643a-356b-bdef-15d69919d1d1\"]\n }\n]","type":"text"}]},{"type":"heading","attrs":{"level":4},"content":[{"text":"Table","type":"text"}]},{"type":"codeBlock","attrs":{"language":"json"},"content":[{"text":"[\n {\n \"id\": 1,\n \"object_k_id\": \"982c18cf-643a-356b-bdef-15d69919d1d1\",\n \"object_type\": \"TABLE\",\n \"object_meta\": {\n \"source_id\": 1008,\n \"database\": \"adventureworks\",\n \"schema\": \"sales\",\n \"table\": \"customer\"\n },\n \"description\": \"my new table\",\n \"business_name\": \"customer ledger\",\n \"business_logic\": \"some busines logic\",\n \"owners\": [\"xyz@kada.ai\"],\n \"stewards\": [\"abc@kada.ai\"],\n \"verified_use_cases\": [\"982c18cf-643a-356b-bdef-15d69919d1d1\"],\n \"classifications\": [\"982c18cf-643a-356b-bdef-15d69919d1d1\"],\n \"domains\": [\"982c18cf-643a-356b-bdef-15d69919d1d1\"]\n }\n]","type":"text"}]},{"type":"heading","attrs":{"level":4},"content":[{"text":"Column","type":"text"}]},{"type":"codeBlock","attrs":{"language":"json"},"content":[{"text":"[\n {\n \"id\": 1,\n \"object_k_id\": \"982c18cf-643a-356b-bdef-15d69919d1d1\",\n \"object_type\": \"COLUMN\",\n \"object_meta\": {\n \"source_id\": 1008,\n \"database\": \"adventureworks\",\n \"schema\": \"sales\",\n \"table\": \"customer\",\n \"column\": \"customer_id\"\n },\n \"description\": \"my new column\",\n \"business_name\": \"customer ledger\",\n \"business_logic\": \"some busines logic\",\n \"owners\": [\"xyz@kada.ai\"],\n \"stewards\": [\"abc@kada.ai\"],\n \"verified_use_cases\": [\"982c18cf-643a-356b-bdef-15d69919d1d1\"],\n \"classifications\": [\"982c18cf-643a-356b-bdef-15d69919d1d1\"],\n \"domains\": [\"982c18cf-643a-356b-bdef-15d69919d1d1\"]\n }\n]","type":"text"}]},{"type":"heading","attrs":{"level":4},"content":[{"text":"Report","type":"text"}]},{"type":"codeBlock","attrs":{"language":"json"},"content":[{"text":"[\n {\n \"id\": 1,\n \"object_k_id\": \"982c18cf-643a-356b-bdef-15d69919d1d1\",\n \"object_type\": \"REPORT\",\n \"object_meta\": {\n \"source_id\": 1008,\n \"name\": \"My brand spanking new report\"\n },\n \"description\": \"Some report\",\n \"business_name\": \"Some business name\",\n \"business_logic\": \"some busines logic\",\n \"owners\": [\"xyz@kada.ai\"],\n \"stewards\": [\"abc@kada.ai\"],\n \"verified_use_cases\": [\"982c18cf-643a-356b-bdef-15d69919d1d1\"],\n \"classifications\": [\"982c18cf-643a-356b-bdef-15d69919d1d1\"],\n \"domains\": [\"982c18cf-643a-356b-bdef-15d69919d1d1\"]\n }\n]","type":"text"}]},{"type":"heading","attrs":{"level":4},"content":[{"text":"Sheet","type":"text"}]},{"type":"codeBlock","attrs":{"language":"json"},"content":[{"text":"[\n {\n \"id\": 1,\n \"object_k_id\": \"982c18cf-643a-356b-bdef-15d69919d1d1\",\n \"object_type\": \"SHEET\",\n \"object_meta\": {\n \"source_id\": 1008,\n \"name\": \"My brand spanking new report sheet\"\n },\n \"description\": \"Report tile of sorts\",\n \"business_name\": \"Some interesting business name\",\n \"owners\": [\"xyz@kada.ai\"],\n \"stewards\": [\"abc@kada.ai\"],\n \"verified_use_cases\": [\"982c18cf-643a-356b-bdef-15d69919d1d1\"],\n \"classifications\": [\"982c18cf-643a-356b-bdef-15d69919d1d1\"],\n \"domains\": [\"982c18cf-643a-356b-bdef-15d69919d1d1\"]\n }\n]","type":"text"}]},{"type":"paragraph"},{"type":"heading","attrs":{"level":2},"content":[{"text":"3. Setting up the API Key","type":"text"}]},{"type":"paragraph","content":[{"text":"Follow the API Guides to setup an access Token","type":"text"}]},{"type":"paragraph","content":[{"type":"inlineCard","attrs":{"url":"https://kada-knowledge-library.scrollhelp.site/home/api-guides"}},{"text":" ","type":"text"}]},{"type":"paragraph"},{"type":"heading","attrs":{"level":2},"content":[{"text":"4. Using the API","type":"text"}]},{"type":"heading","attrs":{"level":3},"content":[{"text":"API Endpoint","type":"text"}]},{"type":"paragraph","content":[{"text":"There is a single end point for uploading your Update payload. ","type":"text"}]},{"type":"codeBlock","content":[{"text":"POST /api/metadata/enrichment","type":"text"}]},{"type":"paragraph","content":[{"text":"Example","type":"text"}]},{"type":"codeBlock","attrs":{"language":"shell"},"content":[{"text":"curl --location --request POST 'https://.kada.ai:443/api/metadata/enrichment' \\\n--header 'Authorization: Bearer ' \\\n--form 'data=@\"/path/to/your/enrichment_file.json\"'","type":"text"}]},{"type":"paragraph"},{"type":"paragraph"},{"type":"heading","attrs":{"level":3},"content":[{"text":"API Validation","type":"text"}]},{"type":"paragraph","content":[{"text":"The API will read your payload and perform a set of validations over the format of your payload.","type":"text"}]},{"type":"paragraph","content":[{"text":"If the validation fails, the API returns a error payload with additional detail on what has failed validation","type":"text"}]},{"type":"paragraph","content":[{"text":"In this example the key ","type":"text"},{"text":"\"1\"","type":"text","marks":[{"type":"code"}]},{"text":" refers to the element at index 1 in the json file uploaded. ","type":"text"}]},{"type":"codeBlock","content":[{"text":"{\n \"errors\": {\n \"1\": {\n \"stewards\": [\"Not a valid list.\"]\n }\n }\n}","type":"text"}]},{"type":"paragraph"},{"type":"heading","attrs":{"level":3},"content":[{"text":"API Responses","type":"text"}]},{"type":"paragraph","content":[{"text":"If the file passes validation, the file data will be loaded into K. You will be provided a job id in the response so you can check the current status of the load. ","type":"text"}]},{"type":"codeBlock","content":[{"text":"GET api/jobexecutions/","type":"text"}]},{"type":"paragraph","content":[{"text":"Which will return either the status is","type":"text"}]},{"type":"paragraph","content":[{"text":"SUBMITTED","type":"text"},{"type":"hardBreak"},{"text":"RUNNING","type":"text"},{"type":"hardBreak"},{"text":"FAILED","type":"text"},{"type":"hardBreak"},{"text":"KILLED","type":"text"},{"type":"hardBreak"},{"text":"COMPLETE","type":"text"}]},{"type":"paragraph","content":[{"text":"In the event of FAILED, the response will include additional details about the error. ","type":"text"}]},{"type":"codeBlock","content":[{"text":"{\n \"created_at\": \"2022-02-15T03:23:29.224114+00:00\",\n \"data_processed\": true,\n \"error\": \"1: Object does not exist\\n2001: Invalid collection UUID <> provided\"\n \"id\": 2,\n \"job_reference\": \"61e1b879-5a28-404a-8350-6ffec5dc6097\",\n \"job_status\": \"FAILED\",\n \"platform_job_id\": 106,\n \"source_id\": 1000,\n \"updated_at\": \"2022-02-15T03:23:30.852532+00:00\"\n}","type":"text"}]},{"type":"paragraph"},{"type":"heading","attrs":{"level":3},"content":[{"text":"Considerations","type":"text"}]},{"type":"paragraph","content":[{"text":"There is no guarantee that the job will load all data provided in the payload. ","type":"text"}]},{"type":"paragraph","content":[{"text":"You will need to ensure your updates are checked and ensure you review any errors that are generated. Any performance issues should be reviewed - e.g. the job has been running for over 2 hours. Reach out to the KADA team for any support you may need. ","type":"text"}]},{"type":"paragraph"},{"type":"paragraph"}],"version":1}