BookmarkSubscribeRSS Feed
☑ This topic is solved. Need further help from the community? Please sign in and ask a new question.
aedwards9
Calcite | Level 5

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/t...

 

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/...

 

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

1 ACCEPTED SOLUTION
8 REPLIES 8
aedwards9
Calcite | Level 5

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?

BrunoMueller
SAS Super FREQ

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.

aedwards9
Calcite | Level 5

Ah great good to know thanks

AllanBowe
Barite | Level 11

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-SA...

/Allan
SAS Challenges - SASensei
MacroCore library for app developers
SAS networking events (BeLux, Germany, UK&I)

Data Workflows, Data Contracts, Data Lineage, Drag & drop excel EUCs to SAS 9 & Viya - Data Controller
DevOps and AppDev on SAS 9 / Viya / Base SAS - SASjs
aedwards9
Calcite | Level 5

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?

AllanBowe
Barite | Level 11
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.
/Allan
SAS Challenges - SASensei
MacroCore library for app developers
SAS networking events (BeLux, Germany, UK&I)

Data Workflows, Data Contracts, Data Lineage, Drag & drop excel EUCs to SAS 9 & Viya - Data Controller
DevOps and AppDev on SAS 9 / Viya / Base SAS - SASjs

sas-innovate-2024.png

Available on demand!

Missed SAS Innovate Las Vegas? Watch all the action for free! View the keynotes, general sessions and 22 breakouts on demand.

 

Register now!

How to Concatenate Values

Learn how use the CAT functions in SAS to join values from multiple variables into a single value.

Find more tutorials on the SAS Users YouTube channel.

Click image to register for webinarClick image to register for webinar

Classroom Training Available!

Select SAS Training centers are offering in-person courses. View upcoming courses for:

View all other training opportunities.

Discussion stats
  • 8 replies
  • 1390 views
  • 1 like
  • 3 in conversation