Export products to CSV
curl --request GET \
--url https://api.dev.impactu.colav.co/affiliation/{affiliation_type}/{affiliation_id}/research/products/csvimport requests
url = "https://api.dev.impactu.colav.co/affiliation/{affiliation_type}/{affiliation_id}/research/products/csv"
response = requests.get(url)
print(response.text)const options = {method: 'GET'};
fetch('https://api.dev.impactu.colav.co/affiliation/{affiliation_type}/{affiliation_id}/research/products/csv', options)
.then(res => res.json())
.then(res => console.log(res))
.catch(err => console.error(err));<?php
$curl = curl_init();
curl_setopt_array($curl, [
CURLOPT_URL => "https://api.dev.impactu.colav.co/affiliation/{affiliation_type}/{affiliation_id}/research/products/csv",
CURLOPT_RETURNTRANSFER => true,
CURLOPT_ENCODING => "",
CURLOPT_MAXREDIRS => 10,
CURLOPT_TIMEOUT => 30,
CURLOPT_HTTP_VERSION => CURL_HTTP_VERSION_1_1,
CURLOPT_CUSTOMREQUEST => "GET",
]);
$response = curl_exec($curl);
$err = curl_error($curl);
curl_close($curl);
if ($err) {
echo "cURL Error #:" . $err;
} else {
echo $response;
}package main
import (
"fmt"
"net/http"
"io"
)
func main() {
url := "https://api.dev.impactu.colav.co/affiliation/{affiliation_type}/{affiliation_id}/research/products/csv"
req, _ := http.NewRequest("GET", url, nil)
res, _ := http.DefaultClient.Do(req)
defer res.Body.Close()
body, _ := io.ReadAll(res.Body)
fmt.Println(string(body))
}HttpResponse<String> response = Unirest.get("https://api.dev.impactu.colav.co/affiliation/{affiliation_type}/{affiliation_id}/research/products/csv")
.asString();require 'uri'
require 'net/http'
url = URI("https://api.dev.impactu.colav.co/affiliation/{affiliation_type}/{affiliation_id}/research/products/csv")
http = Net::HTTP.new(url.host, url.port)
http.use_ssl = true
request = Net::HTTP::Get.new(url)
response = http.request(request)
puts response.read_bodyAffiliation
Export products to CSV
Downloads an affiliation’s research products as CSV, or the data of an indicator when the plot parameter is used.
GET
/
affiliation
/
{affiliation_type}
/
{affiliation_id}
/
research
/
products
/
csv
Export products to CSV
curl --request GET \
--url https://api.dev.impactu.colav.co/affiliation/{affiliation_type}/{affiliation_id}/research/products/csvimport requests
url = "https://api.dev.impactu.colav.co/affiliation/{affiliation_type}/{affiliation_id}/research/products/csv"
response = requests.get(url)
print(response.text)const options = {method: 'GET'};
fetch('https://api.dev.impactu.colav.co/affiliation/{affiliation_type}/{affiliation_id}/research/products/csv', options)
.then(res => res.json())
.then(res => console.log(res))
.catch(err => console.error(err));<?php
$curl = curl_init();
curl_setopt_array($curl, [
CURLOPT_URL => "https://api.dev.impactu.colav.co/affiliation/{affiliation_type}/{affiliation_id}/research/products/csv",
CURLOPT_RETURNTRANSFER => true,
CURLOPT_ENCODING => "",
CURLOPT_MAXREDIRS => 10,
CURLOPT_TIMEOUT => 30,
CURLOPT_HTTP_VERSION => CURL_HTTP_VERSION_1_1,
CURLOPT_CUSTOMREQUEST => "GET",
]);
$response = curl_exec($curl);
$err = curl_error($curl);
curl_close($curl);
if ($err) {
echo "cURL Error #:" . $err;
} else {
echo $response;
}package main
import (
"fmt"
"net/http"
"io"
)
func main() {
url := "https://api.dev.impactu.colav.co/affiliation/{affiliation_type}/{affiliation_id}/research/products/csv"
req, _ := http.NewRequest("GET", url, nil)
res, _ := http.DefaultClient.Do(req)
defer res.Body.Close()
body, _ := io.ReadAll(res.Body)
fmt.Println(string(body))
}HttpResponse<String> response = Unirest.get("https://api.dev.impactu.colav.co/affiliation/{affiliation_type}/{affiliation_id}/research/products/csv")
.asString();require 'uri'
require 'net/http'
url = URI("https://api.dev.impactu.colav.co/affiliation/{affiliation_type}/{affiliation_id}/research/products/csv")
http = Net::HTTP.new(url.host, url.port)
http.use_ssl = true
request = Net::HTTP::Get.new(url)
response = http.request(request)
puts response.read_bodyThis endpoint has two modes:
With
- Product export (without
plot): downloads a CSV with all the affiliation’s products, applying the active filters. - Indicator export (with
plot): downloads a CSV with the data of the given indicator instead of the product list.
Path parameters
string
required
Affiliation type:
institution, faculty, department or group.string
required
Affiliation identifier.
Query parameters
string
Name of the indicator to export. With this parameter the indicator’s CSV is
downloaded instead of the product list. See the indicator
catalogue.
Filters
The same filters as Search products. They also apply whenplot is used.
string
Year range: minimum and maximum separated by a comma. Example:
2020,2026.string
Product types. Example:
impactu_Artículo de revista.string
Open access status. Example:
diamond,gold.string
OpenAlex topics (URL). Example:
https://openalex.org/T14483.string
Co-authors’ countries, by code. Example:
CO.string
Number of authors:
5 (exactly), 5- (5 or more), -5 (up to 5) or 5-8
(range).string
Author classification. Example:
Investigador Junior.string
Group classification. Example:
A1,A.string
Co-authors’ institution type (ROR). Example:
education,company.Response
Attached CSV file (Content-Type: text/csv; charset=utf-8).
Without plot — file name affiliations.csv, with the following columns:
| Column | Description |
|---|---|
id | Product identifier |
title | Main title |
language | Language |
authors | Authors separated by | |
open_access_status | Open access status |
bibtex | BibTeX entry on one line |
openalex_citations_count | Citations according to OpenAlex |
scholar_citations_count | Citations according to Scholar |
subjects | Subject areas separated by | |
primary_topic | Primary topic: Topic, Subfield, Field and Domain separated by | |
year_published | Publication year |
doi | DOI |
publisher | Publisher |
openalex_types | OpenAlex types separated by | |
scienti_types | Scienti types separated by | |
impactu_types | ImpactU types separated by | |
source_name | Name of the source (journal) |
source_apc | APC information of the source |
source_urls | URLs of the source |
institutions | Authors’ institutions separated by | |
faculties | Authors’ faculties separated by | |
departments | Authors’ departments separated by | |
groups | Research groups separated by | |
countries | Authors’ countries separated by | |
groups_ranking | Group classifications with their date, separated by | |
ranking | Product classification |
issue | Journal issue |
pages | Number of pages |
start_page | Start page |
end_page | End page |
volume | Volume |
scienti_id | Scienti identifier |
minciencias_id | Minciencias identifier |
plot — file name <indicator_name>.csv. Each indicator has its own columns; see the indicator catalogue.