How to get Export output in json format?

Hi all,

I am running a download API in logic app to get a list of my exports, i am able to get the result, but its in octet-stream format while i want the data to be in JSON format so that i can create a blob file with it.

Any ideas how i can achieve this, also the Apiary links says that my result will be in JSON format but its giving me an octet-stream, should i be doing something differently or any other thing i need add in the header that's not there?

Thanks,

Vikash

Accepted answers

All comments

pyrypeura

Hi,

What is value of your content-type header in your https call? How does the response with octet-stream looking like?

Vikas7895

The header for my request is Application-json, the output values looks like this,

{  "$content-type": "application/octet-stream",  "$content": "VmVyc2lvbixOYXRpb25hbCBQa2dfTGluZV9QbGFudF9MMyxQbGFudCxMaW5lLFBhY2thZ2UsRGVzY3JpcHRpb24sVm9sdW1lLERpcmVjdF9MYWJvcl9Db3N0LERpcmVjdF9MYWJvcl9Db3N0X1Blcl9DYXNlLEluZGlyZWN0X0xhYm9yX0Nvc3QsSW5kaXJlY3RfTGFib3JfQ29zdF9QZXJfQ2FzZSxUb3RhbCBEZXByZWNpYXRpb24gQ29zdCxUb3RhbCBEZXByZWNpYXRpb24gQ29zdCBQZXIgQ2FzZSxUb3RhbCBNYXRlcmlhbCBXYXN0ZSBDb3N0LFRvdGFsIE1hdGVyaWFsIFdhc3RlIENvc3QgUGVyIENhc2UsVG90YWwgTUlzYyBPSCBDb3N0LFRvdGFsIE1pc2MgT0ggQ29zdCBQZXIgQ2FzZSxUb3RhbCBPcGVyYXRpbmcgRXhwZW5zZSBDb3N0LFRvdGFsIE9wZXJhdGsMjBaIFBFVCBYMTIgVlAsLDAsMCwwLDAsMCwwLDAsMCwwLDAsMCwwLDAsMCwwLDAsMCwwLDAsMA0KRnkyMyBCdWRnZXQgUkUgVmVyc2lvbiAyLDA1MjlfTGluZSA4XzI4WiBQRVQgWDE1IFBBLCIwNTI5X0FNQ0FOIEJldmVyYWdlcywgSW5jLiIsTGluZSA4LDI4WiBQRVQgWDE1IFBBLCwwLDAsMCwwLDAsMCwwLDAsMCwwLDAsMCwwLDAsMCwwLDAsMCwwLDANCg=="}

Quick Links

Can you help?

Unanswered questions

UX Filter
Hi ALL, I have a module where a line item (Assignments column) is formatted by a large ‘Projects’ list. Each record is assigned to a Project and this module is published to a UX page. When users apply a filter on the Assignments column, the filter dropdown displays the entire Projects list (since the column is…
Dimensionality Issue
Hi ALL, In my model, I have Need stored at a 'D3' RS Group level. I need to use this Need in another module at the G5 Location level. I currently have a mapping module where each G5 Location maps to a D3 RS Group. This Module uses D2 Role as dimension. but the line item I've to find the RS Group (Find D3 RS Group = 'FIND…
Formula to return Connection details...
I couldn't find any formula to do this, but I want a way to put on the page/grid the connection details. This is so I know what connection I'm in rather than going into Connections details to see it. Is there an XL3 formula to return this value?