topic Re: How to automate Export in Thingworx in ThingWorx Developers

How to automate Export in Thingworx

RaajeevHDave — Thu, 23 Nov 2017 13:19:02 GMT

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

Please suggest.

Re: How to automate Export in Thingworx

CarlesColl — Thu, 23 Nov 2017 15:38:53 GMT

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

RaajeevHDave — Fri, 24 Nov 2017 06:40:42 GMT

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

CarlesColl — Fri, 24 Nov 2017 09:59:22 GMT

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

RaajeevHDave — Fri, 24 Nov 2017 10:10:58 GMT

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

Re: How to automate Export in Thingworx

CarlesColl — Fri, 24 Nov 2017 10:34:38 GMT

And outbound?

Re: How to automate Export in Thingworx

RaajeevHDave — Fri, 24 Nov 2017 10:37:22 GMT

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

CarlesColl — Fri, 24 Nov 2017 13:48:01 GMT

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