Remove From My Forums. Answered by:. Archived Forums. Sign in to vote. GetString combinedColumn. GetBlobData 0, Convert. ToInt32 combinedColumn. IsNullOrEmpty jdata. ToString ; Row. Generic; using System. Linq; using System. Active Oldest Votes. Improve this answer. Alexander Alexander Dint help , The output is not in a readable format , I update the question with the output. Jamie W Jamie W 4 4 bronze badges. Sign up or log in Sign up using Google. Sign up using Facebook. Sign up using Email and Password.
Post as a guest Name. Email Required, but never shown. The Overflow Blog. Hi Marcus. Great post thanks. All the references are the same as yours. Any suggestions? Give it a try so we can try to narrow down the issue.
For example; is it a code problem or a PC configuration problem. It looks like the scriptcontrol COM object was not ported to 64 bits… dead end? The code example in the post works without issue. Would like to see if this speeds it up. Thanks, Douglas. Great code and it does exactly what I need. I too am also having issues with 64 bit here.
Any luck with getting this to work? I would be very interested in seeing this code for 64 bit. I should have the blog post updated this week with a free downloadable workbook for everyone to try out. Would really appreciate getting that workaround. If you have a workaround that would be great to see Robert. Any idea what might be causing this. The first thing to check is the raw JSON that has been returned from the website.
Is it incomplete or corrupt for example. If you step through the code, you should be able to view the contents of the items object. It should resemble an array. Interesting article, thank you for sharing it. The tool you provided the link for looks quite interesting. The JSON example in this article is very simple. However, JSON can also represent far more complex data structures. These can become quite complex with embedded data-within-data.
That is, the data can be hierarchical. In these cases it may not make sense to flatten the JSON. The other aspect to consider is what you plan to do with the flattened JSON data. This may be more difficult to represent in flattened CSV or Excel files. But when I try to include the -u agrument in my Exec Process Task, it stops and prompts me for a password.
Any thoughts on how to work around this password prompt? I did review my notes and it looks like I wrapped the user name and password together in a structure like this:. Please let me know. Your email address will not be published. Save my name, email, and website in this browser for the next time I comment. This site uses Akismet to reduce spam. Learn how your comment data is processed. Stacia Varga. May 27, pm. When I execute this task, I get a file where I expect one to land, so all is well.
That is, each row from the table that I created that identifies the different types of queries that I need to execute. Then the columns returned by the query are mapped to variables which are used inside the container: EXP Set the control flow path: This is a placeholder task.
I need a way to control whether I do a single API call the teams query or run through the same call iteratively such as when I need to process each team id individually. This path has the Expression and Constraint option set with the following expression:! This expression affects the control flow for one query type only, the teams query.
This path has the Expression and Constraint option set with the following expression: [User::iterative]. All other queries will use this control flow path. The urlSuffix1, urlSuffix2, and queryType variables come from the current iteration of the ForEach loop and I set up the filePath variable to be able to have a single place to reference the location of the JSON files.
0コメント