cancel
Showing results for 
Search instead for 
Did you mean: 
cancel
Showing results for 
Search instead for 
Did you mean: 

How to automate Export in Thingworx

Regular Member

How to automate Export in Thingworx

We want to automate Export to ThingworxStorage for particular table. How to do this. Any idea.


Please suggest.

Tags (1)
7 REPLIES 7

Re: How to automate Export in Thingworx

Hi,

We do export a set of DataTables (We tag with a specific tag the DataTables that we want to export) through calling the API directly from Server Side Javascript, that's our code:

var APIKey = ApplicationKeys["AppKeyNameWithTheRights"].GetKeyID();

var exportURL = "YourServerURL"+"/Thingworx/DataExporter/?Accept=application/octet-stream&searchTags="+"TagForTableNamesToExport"+"&repositoryName="+"RespositoryNameWhereToStoreData"+"&path="+"PathOnFileRepository+"="+APIKey+"&_="+Math.random()

var result = Resources["ContentLoaderFunctions"].GetText({

proxyScheme: undefined /* STRING */,

headers: undefined /* JSON */,

ignoreSSLErrors: undefined /* BOOLEAN */,

useNTLM: undefined /* BOOLEAN */,

workstation: undefined /* STRING */,

useProxy: undefined /* BOOLEAN */,

withCookies: undefined /* BOOLEAN */,

proxyHost: undefined /* STRING */,

url: exportURL,

timeout: undefined /* NUMBER */,

proxyPort: undefined /* INTEGER */,

password: undefined /* STRING */,

domain: undefined /* STRING */,

username: undefined /* STRING */

});

Re: How to automate Export in Thingworx

Thanks Appreciate your response. I want to export data to some file then my SOUP webservice pick that data from file and import it to Hadoop database.

Do you thing it is possible?

I do not want anyone should directly access my database because of PCI Zone.

Re: How to automate Export in Thingworx

Hi, for SOUP do you mean SOAP ? if that's the case, why don't you call directly the SOAP service from ThingWorx and you push the data to it? Or the other way around, why from your webserver call ThingWorx and pull the data through it's RESP API?

Re: How to automate Export in Thingworx

Thanks again. Because of PCI requirement we can make any thingwrox inbound call. SOUP means Webservice call.

Re: How to automate Export in Thingworx

And outbound?

Re: How to automate Export in Thingworx

I am sorry we can make any outbound call from thingwrox not inbound call. Nobody can come inside from outside to access thingwrox..

Re: How to automate Export in Thingworx

Then I don't know man, as if no one can enter/exit how the SOUP service will enter to take the file...