topic REST API documentation for transfer endpoint for import/export in Developers

REST API documentation for transfer endpoint for import/export

aedwards9 — Thu, 21 Jul 2022 08:17:26 GMT

I want to do import/export using the REST API transfer functionality as explained in this video:

https://communities.sas.com/t5/SAS-Global-Forum-Proceedings/Moving-SAS-Viya-Contents-A-RESTful-Way/ta-p/726351

The REST API end point it mentions is: /transfer/exportjobs

But I can't find that documented in the REST API spec:

https://developer.sas.com/home.html

Can anyone help / explain why it isn't there?

Seems to suggest here it isn't intended for use:

https://communities.sas.com/t5/Administration-and-Deployment/Upload-JSON-package-using-REST-API/m-p/728414#M21849

But if that's the case, why did they make the video telling people how to do it?

Re: REST API documentation for transfer endpoint for import/export

BrunoMueller — Thu, 21 Jul 2022 09:13:08 GMT

Instead of using undocumented API's, I suggest to use the sas-viya transfer plugin. See some examples in the doc https://go.documentation.sas.com/doc/en/sasadmincdc/v_029/calcontentmig3x/n0u4qkc837891vn1w8pd2rbqaxzb.htm

Also have a look at this https://communities.sas.com/t5/SAS-Communities-Library/You-CAN-take-it-with-you-Saving-SAS-Viya-Content/ta-p/798055

Re: REST API documentation for transfer endpoint for import/export

aedwards9 — Thu, 21 Jul 2022 10:21:59 GMT

That's fine if that's the recommended approach - just wanted to make sure I wasn't just missing it from the documentation.

I think our main challenge will be the stipulation:

The CLI requires that the machine running the tool has access to the internet.

(https://support.sas.com/downloads/package.htm?pid=2512)

If our environment is closed network then does it mean we can't automate the import/export? If so, do you know specifically what internet access we would need to open up for it to work?

Re: REST API documentation for transfer endpoint for import/export

BrunoMueller — Thu, 21 Jul 2022 11:49:39 GMT

Only to download the tool and install the plugins you need internet access, this can be done on any system.

Once you have the sas-viya CLI and the plugins then you transfer the tool and the plugins to your machine without internet access.

See also here Advanced: Set Up a Shared Location for more information.

Re: REST API documentation for transfer endpoint for import/export

aedwards9 — Thu, 21 Jul 2022 12:19:09 GMT

Ah great good to know thanks

Re: REST API documentation for transfer endpoint for import/export

AllanBowe — Thu, 21 Jul 2022 21:25:18 GMT

Just "fyi", an alternative approach is to keep the source for your jobs in a GIT repository (subject to all the regular development workflows like branches, linting, and pipelines) and just PUSH the jobs to the relevant SAS environment for processing.

No need to export then. Your source of truth is the GIT repo.

A writeup of this approach is available here: https://communities.sas.com/t5/SAS-Global-Forum-Proceedings/Scaffolding-SAS-Projects-With-NPM-and-SASjs/ta-p/726347

Re: REST API documentation for transfer endpoint for import/export

aedwards9 — Fri, 22 Jul 2022 08:06:36 GMT

Thanks - we will be using Git for SAS code so I think we will probably go for something like that. The question was mainly for SAS VA reports - I believe they can't be integrated with / push to Git without the export, is that right?

Re: REST API documentation for transfer endpoint for import/export

AllanBowe — Fri, 22 Jul 2022 10:51:35 GMT

that's right, it's not really feasible to build JSON reports in an IDE!

We're looking to add VA export / import to the SASjs CLI (https://github.com/sasjs/cli) but it's not ready yet.

Re: REST API documentation for transfer endpoint for import/export

aedwards9 — Fri, 22 Jul 2022 10:59:35 GMT

Thanks all