Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

...

Reporting provides a set of services to create, process, and retrieve either CSV extracts or XML extracts from CLAIMS Direct. Reports are available for six months after they are created. Please download any reports older than six months that you wish to keep. Reports can be downloaded through the API using https://cdws21.ificlaims.com/reports/<report-id>/<report-name>.

In brief, you can use the interface to do the following:

...

Note that whereas CSV reporting does allow you to select the columns or fields that you want included in the report, the XML output assumes you want the complete XML record. Also note that whereas while the XML output does allow allows for batching of the output into multiple files in order to keep file sizes manageable, the CSV report assumes you want everything in one file.

...

Method(s)GET | POST

Path

/report/create

Parameter
ValuesDescription

@nameString: ex. test-report-01Report name. Special Unix/Linux characters may not be used in report names. Valid characters include alphas, numerics, dashes, and underscores.

@typeString: ex. csvReport type, one of 'csv' or 'xml' (default=xml)

@sourceString: ex. searchReport source, one of 'search', 'list' or 'table' (default=list)

@criteriaString: ex. pnctry:us AND solar

Report criteria. Depending on @source, this will be either a valid

SOLR

Solr search query, a space, comma or new-line-separated list of ucids or an existing schema-qualified DWH table name containing the required column ucid.

Warning
Warning
Icon

For long ucid lists and complicated queries, the POST method should be used.



@solrparamsunused, set internally



@solrurlunused, set internally

The following options pertain to @type = csv

@csv.colsString: ex. c1,c2

Comma-separated list of columns to include. Columns will be output in order given.
Currently available columns:

Info
titleNote

Columns containing multiple values will be separated by the '|' character, e.g. US | EP | WO


ColumnDescription
document-ucidDocument identifier (ucid)
document-countryCountry of publication
document-numberPatent/publication number
document-kindPublication kind code
document-dateDate of publication (YYYYMMDD)
document-yearYear of publication (YYYY)
application-ucidApplication filing identifier (ucid)
application-countryFiling country
application-numberFiling number
application-kindFiling kind code
application-dateDate of filing (YYYYMMDD)
application-yearYear of filing (YYYY)
priority-numberPriority numbers (ucids)
priority-countryPriority countries
priority-datePriority filing dates (YYYYMMDD)
priority-yearPriority filing years (YYYY)
us-class-primaryPrimary US classification
us-classAll US classifications
cpcCPC
cpc-first-inventiveFirst inventive CPC
ipcrIPCR
ipcIPC
eclaECLA
f-termsF-terms
patent-citationsPatent citations
non-patent-citationsNon-patent citations
forward-citationsForward citations
related-applicationsRelated applications
assignee-applicantAssignees/applicants
epo-assignee-applicantDocDB DOCDB standardized assignees/applicants
inventorInventors
agentAgents
correspondentCorrespondent
examinerExaminer
pct-application-numberPCT filing number (ucid)
designated-statesEP and PCT designated states
abstractEnglish abstract or, if no English abstract exists, the abstract in the language of publication
first-claimFirst claim
english-claimsClaims in English
original-claimsClaims in language of publication
espacenet-linkURL to espacenet
simple-familyList of ucids sharing the same family ID, as assigned by DocDBDOCDB
inpadoc-familyExtended family
legal-statusLegal status
titleEnglish language title or, if not present, title in publication language
ifi-expirationIFI anticipated patent expiration date
ifi-statusIFI patent status
ifi-publication-typeIFI publication type
ifi-adj-expirationIFI adjusted patent expiration date
ifi-assigneeIFI assignee
ifi-assignee-originalOriginal, as published, assignee
ifi-assignee-currentCurrent IFI assignee
ifi-assignee-probableProbable IFI assignee
family-idDocDBDOCDB-assigned simple family integer identifier
load-idmodified-load-id
date-producedDate on which CLAIMS Direct XML was produced



@csv.headerBool: ex. 1[ 0 | 1 ] Include column headers

@csv.nonlBool: ex. 1[ 0 | 1 ] Replace new lines (nl) with spaces

@csv.maxcolsizeInteger: ex. 32The maximum number of bytes allowed per column (overflow will be truncated). This value is assumed to be Kilobytes.: ex. 32The maximum number of bytes allowed per column (overflow will be truncated). This value is assumed to be Kilobytes.

@csv.datefmt

String. Available Options:

yyyy-mm-dd
dd/mm/yyyy
mm/dd/yyyy
yyyymmdd

Ex. csv.datefmt=mm/dd/yyyy

(v3.9.1) The format of date output for the CSV columns: Publication Date, Application Date, Priority Date, Date Produced, IFI Expiration and IFI Adjusted Expiration dates.


Example:

Code Block
languagetext
wget -O- -q \
  --header 'x-user:x' \
  --header 'x-password:y' \
'httphttps://cdws21.ificlaims.com/report/create?name=a-csv-report&type=csv&source=list&criteria=US-20140255094-A1,ES-2478140-A8,ES-2486245-T3'  


Response JSON

Code Block
languagetext
{
   "status" : "success"
   "time" : "0.015465",
   "report" : {
      "id" : "63cfdeb1-0162-444f-9ffa-a1ddd18de7d1"
   },
}



