{"id":17919,"date":"2024-08-19T19:02:50","date_gmt":"2024-08-19T23:02:50","guid":{"rendered":"https:\/\/www.iri.com\/blog\/?p=17919"},"modified":"2024-08-22T10:18:50","modified_gmt":"2024-08-22T14:18:50","slug":"etl-part-2","status":"publish","type":"post","link":"https:\/\/beta.iri.com\/blog\/data-transformation2\/etl-part-2\/","title":{"rendered":"Joining Flat-File & RDB Data: Textual ETL (Part 2)"},"content":{"rendered":"
Introduction<\/b><\/h5>\n

This article demonstrates the <\/span>Voracity<\/span><\/a> user’s ability to join values in a flat-file file to those in an RDB (Relational Database) table to provide meaningful information. It is the continuation of <\/span>this article<\/span><\/a> on preparing unstructured data for integration with structured data and the standard technologies (like an Oracle database or JSON file) that support them.\u00a0<\/span><\/p>\n

As shown in that first article, the flat file was created by <\/span>SortCL<\/span><\/a> data transposition scripts acting on a delimited <\/span>IRI DarkShield<\/span><\/a> log file. That DarkShield log (optionally) held PII values along with file-specific metadata from a search through multiple unstructured data sources. The SortCL jobs pivoted the log file into a new row-column structure organized by data class for easier use.\u00a0<\/span><\/p>\n

Neither the original log file nor the pivoted flat file with the PII provides discernibly meaningful information about any particular individual beyond the email addresses or names in them. This is because all DarkShield searches log PII found in unstructured sources chronologically. And by definition, there is no structure to lend associations to the PII elements found anyway.<\/span><\/p>\n

Thus for those interested in learning more about, or making use of, unstructured data like the PII in this case, an association to this data must be (re)established. To do that in this case, we pick one of the PII elements from the transposed log file \u2013 in the example below, the email address \u2013 and <\/span>join it<\/span><\/a> to a structured source (e.g., a database table) that may hold the same email address <\/span>along with <\/span><\/i>actually identifying, or otherwise meaningful, information about that same person.<\/span><\/p>\n

Why Does this Matter?<\/b><\/h5>\n

What is a use case for this kind of capability? Consider a non-descript email address that DarkShield found in a PDF complaint describing criminal activity, or an account number found in a chat log or call recording. How about clinical notes naming a patient and their symptoms with no link to care or trial resources? Unfortunately, such data is often just archived and untapped.\u00a0<\/span><\/p>\n

Instead, consider what can happen when those values are extracted and combined with traditional sources of data in sequential files, semi-structured EDI documents, or relational databases? In the cases above, a perpetrator could be identified, an account holder protected, and a patient treatment record made more holistic.\u00a0<\/span><\/p>\n

Heretofore, addressing this data combination challenge has been largely manual, and most such efforts would prove unfruitful. The example in this article therefore serves two purposes:<\/span><\/p>\n

1. To complete the textual ETL example in the first article by showing how the disassociated PII (email addresses) discovered by DarkShield in Voracity can be joined to create useful information about any emails for which there is a match in the join; and,\u00a0<\/span><\/p>\n

2. To demonstrate how to create and run a join operation in the IRI CoSort product or Voracity ETL platform using the SortCL job script and program common to both.<\/p>\n

Textual Data Integration Example<\/b><\/h5>\n

This sample use case will use real data in a structured database to identify the owner of matching email addresses discovered in a PII search job that DarkShield performed across unstructured data sources. In the <\/span>first article<\/span><\/a>, we transposed the DarkShield log file into a disassociated but formatted report of discovered PII:<\/span><\/p>\n

\"\"<\/p>\n

Looking across these restructured rows, there is no relationship between any of the elements. But in the relational database fact table below, there are (note matches of names with emails):<\/span><\/p>\n

\"\"<\/p>\n

To identify the real owner of the DarkShield-discovered email address using the real database table above, perform a join on the Email field between the CSV file and the table. To build that job, run a fit-for-purpose <\/span>Join job<\/span><\/a> wizard from the CoSort menu, or an <\/span>ETL Join<\/span><\/a> in Voracity, in the <\/span>IRI Workbench<\/span><\/a> GUI.<\/span><\/p>\n

The join job wizard in Workbench starts with specifying the name and location of the job script:<\/span><\/p>\n

\"\"<\/p>\n

In the Data Source screen that comes next, specify the CSV file (transposed after a DarkShield search per the prior article), and the existing database fact table. In this case, that table, called ACCOUNT, is in an Oracle schema called SCOTT.<\/span><\/p>\n

\"\"<\/p>\n

From the CSV file, only pull in the EMAIL field to join and then map to output. From my table, specify both the EMAIL field for the join, and all other columns of interest associated with any email addresses that may match some in my file. More specifically, map out the values in the SSN, FIRST_NAME, LAST_NAME, DOB, NATIONALITY, OCCUPATION, PHONE, and ADDRESS columns.<\/span><\/p>\n

Also required with each source is its \/FIELD metadata layout in SortCL Data Definition File (DDF) <\/span>syntax<\/span><\/a>. We can either add them from an existing DDF file, or auto-generate and incorporate the \/FIELD definitions through the \u2018<\/span>Discover Metadata \u2026<\/span><\/a>\u2019 option.<\/span><\/p>\n

Next is choosing and defining the join key. In this case the join key is the EMAIL field. The statement syntax will need to reflect an inner join (match) for the EMAIL field in both the file and the table:<\/span><\/p>\n

\/JOIN<\/b> NOT_SORTED<\/b> DarkShieldSearchLogTransposed <\/span>NOT_SORTED<\/b> ORACLE_SCOTT_ACCOUNT <\/span>WHERE<\/b> DARKSHIELDSEARCHLOGTRANSPOSED.EMAIL == ORACLE_SCOTT_ACCOUNT.EMAIL<\/span><\/pre>\n
This function can be constructed graphically on the next page of the wizard by selecting EMAIL on both sides of the join:<\/span><\/p>\n
\"\"<\/p>\n
The next and final page of the wizard is where the target file format and field layouts are defined and, if desired, further formatting and transformations. In this case, the joined rows will be kept in a Tab-Separated Values (TSV) file with no further functions performed on the output values, such as aggregation, masking, or data type conversion.<\/span><\/p>\n
\"\"<\/p>\n
Once we finish the wizard, a job script like this is built automatically from what was specified:<\/span><\/p>\n
\"\"<\/p>\n
From the job script above, the transform mapping (ETL) diagram shown below is produced where the two sources, the email values from the file are matched to email values in the table. The table contains the other attributes of interest that will be written to output.\u00a0<\/span><\/p>\n
The output fields are then written in tab-delimited format. The CSV process type defined in the output phase of the job script will generate a header record in the output file.<\/span><\/p>\n
When the join is run, this output report is produced that reveals the identity of the people in the table whose email addresses matched those which DarkShield <\/span>had found<\/span><\/a> in its search through multiple unstructured data sources:<\/span><\/p>\n
\"\"<\/p>\n
\"\"<\/p>\n
If you have any questions or are interested in ETL, textual or otherwise,\u00a0<\/span>please get in touch with\u00a0voracity@iri.com<\/a><\/span>.<\/span><\/p>\n","protected":false},"excerpt":{"rendered":"
Introduction This article demonstrates the Voracity user’s ability to join values in a flat-file file to those in an RDB (Relational Database) table to provide meaningful information. It is the continuation of this article on preparing unstructured data for integration with structured data and the standard technologies (like an Oracle database or JSON file) that<\/p>\n
Read More<\/a><\/div>\n","protected":false},"author":53,"featured_media":17939,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_acf_changed":false,"_exactmetrics_skip_tracking":false,"_exactmetrics_sitenote_active":false,"_exactmetrics_sitenote_note":"","_exactmetrics_sitenote_category":0,"footnotes":""},"categories":[],"tags":[],"class_list":["post-17919","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry"],"acf":[],"yoast_head":"\nJoining Flat-File & RDB Data: Textual ETL (Part 2) - IRI<\/title>\n<meta name=\"description\" content=\"Learn to join data in a flat-file file (from a DarkShield unstructured PII search log) with an RDB table to create insight from textual ETL.\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/beta.iri.com\/blog\/data-transformation2\/etl-part-2\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Joining Flat-File & RDB Data: Textual ETL (Part 2) - IRI\" \/>\n<meta property=\"og:description\" content=\"Learn to join data in a flat-file file (from a DarkShield unstructured PII search log) with an RDB table to create insight from textual ETL.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/beta.iri.com\/blog\/data-transformation2\/etl-part-2\/\" \/>\n<meta property=\"og:site_name\" content=\"IRI\" \/>\n<meta property=\"article:published_time\" content=\"2024-08-19T23:02:50+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2024-08-22T14:18:50+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/beta.iri.com\/blog\/wp-content\/uploads\/2024\/08\/Featured-image-ETL-part-2.png\" \/>\n\t<meta property=\"og:image:width\" content=\"1110\" \/>\n\t<meta property=\"og:image:height\" content=\"532\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/png\" \/>\n<meta name=\"author\" content=\"Chaitali Mitra\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"Chaitali Mitra\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"7 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\/\/beta.iri.com\/blog\/data-transformation2\/etl-part-2\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/beta.iri.com\/blog\/data-transformation2\/etl-part-2\/\"},\"author\":{\"name\":\"Chaitali Mitra\",\"@id\":\"https:\/\/beta.iri.com\/blog\/#\/schema\/person\/9bae14a309616863b027c2d56f532caf\"},\"headline\":\"Joining Flat-File & RDB Data: Textual ETL (Part 2)\",\"datePublished\":\"2024-08-19T23:02:50+00:00\",\"dateModified\":\"2024-08-22T14:18:50+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/beta.iri.com\/blog\/data-transformation2\/etl-part-2\/\"},\"wordCount\":1059,\"commentCount\":0,\"publisher\":{\"@id\":\"https:\/\/beta.iri.com\/blog\/#organization\"},\"image\":{\"@id\":\"https:\/\/beta.iri.com\/blog\/data-transformation2\/etl-part-2\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/beta.iri.com\/blog\/wp-content\/uploads\/2024\/08\/Featured-image-ETL-part-2.png\",\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\/\/beta.iri.com\/blog\/data-transformation2\/etl-part-2\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/beta.iri.com\/blog\/data-transformation2\/etl-part-2\/\",\"url\":\"https:\/\/beta.iri.com\/blog\/data-transformation2\/etl-part-2\/\",\"name\":\"Joining Flat-File & RDB Data: Textual ETL (Part 2) - IRI\",\"isPartOf\":{\"@id\":\"https:\/\/beta.iri.com\/blog\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/beta.iri.com\/blog\/data-transformation2\/etl-part-2\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/beta.iri.com\/blog\/data-transformation2\/etl-part-2\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/beta.iri.com\/blog\/wp-content\/uploads\/2024\/08\/Featured-image-ETL-part-2.png\",\"datePublished\":\"2024-08-19T23:02:50+00:00\",\"dateModified\":\"2024-08-22T14:18:50+00:00\",\"description\":\"Learn to join data in a flat-file file (from a DarkShield unstructured PII search log) with an RDB table to create insight from textual ETL.\",\"breadcrumb\":{\"@id\":\"https:\/\/beta.iri.com\/blog\/data-transformation2\/etl-part-2\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/beta.iri.com\/blog\/data-transformation2\/etl-part-2\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/beta.iri.com\/blog\/data-transformation2\/etl-part-2\/#primaryimage\",\"url\":\"https:\/\/beta.iri.com\/blog\/wp-content\/uploads\/2024\/08\/Featured-image-ETL-part-2.png\",\"contentUrl\":\"https:\/\/beta.iri.com\/blog\/wp-content\/uploads\/2024\/08\/Featured-image-ETL-part-2.png\",\"width\":1110,\"height\":532},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/beta.iri.com\/blog\/data-transformation2\/etl-part-2\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/beta.iri.com\/blog\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Joining Flat-File & RDB Data: Textual ETL (Part 2)\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/beta.iri.com\/blog\/#website\",\"url\":\"https:\/\/beta.iri.com\/blog\/\",\"name\":\"IRI\",\"description\":\"Total Data Management Blog\",\"publisher\":{\"@id\":\"https:\/\/beta.iri.com\/blog\/#organization\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/beta.iri.com\/blog\/?s={search_term_string}\"},\"query-input\":\"required name=search_term_string\"}],\"inLanguage\":\"en-US\"},{\"@type\":\"Organization\",\"@id\":\"https:\/\/beta.iri.com\/blog\/#organization\",\"name\":\"IRI\",\"url\":\"https:\/\/beta.iri.com\/blog\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/beta.iri.com\/blog\/#\/schema\/logo\/image\/\",\"url\":\"https:\/\/beta.iri.com\/blog\/wp-content\/uploads\/2019\/02\/iri-logo-total-data-management-small-1.png\",\"contentUrl\":\"https:\/\/beta.iri.com\/blog\/wp-content\/uploads\/2019\/02\/iri-logo-total-data-management-small-1.png\",\"width\":750,\"height\":206,\"caption\":\"IRI\"},\"image\":{\"@id\":\"https:\/\/beta.iri.com\/blog\/#\/schema\/logo\/image\/\"}},{\"@type\":\"Person\",\"@id\":\"https:\/\/beta.iri.com\/blog\/#\/schema\/person\/9bae14a309616863b027c2d56f532caf\",\"name\":\"Chaitali Mitra\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/beta.iri.com\/blog\/#\/schema\/person\/image\/\",\"url\":\"https:\/\/secure.gravatar.com\/avatar\/95a11f3d0b709c00df3262bab0152f3a?s=96&d=blank&r=g\",\"contentUrl\":\"https:\/\/secure.gravatar.com\/avatar\/95a11f3d0b709c00df3262bab0152f3a?s=96&d=blank&r=g\",\"caption\":\"Chaitali Mitra\"},\"sameAs\":[\"http:\/\/www.iri.com\"],\"url\":\"https:\/\/beta.iri.com\/blog\/author\/chaitalim\/\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Joining Flat-File & RDB Data: Textual ETL (Part 2) - IRI","description":"Learn to join data in a flat-file file (from a DarkShield unstructured PII search log) with an RDB table to create insight from textual ETL.","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/beta.iri.com\/blog\/data-transformation2\/etl-part-2\/","og_locale":"en_US","og_type":"article","og_title":"Joining Flat-File & RDB Data: Textual ETL (Part 2) - IRI","og_description":"Learn to join data in a flat-file file (from a DarkShield unstructured PII search log) with an RDB table to create insight from textual ETL.","og_url":"https:\/\/beta.iri.com\/blog\/data-transformation2\/etl-part-2\/","og_site_name":"IRI","article_published_time":"2024-08-19T23:02:50+00:00","article_modified_time":"2024-08-22T14:18:50+00:00","og_image":[{"width":1110,"height":532,"url":"https:\/\/beta.iri.com\/blog\/wp-content\/uploads\/2024\/08\/Featured-image-ETL-part-2.png","type":"image\/png"}],"author":"Chaitali Mitra","twitter_card":"summary_large_image","twitter_misc":{"Written by":"Chaitali Mitra","Est. reading time":"7 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/beta.iri.com\/blog\/data-transformation2\/etl-part-2\/#article","isPartOf":{"@id":"https:\/\/beta.iri.com\/blog\/data-transformation2\/etl-part-2\/"},"author":{"name":"Chaitali Mitra","@id":"https:\/\/beta.iri.com\/blog\/#\/schema\/person\/9bae14a309616863b027c2d56f532caf"},"headline":"Joining Flat-File & RDB Data: Textual ETL (Part 2)","datePublished":"2024-08-19T23:02:50+00:00","dateModified":"2024-08-22T14:18:50+00:00","mainEntityOfPage":{"@id":"https:\/\/beta.iri.com\/blog\/data-transformation2\/etl-part-2\/"},"wordCount":1059,"commentCount":0,"publisher":{"@id":"https:\/\/beta.iri.com\/blog\/#organization"},"image":{"@id":"https:\/\/beta.iri.com\/blog\/data-transformation2\/etl-part-2\/#primaryimage"},"thumbnailUrl":"https:\/\/beta.iri.com\/blog\/wp-content\/uploads\/2024\/08\/Featured-image-ETL-part-2.png","inLanguage":"en-US","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/beta.iri.com\/blog\/data-transformation2\/etl-part-2\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/beta.iri.com\/blog\/data-transformation2\/etl-part-2\/","url":"https:\/\/beta.iri.com\/blog\/data-transformation2\/etl-part-2\/","name":"Joining Flat-File & RDB Data: Textual ETL (Part 2) - IRI","isPartOf":{"@id":"https:\/\/beta.iri.com\/blog\/#website"},"primaryImageOfPage":{"@id":"https:\/\/beta.iri.com\/blog\/data-transformation2\/etl-part-2\/#primaryimage"},"image":{"@id":"https:\/\/beta.iri.com\/blog\/data-transformation2\/etl-part-2\/#primaryimage"},"thumbnailUrl":"https:\/\/beta.iri.com\/blog\/wp-content\/uploads\/2024\/08\/Featured-image-ETL-part-2.png","datePublished":"2024-08-19T23:02:50+00:00","dateModified":"2024-08-22T14:18:50+00:00","description":"Learn to join data in a flat-file file (from a DarkShield unstructured PII search log) with an RDB table to create insight from textual ETL.","breadcrumb":{"@id":"https:\/\/beta.iri.com\/blog\/data-transformation2\/etl-part-2\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/beta.iri.com\/blog\/data-transformation2\/etl-part-2\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/beta.iri.com\/blog\/data-transformation2\/etl-part-2\/#primaryimage","url":"https:\/\/beta.iri.com\/blog\/wp-content\/uploads\/2024\/08\/Featured-image-ETL-part-2.png","contentUrl":"https:\/\/beta.iri.com\/blog\/wp-content\/uploads\/2024\/08\/Featured-image-ETL-part-2.png","width":1110,"height":532},{"@type":"BreadcrumbList","@id":"https:\/\/beta.iri.com\/blog\/data-transformation2\/etl-part-2\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/beta.iri.com\/blog\/"},{"@type":"ListItem","position":2,"name":"Joining Flat-File & RDB Data: Textual ETL (Part 2)"}]},{"@type":"WebSite","@id":"https:\/\/beta.iri.com\/blog\/#website","url":"https:\/\/beta.iri.com\/blog\/","name":"IRI","description":"Total Data Management Blog","publisher":{"@id":"https:\/\/beta.iri.com\/blog\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/beta.iri.com\/blog\/?s={search_term_string}"},"query-input":"required name=search_term_string"}],"inLanguage":"en-US"},{"@type":"Organization","@id":"https:\/\/beta.iri.com\/blog\/#organization","name":"IRI","url":"https:\/\/beta.iri.com\/blog\/","logo":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/beta.iri.com\/blog\/#\/schema\/logo\/image\/","url":"https:\/\/beta.iri.com\/blog\/wp-content\/uploads\/2019\/02\/iri-logo-total-data-management-small-1.png","contentUrl":"https:\/\/beta.iri.com\/blog\/wp-content\/uploads\/2019\/02\/iri-logo-total-data-management-small-1.png","width":750,"height":206,"caption":"IRI"},"image":{"@id":"https:\/\/beta.iri.com\/blog\/#\/schema\/logo\/image\/"}},{"@type":"Person","@id":"https:\/\/beta.iri.com\/blog\/#\/schema\/person\/9bae14a309616863b027c2d56f532caf","name":"Chaitali Mitra","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/beta.iri.com\/blog\/#\/schema\/person\/image\/","url":"https:\/\/secure.gravatar.com\/avatar\/95a11f3d0b709c00df3262bab0152f3a?s=96&d=blank&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/95a11f3d0b709c00df3262bab0152f3a?s=96&d=blank&r=g","caption":"Chaitali Mitra"},"sameAs":["http:\/\/www.iri.com"],"url":"https:\/\/beta.iri.com\/blog\/author\/chaitalim\/"}]}},"jetpack_featured_media_url":"https:\/\/beta.iri.com\/blog\/wp-content\/uploads\/2024\/08\/Featured-image-ETL-part-2.png","_links":{"self":[{"href":"https:\/\/beta.iri.com\/blog\/wp-json\/wp\/v2\/posts\/17919"}],"collection":[{"href":"https:\/\/beta.iri.com\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/beta.iri.com\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/beta.iri.com\/blog\/wp-json\/wp\/v2\/users\/53"}],"replies":[{"embeddable":true,"href":"https:\/\/beta.iri.com\/blog\/wp-json\/wp\/v2\/comments?post=17919"}],"version-history":[{"count":13,"href":"https:\/\/beta.iri.com\/blog\/wp-json\/wp\/v2\/posts\/17919\/revisions"}],"predecessor-version":[{"id":17950,"href":"https:\/\/beta.iri.com\/blog\/wp-json\/wp\/v2\/posts\/17919\/revisions\/17950"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/beta.iri.com\/blog\/wp-json\/wp\/v2\/media\/17939"}],"wp:attachment":[{"href":"https:\/\/beta.iri.com\/blog\/wp-json\/wp\/v2\/media?parent=17919"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/beta.iri.com\/blog\/wp-json\/wp\/v2\/categories?post=17919"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/beta.iri.com\/blog\/wp-json\/wp\/v2\/tags?post=17919"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}