REST GET to SharePoint
I’m creating a Pipeline to pull data from a SharePoint list and having an issue using the REST GET with my OATH2 account I created. I am getting a 403 error Access Denied.
I did walk through the se...
Forum Discussion
Hi @mitsos,
I experimented and I put together a couple of pipelines, where I think a solution for your problem might lie. First i created some dummy data in the AzureDynamicTable pipeline for bulk load with an Azure SQL - Bulk Load Snap (which is located in the child pipeline AzureChildDynamicTable). That is because the value for the Table Name in the Snap Settings can only be passed using a pipeline parameter.
In the parent pipeline, AzureDynamicTable, I add an additional field to the documents for bulk load. The field’s name is $tableName, and I assign a value to it thusly: “dbo.temp_dailies_” + $_time.toString().substring(0,10). Then I pass it as a parameter value for the parameter name tableName of the child pipeline.
I then have to remove the extra field in a Mapper in the child pipeline.
Here are the pipelines:
AzureChildDynamicTable_2020_06_04.slp (3.9 KB) AzureDynamicTable_2020_06_04.slp (8.1 KB)
I hope you can find your answer in there.
BR
Dimitri
This works! Thank you!!!
It is a bit slow, but think it will be fine. There are about 100k rows in each pipeline.
So, _tableName → the underscore means what, exactly?
It has to be a pipeline parameter, right? How does the Execute Pipeline snap “know” to take only one value from the $tableName column?
How are you trying to call the API?
“url”: “https://elastic.snaplogic.com/api/1/rest/public/project/migrate/projects/source”,
“method”: “POST”Returns:
“The asset does not exist: /projects/source”
“url”: “https://elastic.snaplogic.com/api/1/rest/public/project/migrate/{{OrgName}}/projects/source”,
“method”: “POST”Returns:
“Expecting type of asset [/{{OrgName}}/] to be Dir but was Org”
It’s not clear from the documentation where/how to extract the correct values from the Manager and when I enter exact values from the activities API response it still cannot locate them.
I’ve let your TAM know and there is now an open ticket for the docs to be clarified.
