Export Example

  • task: Export an instance relation/LineRelation/55ba3e55a6165413b9d1a18d as a formatted .xlsx spreadsheet file called: 55ba3e55a6165413b9d1a18d.xlsx

  • user: provider administrator

  • hierarchy: 55b9daeca6165413b9d166de

$ curl -v
       -H 'Authorization: Basic YWRtaW5AcHJvdjEuY29tOnBhc3N3b3Jk'
       -o 55ba3e55a6165413b9d1a18d.xlsx
       'http://localhost/api/relation/LineRelation/55ba3e55a6165413b9d1a18d/export/
        ?hierarchy=55b9daeca6165413b9d166de
        &export_format=xlsx
        &template_name=line-cft
        &policy_name=LineMenuFDPProv
        &schema=true
        &schema_rules=true'
+ About to connect() to localhost port 80 (#0)
+ Trying 127.0.0.1...   % Total    % Received % Xferd  Average Speed   Time    Time     Time  Current
                               Dload  Upload   Total   Spent    Left  Speed
0     0    0     0    0     0      0      0 --:--:-- --:--:-- --:--:--     0connected
> GET /api/relation/LineRelation/55ba3e55a6165413b9d1a18d/export/
      ?hierarchy=55b9daeca6165413b9d166de
      &export_format=xlsx
      &template_name=line-cft
      &policy_name=LineMenuFDPProv
      &schema=true
      &schema_rules=true HTTP/1.1
> Authorization: Basic YWRtaW5AcHJvdjEuY29tOnBhc3N3b3Jk
> User-Agent: curl/7.22.0 (x86_64-pc-linux-gnu)
              libcurl/7.22.0
              OpenSSL/1.0.1
              zlib/1.2.3.4
              libidn/1.23
              librtmp/2.3
> Host: localhost
> Accept: */*
>
  0     0    0     0    0     0      0      0 --:--:--  0:00:02 --:--:--     0
< HTTP/1.1 200 OK
< Server: nginx/1.1.19
< Date: Thu, 30 Jul 2015 15:45:05 GMT
< Content-Type:
   application/vnd.openxmlformats-officedocument.spreadsheetml.sheet
< Transfer-Encoding: chunked
< Connection: keep-alive
< X-CSRFToken: tey9Z6fdlDtwEMYczJ2UmSleIolfG4ys
< Content-Disposition: attachment;
    filename=relation_LineRelation_exportedsheet_formatted_2015-07-30_17-45-03.xlsx
< Content-Language: en-us
< Vary: Accept, Cookie, Accept-Language, X-CSRFToken
< Allow: GET, HEAD, OPTIONS
< Set-Cookie: fileDownloadToken=downloaded; Path=/
< Set-Cookie: csrftoken=tey9Z6fdlDtwEMYczJ2UmSleIolfG4ys;
   SameSite=Lax;
   httponly;
   Path=/
< Set-Cookie: sessionid=aioz1ykt36ht47fzthjpljektbg1z1yr;
   SameSite=Lax;
   httponly;
   Path=/
<
{ [data not shown]
100  9906    0  9906    0     0   3744      0 --:--:--  0:00:02 --:--:--  3745
+ Connection #0 to host localhost left intact
+ Closing connection #0

previous

Bulk Load Example

next

Example Transaction