Yes, exact fields will depend on what was sent by the gateway, what log level was used etc…
Original Message:
Sent: Thu April 04, 2024 03:48 AM
From: Guo Jun Qiao
Subject: Analytics Data Export and Import
Hi Chris,
Just a confirm the data looks like below right?
{
"@version": "1",
"resource_id": "::POST:/nemsdsvc",
"immediate_client_ip": "101.111.153.13",
"log_policy": "payload",
"opentracing_info": [],
"api_id": "ef7d21d8-190d-48f3-a3a8-54b20ef48461",
"query_string": "",
"client_id": "",
"@timestamp": "2024-04-04T07:32:18.655974166Z",
"gateway_ip": "101.111.153.45",
"datetime": "2024-04-04T07:32:18.451Z",
"client_ip": "101.111.153.13",
"api_version": "1.0.0",
"developer_org_title": "",
"developer_org_id": "",
"org_name": "dev",
"response_http_headers": [
{
"Expires": "-1"
},
{
"Cache-control": "no-store"
},
{
"Set-Cookie": "[\"KEYCLOAK_LOCALE=; Version=1; Comment=Expiring cookie; Expires=Thu, 01-Jan-1970 00:00:10 GMT; Max-Age=0; Path=/auth/realms/xxxdev/; HttpOnly\",\"KC_RESTART=; Version=1; Expires=Thu, 01-Jan-1970 00:00:10 GMT; Max-Age=0; Path=/auth/realms/xxxdev/; HttpOnly\"]"
},
{
"X-XSS-Protection": "1; mode=block"
},
{
"Pragma": "no-cache"
},
{
"X-Frame-Options": "ALLOWALL"
},
{
"Referrer-Policy": "no-referrer"
},
{
"Date": "Thu, 04 Apr 2024 07:32:18 GMT"
},
{
"Strict-Transport-Security": "max-age=31536000;"
},
{
"X-Content-Type-Options": "nosniff"
},
{
"Content-Type": "application/xml"
},
{
"X-Global-Transaction-ID": "3da159a0660e57820000fcc0"
}
],
"request_body": "<soapenv:Envelope xmlns:soapenv=\"http://schemas.xmlsoap.org/soap/envelope/\">\r\n <soapenv:Header/>\r\n <soapenv:Body/>\r\n</soapenv:Envelope>",
"domain_name": "dev231-gateway",
"latency_info": [
{
"started": 0,
"task": "Start"
},
------------------------------
Guo Jun Qiao
Original Message:
Sent: Thu April 04, 2024 01:43 AM
From: Chris Dudley
Subject: Analytics Data Export and Import
No need, the data is the same you see in the UI when you click on an API event.
Try it yourself :-)
------------------------------
Chris Dudley
Original Message:
Sent: Wed April 03, 2024 09:21 PM
From: Guo Jun Qiao
Subject: Analytics Data Export and Import
Hi Chris,
I read below blog post from Pablo. Is it possible for Pablo to share a exported sample data. Just curious on the format of the data.
https://community.ibm.com/community/user/integration/blogs/pablo-lopez-rodriguez/2022/12/05/using-analytics-scroll-operation
------------------------------
Guo Jun Qiao
Original Message:
Sent: Wed April 03, 2024 09:11 PM
From: Guo Jun Qiao
Subject: Analytics Data Export and Import
Thank you Chris :)
------------------------------
Guo Jun Qiao
Original Message:
Sent: Tue April 02, 2024 06:38 AM
From: Chris Dudley
Subject: Analytics Data Export and Import
Hiya
There is no import to analytics.
You can get the raw api events via the api (see the blog post from Pablo on this site about the scroll api). But there is no way to import them again elsewhere.
I think you'll need to make do as best you can until 10.0.8 is released in a few months and then make use of the long term summary data to keep event history for longer.
In the meantime you can offload to a remote server (eg splunk. Elk etc) if you need to.
Cheers
Chris
------------------------------
Chris Dudley
Original Message:
Sent: Mon April 01, 2024 12:13 AM
From: Guo Jun Qiao
Subject: Analytics Data Export and Import
Hi Chris,
Just would like to check if there is any way to export and import analytics data from Management subsystem or Developer Portal? If it is not doable through Analytics Dashboard in Management or Developer portal, can we do it via API?
Currently the analytics data only can retain for maximum three months in APIC 10.0.5. So we are thinking if can export the analytics from APIC. Later if required, we can import it into another low environment for visualization.
------------------------------
Guo Jun Qiao
------------------------------