...


Example:

Code Block
languagetext
wget -O- -q \
  --header 'x-user:x' \
  --header 'x-password:y' \
'httphttps://cdws21.ificlaims.com/report/queue?id=99a479b9-4a73-4f27-b8b1-44b052844e23'


Response JSON

Code Block
languagetext
{
   "status" : "success",
   "time" : "0.064897"
   "queue" : {
      "id" : 257
   },
}


...


Example:

Code Block
languagetext
wget -O- \
  --header 'x-user:x' \
  --header 'x-password:y' \
'httphttps://cdws21.ificlaims.com/report/status?id=99a479b9-4a73-4f27-b8b1-44b052844e23'


Response JSON

Code Block
languagetext
{
   "time" : " 0.041137",
   "status" : "success",
   "report" : {
      "percent_complete" : "0.000",
      "completed_status" : null,
      "completed_stamp" : null,
      "ndocs" : 0,
      "completed_error" : null,
      "ndocs_processed" : 0,
      "running_status" : "queued",
      "entered_stamp" : "2014-09-28 14:52:57",
      "completed_url" : null
   },
}


...

Code Block
languagetext
wget -O- \
  --header 'x-user:x' \
  --header 'x-password:y' \
'httphttps://cdws21.ificlaims.com/report/list?limit=1'

...

Code Block
languagetext
{
   "time" : "0.010817",
   "status" : "success",
   "reports" : [
      {
         "batchprefix" : "batch",
         "source" : "list",
         "name" : "a-csv-report",
         "solrurl" : "httphttps://10.234.1.44:6000/alexandria-v2.1/alexandria",
         "batchsize" : 200,
         "completed_status" : null,
         "package_compression" : "zip",
         "package_sfx" : "csv",
         "completed_stamp" : null,
         "completed_error" : null,
         "running_status" : "queued",
         "solrparams" : null,
         "type" : "csv",
         "entered_stamp" : "2014-09-28 14:52:57.15773",
         "completed_url" : null,
         "id" : "63cfdeb1-0162-444f-9ffa-a1ddd18de7d1",
         "criteria" : "US-20140255094-A1,ES-2478140-A8,ES-2486245-T3",
         "package_type" : "single",
         "report_id" : 276,
         "csvopts" : "csv.nonl=1&csv.cols=__all__&csv.maxcolsize=32768&csv.header=1",
         "nthreads" : 4,
         "user_id" : 4,
         "process_id" : 257,
         "ndocs" : 0,
         "ndocs_processed" : 0
      }
  ]
}

...

Code Block
languagetext
{
   "time" : " 0.012368",
   "status" : "success",
   "report" : {
      "name" : "a-csv-report",
      "batchprefix" : "batch",
      "source" : "list",
      "completed_status" : null,
      "completed_stamp" : null,
      "package_sfx" : "csv",
      "package_compression" : "zip",
      "completed_error" : null,
      "solrurl" : "httphttps://10.234.1.44:6000/alexandria-v2.1/alexandria",
      "batchsize" : 200,
      "completed_url" : null,
      "criteria" : "US-20140255094-A1,ES-2478140-A8,ES-2486245-T3",
      "tracker_id" : "63cfdeb1-0162-444f-9ffa-a1ddd18de7d1",
      "report_id" : 276,
      "package_type" : "single",
      "solrparams" : null,
      "running_status" : "queued",
      "type" : "csv",
      "entered_stamp" : "2014-09-28 14:52:57.15773",
      "nthreads" : 4,
      "user_id" : 4,
      "process_id" : 257,
      "ndocs" : 0,
      "ndocs_processed" : 0,
      "csvopts" : "csv.nonl=1&csv.cols=__all__&csv.maxcolsize=32768&csv.header=1"
   },
}

...

MethodGET

Path

/report/columns


Response JSON

Code Block
languagetext
{
   "time" : " 0.008741",
   "status" : "success",
   "columns" : [
      "document-ucid",
      "document-country",
      "document-number",
      "document-kind",
      "document-date",
      "document-year",
      "application-ucid",
      "application-country",
      "application-number",
      "application-kind",
      "application-date",
      "application-year",
      "priority-number",
      "priority-country",
      "priority-date",
      "priority-year",
      "us-class-primary",
      "us-class",
      "cpc",
      "cpc-first-inventive",
      "ipcr",
      "ipc",
      "ecla",
      "f-terms",
      "patent-citations",
      "forward-citations",
      "non-patent-citations",
      "related-applications",
      "assignee-applicant",
      "epo-assignee-applicant",
      "inventor",
      "agent",
      "correspondent",
      "examiner",
      "pct-application-number",
      "designated-states",
      "abstract",
      "first-claim",
      "english-claims",
      "original-claims",
      "espacenet-link",
      "simple-family",
      "inpadoc-family",
      "legal-status",
      "title",
      "ifi-expiration",
      "ifi-status",
      "ifi-publication-type",
      "ifi-adj-expiration",
      "ifi-assignee",
      "ifi-assignee-original",
      "ifi-assignee-current",
      "ifi-assignee-probable",
      "family-id",
      "load-id",
      "date-produced"
   ]
}

...